I'm having trouble migrating certain files to LibreOffice from OpenOffice containing IF statements to external sheets.
The following IF statement works fine in OpenOffice, but but results in Err:504 (Error in paramter list): =IF(('file:///home/figueroa/Documents/da/enws/enws2011/enwssumm_hs.ods'#$Sheet1.$E$17)=1,1,0) However, the following reference to that file works fine: ='file:///home/figueroa/Documents/da/enws/enws2011/enwssumm_hs.ods'#$Sheet1.E1 This error only occurs in combination with the =IF statement. I'm running under Gentoo. This has been tested and verified after installing the program from binary and source. I don't know if this is a real bug, or if I need to set something to make this work right. Andy Figueroa -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted