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)
Version:
(earliest affected)
4.1.5.3 release
Hardware: x86-64 (AMD64) Windows (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
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:

Attachments
The result (54.86 KB, image/jpg)
2014-05-30 05:54 UTC, Andrew 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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...
Thanks
Comment 1 bfoman (inactive) 2014-05-30 15:57:19 UTC 

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