I have a set of worksheets that reference cells between them. They are saved
as *.xls files since I have built them since the late '90's. The links
don't work through LibreOffice on Windows XP.
The link equation is written
='file:///M:/cw_documents/TRACK.XLS'#$Blank.$C$16
when LibreOffice saves the sheet and I read it back (either Libre or
OpenOffice calc)
='file:///M:/cw_documents/TRACK.XLS'#$".$C$16
Missing the sheet name (replaced with a quote mark) makes all links fail.
Charlie
--
View this message in context:
http://nabble.documentfoundation.org/IF-statement-linking-external-sheet-error-tp2884993p2941610.html
Sent from the Users mailing list archive at Nabble.com.
--
Unsubscribe instructions: E-mail to [email protected]
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
