https://bugs.documentfoundation.org/show_bug.cgi?id=121472
Gabor Kelemen <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Blocks| |112071
Ever confirmed|0 |1
Resolution|DUPLICATE |---
Status|RESOLVED |NEW
See Also| |https://bugs.documentfounda
| |tion.org/show_bug.cgi?id=11
| |1876
--- Comment #2 from Gabor Kelemen <[email protected]> ---
This is the first report of path duplication of cell references in XLSX files.
Not a duplicate, since this started in 6.0 with:
https://cgit.freedesktop.org/libreoffice/core/commit/?id=51e610e584e09ecdec4cbc5c7c550bc806d7ee1c
author Szymon Kłos <[email protected]> 2017-08-24 09:59:42 +0200
committer Szymon Kłos <[email protected]> 2017-08-25 09:58:15
+0200
tdf#111876 Save correct relative links in Calc
I'll attach example files. To reproduce:
Have a file named Target.xlsx with some contents and create a new file with
simple cell reference to this file: = + click on the cell in the other Calc
dialog:
='file:///home/gabor/Documents/Target.xlsx'#$Sheet1.C2
This is saved correctly in ods format, but not in XLSX when "Save URLs relative
to file system" is enabled on Options - Load/Save - General and the files are
next to each other or below in the file system. Resulting cell reference will
be:
='file:///home/gabor/Documents/home/gabor/Documents/Target.xlsx'#$Sheet1.C2
This somehow happens only on Linux/Mac and not on Windows.
Relevant XLSX snippet:
/xl/externalLinks/_rels/externalLink1.xml.rels
<?xml version="1.0" encoding="UTF-8"?>
<Relationships
xmlns="http://schemas.openxmlformats.org/package/2006/relationships";>
<Relationship Id="rId1"
Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/externalLinkPath";
Target="Target.xlsx" TargetMode="External"/>
</Relationships>
This changes in the newer versions to have:
Target="home/gabor/Documents/Target.xlsx"
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=112071
[Bug 112071] [META] Linked external data issues
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
