I've received file, made in MS Office 2003 (original.xls in attachment). When I'm opening it in MS Office 2007 or OpenOffice.org 3.0.0 it works fine (msoffice2007.jpg) In LibreOffice (3.3 release and 3.3.1 rc1): When I'm opening it without updating links, in sheet "взвеш дистрибуция" I see Err:504 (original_504.jpg) When I'm opening it with updating links I see Err:502 (original_502.jpg) I've tried to re-save this file in .xlsx (saved_as_xlsx.xlsx) and open it in LibreOffice and get an Err:509 (saved_as_xlsx_509.jpg) Sorry for Russian in spreadsheet and screenshots.
attachment is 5.51mb, so uploaded it to rapidshare http://rapidshare.com/files/447934714/archive.zip
Reproduced with LO 3.3 RC4 Ubuntu 10.04 x86 except not error 509 but freezing on saved_as_xlsx.
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.
(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.
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian
confirmed by downstream bug -> reopen
Never confirmed by QA team - moving to UNCONFIRMED.
Tested with LO 4.3.2.2, win7. Steps from comment 4, closing as worksforme because no Err:XXX appear. Tested with .ods, .xlsx and .xls.
Created attachment 108836 [details] printscreen