https://bugs.documentfoundation.org/show_bug.cgi?id=165759
Bug ID: 165759
Summary: FILEOPEN XLSX Formula with external link not imported
correctly in certain spreadsheet
Product: LibreOffice
Version: 3.3.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: filters and storage
Assignee: [email protected]
Reporter: [email protected]
Blocks: 104839, 108897, 112071
Created attachment 199824
--> https://bugs.documentfoundation.org/attachment.cgi?id=199824&action=edit
Sample XLSX
The attached XLSX, created from minimizing forum-mso-en4-144022.xlsx, contains
an external reference in A1, and when it is opened in Excel, the formula reads
something like this:
='D:\Users\Peter\Dropbox\Excel Trips\[Holiday trip planner to Alice
Springs.xlsx]Sheet15'!C0
(the external link is relative, the beginning will be where the file was opened
from)
Opening the same file in Calc shows this incorrect formula in A1:
=[1]sheet15!c0
Saving the file back to XLSX makes Excel complain about the file, choosing
repair removes the formula, with the following message:
Removed Records: Formula from /xl/worksheets/sheet1.xml part
Observed using LO 25.8.0.0.alpha0+ (9299d425f3ed941d983f68d6dc1e979b4d4d1060)
and 3.3.0 / Windows.
The link, as exists in xl/externalLinks/_rels/externalLink1.xml.rels inside the
original archive is:
Users/Peter/Dropbox/Excel%20Trips/Holiday%20trip%20planner%20to%20Alice%20Springs.xlsx
The formula that is stored in the sheet's XML file in A1 is: [1]Sheet15!C0
Apparently, this is normal notation. Also attaching a different sample Excel
XLSX, where the external link is correctly imported and saved in Calc.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=104839
[Bug 104839] [META] Saved XLSX files that MS Excel can't open
https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
https://bugs.documentfoundation.org/show_bug.cgi?id=112071
[Bug 112071] [META] Linked external data issues in Calc
--
You are receiving this mail because:
You are the assignee for the bug.
