(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.
(In reply to comment #3) /bugs.launchpad .net/ubuntu/ +source/ openoffice. org/+bug/ 512413.
> 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:/
>
> The issue has not been treated yet, at least in LibreOffice 3.3.1.
Steps to reproduce the error: ///[path_ to_the_ folder] /teste. ods'#$Planilha1 .A9=C9; 'file:/ //[path_ to_the_ folder] /teste. ods'#$Planilha1 .B9;15)
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:
4 - Save test1.ods.
Even if you mark all cells in both spreadsheets as numeric format, the error still happens.