Summary: | XLS/XSLX Calc corrects hyperlinks at save and open | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Sergey Savko <heretic_tr4> |
Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | normal | ||
Priority: | high | CC: | ign_christian, stephane.guillou, thomas-libo |
Version: | 3.5.0 release | ||
Hardware: | All | ||
OS: | Linux (All) | ||
See Also: | https://bugs.freedesktop.org/show_bug.cgi?id=64431 | ||
Whiteboard: | BSA | ||
i915 platform: | i915 features: |
Description
Sergey Savko
2012-01-31 03:42:14 UTC
This is not a bug actually as LibreOffice has the following option enabled by default: Tools -> Options -> Load/Save -> General -> Save URLs relative to file system When you use Insert -> Hyperlink to create a hyperlink to a file in the file system, Calc saves a relative path from the document to the linked file. For example, if you are editing /home/user/Desktop/test.ods and insert a hyperlink to /home/user/Desktop/a.pdf Calc internally saves the following path: ../a.pdf (ODS is actually a ZIP archive. You can copy test.ods to test.zip and then open in with an archiver. There is the content.xml file inside the archive in which you can see the "../a.pdf" path.) If you move the spreadsheet to /home/user/Documents/test.ods the hyperlink now links to /home/user/Documents/a.pdf (/home/user/Documents/test.ods + ../a.pdf = /home/user/Documents/a.pdf) although the text shown in the cell still reads /home/user/Desktop/a.pdf which can be corrected by Insert -> Hyperlink. This behaviour can be very useful if you have a set of linked files and move them as a group keeping their relative positions in the file system. If you want that hyperlinks use absolute paths then disable the following option: Tools -> Options -> Load/Save -> General -> Save URLs relative to file system I've tested this in LibO Calc 3.5.0 on Ubuntu 11.10. Hmm, you right. In version 3.3.4 it does not work, in 3.5.0 work fine. Thank you very much LibreOffice 3.5.1. So, if i save in ods it's works. If i'm save file in xls, hyperlinks is wrong. Hi Sergey, is it still happen on latest stable release? Reproduced on Windows 7 with: Version: 4.1.2.3 Build ID: 40b2d7fde7e8d2d7bc5a449dc65df4d08a7dd38 When saving as XLS or XSLX and moving the file afterwards the link is broken. This is getting very confusing: I just tested this in LO 4.3.3.2 on Ubuntu 14.04: 1. Insert hyperling to document in cell A1 in new spreadsheet 2. Save either in ods, xls or xlsx 3. Move the linked document to a diffent folder None of the three formats updated the path, even though the box for "Save URLs relative to file system" is ticked! |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.