[libreoffice-users] IF statement linking external sheet error

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+help@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