Ubuntu
openoffice.org package

  1. Bug #512413
  2. Comment #10

Comment 10 for bug 512413

Revision history for this message
In , Paulo de Souza Lima (paulo-s-lima) wrote :

(In reply to comment #3)
> That does not happens only with MsOffice files. That happens with any formula
> which tries to link an external spreadsheet. That happens also in Ubuntu Linux
> (32bit/64bit), and it was reported before (one year ago) at
> https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/512413.
>
> The issue has not been treated yet, at least in LibreOffice 3.3.1.

Steps to reproduce the error:
1 - create an empty spreadsheet called teste.ods and save it.
2 - create another spreadsheet called test1.ods and save it in the same folder as teste.ods.
3 - Place the following formula to any cell in test1.ods: =IF('file:///[path_to_the_folder]/teste.ods'#$Planilha1.A9=C9;'file:///[path_to_the_folder]/teste.ods'#$Planilha1.B9;15)
4 - Save test1.ods.

Even if you mark all cells in both spreadsheets as numeric format, the error still happens.