<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Links to Windows shares become corrupted in XLSX after save"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111876">111876</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Links to Windows shares become corrupted in XLSX after save
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>4.0.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>baron@caesar.elte.hu
</td>
</tr>
<tr>
<th>Blocks</th>
<td>104742
</td>
</tr></table>
<p>
<div>
<pre>Preparation:
- Have a Windows share, and another computer with LibreOffice that will access
(and write to) the share.
- Add a file, let's say a DOCX (to be the target for a link) in
\\<share>\<path1>\linktarget.docx
- In \\<share>\<path2> (so, a different path) create a new XLSX spreadsheet,
and add a link inside that points to \\<share>\<path1>\linktarget.docx
The way to do that is to open Insert -> Hyperlink..., switch to Document and
enter \\<share>\<path1>\linktarget.docx in Path: field and click OK.
It can be verified that the OOXML archive contains the link in file
xl\worksheets\_rels\sheet1.xml.rels in the form of
'file:///\\<share>\<path1>\linktarget.docx' (this is the same format as if it
had been created in Excel).
Now reopen the spreadsheet, and save it once again as XLSX.
=> The link becomes 'file:///<path1>\linktarget.docx'. It can be verified by
hovering over the link after reopening the spreadsheet, or by looking at the
file mentioned above inside the archive. The link is incorrect, and doesn't
point to the document.
The behavior probably depends on setting 'Save URLs relative to file system' in
Options -> Load/Save -> General, but this is not a correct relative link, that
should start with "..\.." until the common part/root of path1 and path2 is
reached.
Interestingly despite the setting 'Save URLs relative to file system', the
initial save saves an absolute link.
Ultimately I don't think links to network shares should ever be saved as
relative links, even if they're on the same share, or even if they're mapped to
a local drive, regardless of the relative/absolute setting.
Observed using LO 5.4.1.1 & 4.0.0.3 / Windows 7.</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] Network-involved bugs"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=104742">Bug 104742</a>] [META] Network-involved bugs
</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>