Bug 79436 - Cell reference to external spreadsheet yields Err.509 once saved and re-opened (.xlsx)
Summary: Cell reference to external spreadsheet yields Err.509 once saved and re-opene...
Status: RESOLVED DUPLICATE of bug 45286
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium major
Assignee: Not Assigned
Depends on:
Reported: 2014-05-30 05:54 UTC by Andrew
Modified: 2014-05-30 15:57 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

The result (54.86 KB, image/jpg)
2014-05-30 05:54 UTC, Andrew

Note You need to log in before you can comment on or make changes to this bug.
Description Andrew 2014-05-30 05:54:50 UTC
Created attachment 100141 [details]
The result

When I create the reference it looks like this: ='file:///c:/users/andrew/documents/shinju 2014/treasurer/myob2014/murakami2014_050514.xlsx'#$'The sheet'.$C$4
 I save the book Using XLSX format (I have to work with excel people) 
I now close the sheet. 
I re-open the sheet - err.509 replaces previously correctly displayed data.
This is what the cell now reads as the reference: =['file:///c:/users/andrew/documents/shinju 2014/treasurer/myob2014/murakami2014_050514.xlsx']'the sheet'!$c$4 
So somewhere in the saving and re-opening phase we have acquired a set of square brackets, lost a # and $ and exchanged a . for a ! Result equals useless...
Comment 1 bfoman (inactive) 2014-05-30 15:57:19 UTC

*** This bug has been marked as a duplicate of bug 45286 ***