Ask Your Question
0

How do I force Calc to use relative hypertext links? [closed]

asked 2014-06-15 16:22:33 +0100

kevn57 gravatar image

updated 2014-06-15 22:27:28 +0100

I'm trying to migrate away from Excel, I have a large spreadsheet that I want to use in Calc but my problem is that the spreadsheet links to word documents. It's basically a set of multiple lists, DVD, TV Shows, Music. The individual items are each linked to a word document. Libre does a fine job of reading the documents, but Excel stores the local links as relative links, I can't find a way to make Calc do the same thing. When I add a hyperlink to a Writer file it's absolute which means my data is no longer portable. Is there a way to force calc to use relative linking.

[Copied from answer by OP]
I have both Save URL relative to file system and Save URL relative to internet checked already, but when I go into insert hyperlink in the menu, it opens hyperlink window when I browse to the document it inserts the full path. (C:\Data\Documents\My Documents\excel\Video_13\Cosmos A Spacetime Odyssey.odt). This way I can't move my \Video directory to my linux box and have it work as all the links will be broken except for the old links that Excel inserted.

Thank You very much mariosv, it works just like you said. I added a new entry on my PC moved the calc spreadsheet to Lubuntu along with the file I was linking to and voila it worked perfectly. I think if it's possible for the programmers to change the way full links are shown when only relative links are stored it would be more transparent for the end user.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-25 10:17:45.937217

Comments

Please add replies to answers as a comment below that answer, not as an appendix to the question :) Also, if your question was answered, please mark it as 'correct'. Thanks!

bencomp gravatar imagebencomp ( 2014-06-15 23:37:22 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2014-06-15 16:33:20 +0100

m.a.riosv gravatar image

There is an option in:
Menu/Tools/Options/Load-Save/Genera - Save URL relative to file system.

https://help.libreoffice.org/Common/G...

edit flag offensive delete link more
0

answered 2014-06-15 17:37:02 +0100

kevn57 gravatar image

I have both Save URL relative to file system and Save URL relative to internet checked already, but when I go into insert hyperlink in the menu, it opens hyperlink window when I browse to the document it inserts the full path. (C:\Data\Documents\My Documents\excel\Video_13\Cosmos A Spacetime Odyssey.odt). This way I can't move my \Video directory to my linux box and have it work as all the links will be broken except for the old links that Excel inserted.

edit flag offensive delete link more

Comments

I put the text of this answer inside the question, as it does not answer the question.

bencomp gravatar imagebencomp ( 2014-06-15 20:00:38 +0100 )edit

I think even you see the full path, relative is saved. Pls do a try.

m.a.riosv gravatar imagem.a.riosv ( 2014-06-15 20:09:49 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2014-06-15 16:22:33 +0100

Seen: 2,032 times

Last updated: Jun 15 '14