<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:kelemeng@ubuntu.com" title="Gabor Kelemen <kelemeng@ubuntu.com>"> <span class="fn">Gabor Kelemen</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Link to cell in external document doesn't work (wrong file URL)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121472">bug 121472</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Blocks</td>
<td>
</td>
<td>112071
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>DUPLICATE
</td>
<td>---
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>RESOLVED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">See Also</td>
<td>
</td>
<td>https://bugs.documentfoundation.org/show_bug.cgi?id=111876
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Link to cell in external document doesn't work (wrong file URL)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121472#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Link to cell in external document doesn't work (wrong file URL)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121472">bug 121472</a>
from <span class="vcard"><a class="email" href="mailto:kelemeng@ubuntu.com" title="Gabor Kelemen <kelemeng@ubuntu.com>"> <span class="fn">Gabor Kelemen</span></a>
</span></b>
<pre>This is the first report of path duplication of cell references in XLSX files.
Not a duplicate, since this started in 6.0 with:
<a href="https://cgit.freedesktop.org/libreoffice/core/commit/?id=51e610e584e09ecdec4cbc5c7c550bc806d7ee1c">https://cgit.freedesktop.org/libreoffice/core/commit/?id=51e610e584e09ecdec4cbc5c7c550bc806d7ee1c</a>
author Szymon Kłos <<a href="mailto:szymon.klos@collabora.com">szymon.klos@collabora.com</a>> 2017-08-24 09:59:42 +0200
committer Szymon Kłos <<a href="mailto:szymon.klos@collabora.com">szymon.klos@collabora.com</a>> 2017-08-25 09:58:15
+0200
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - Links to Windows shares become corrupted in XLSX after save"
href="show_bug.cgi?id=111876">tdf#111876</a> 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="<a href="http://schemas.openxmlformats.org/package/2006/relationships">http://schemas.openxmlformats.org/package/2006/relationships</a>">
<Relationship Id="rId1"
Type="<a href="http://schemas.openxmlformats.org/officeDocument/2006/relationships/externalLinkPath">http://schemas.openxmlformats.org/officeDocument/2006/relationships/externalLinkPath</a>"
Target="Target.xlsx" TargetMode="External"/>
</Relationships>
This changes in the newer versions to have:
Target="home/gabor/Documents/Target.xlsx"</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] Linked external data issues"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112071">Bug 112071</a>] [META] Linked external data issues
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>