https://bugs.freedesktop.org/show_bug.cgi?id=45435

[email protected] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|                            |INVALID

--- Comment #1 from [email protected] 2012-03-03 06:45:35 PST ---
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.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to