[Libreoffice-bugs] [Bug 121472] Link to cell in external document doesn't work (wrong file URL)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121472

Gabor Kelemen <kelemeng at ubuntu.com> 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 <kelemeng at ubuntu.com> ---
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 <szymon.klos at collabora.com> 2017-08-24 09:59:42 +0200
committer       Szymon Kłos <szymon.klos at collabora.com> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201026/f2432a20/attachment.htm>