https://bugs.documentfoundation.org/show_bug.cgi?id=148942
Bug ID: 148942
Summary: FILESAVE Calc corrupts external file references in
XLSX files making Excel unable to open
Product: LibreOffice
Version: 6.4.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
We get sent XLSX files by a supplier (an order form). These contain links to
external data sources that we do not have access to. The path varies, but
inevitably, when we send it back with our changes, it doesn't open in Excel
(2016 is what they're using, but we have a computer with 365 kept up to date
that does the same).
I have done some basic testing (Ubuntu 22.4 LO7.3.2.1) and found the issue
appears to be LibreOffice changing the "Target=" value in
"xl/externalLinks/_rels/externalLink<n>.xml.rels". Specifically,
"file://C:/path/to/file.xls" in that Target is replaced with
"../../../../C:/path/to/file.xls" on Linux, or on Windows (Win10 LO6.4.4.2), it
seems to strip out the part before a space in the filename (the filename has
multiple spaces - break is on the first one).
I have manually changed the broken Target= value in one of the Linux created
test files back to what the source file had originally, and Excel is then happy
to open it.
I have only done basic testing on one specific file, as I don't have access to
Excel myself, but the issue has been across dozens of files for some time.
Steps to Reproduce:
1. Create xlsx file with Excel (2016) that contains links to external data
sources by full path
2. Open xlsx file in LO
3. Save as new file still in XLSX format
4. Attempt to open in Excel
Actual Results:
Excel reports corruption and asks to recover.
Expected Results:
File should open without error. LO should not change the target path for an
external link.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.3.2.1 / LibreOffice Community
Build ID: 30(Build:1)
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.2~rc1-0ubuntu2
Calc: threaded
NOTE: We also have had this issue in older Ubuntu builds such as whatever is in
Ubuntu 20.10, aswell as on Windows with LO6.x, and this is occuring on multiple
machines for multiple users.
I can supply example files if necessary.
--
You are receiving this mail because:
You are the assignee for the bug.
