Created attachment 46230 [details] Sheet with =IF to external file results in Err:504 (cell A1) Sheets with =IF statement to external sheet give Err:504, "Error in parameter list." Identified originally under Gentoo binary installation of lIbreoffice-bin. Confirmed under Gentoo source installation of libreoffice. Reconfirmed under up-to-date Mint Debian Edition. Sheets were being migrated from OpenOffice where they work as normal. Simplified example attached: iferror1.ods and iferror2.ods (I cannot upload both sheets in bug report. I will add the second sheet in a comment.) Example link to external sheet (cell A1 of attachment): =IF('file:///home/figueroa/Documents/iferror2.ods'#$Sheet1.A1=1,1,0) Gives Err:504 Example link to internal sheet (cell A2 of attachment): =IF(Sheet2.A1=1,1,0) Works fine Example link to external sheet without IF statement (cell A3 of attachment): ='file:///home/figueroa/Documents/iferror2.ods'#$Sheet1.A5 Also works fine, displaying content of external file, Sheet1, cell A5. Andy Figueroa figueroa@andyfigueroa.us
Created attachment 46231 [details] Example external file for this bug.
[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
(In reply to comment #2) > [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 I can confirm that this bug does not appear to exist in 3.4.3.2-r1 installed as libreoffice-bin under Gentoo.
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
in 3.6.1 not reproduced, changing to WFM