[Libreoffice-bugs] [Bug 111876] New: Links to Windows shares become corrupted in XLSX after save

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Aug 17 08:53:43 UTC 2017


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

            Bug ID: 111876
           Summary: Links to Windows shares become corrupted in XLSX after
                    save
           Product: LibreOffice
           Version: 4.0.0.3 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: LibreOffice
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: baron at caesar.elte.hu
            Blocks: 104742

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.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=104742
[Bug 104742] [META] Network-involved bugs
-- 
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/20170817/c8f62ab7/attachment.html>


More information about the Libreoffice-bugs mailing list