Ask Your Question
0

Calc: How to link to local files in a spreadsheet and transfer to different computer?

asked 2015-02-17 02:16:27 +0200

Hitch gravatar image

I want to link to a local file in my spreadsheet and transfer that spreadsheet (and the file) to a different computer, without breaking the link.

For Example: Suppose I had a folder containing two separate folders e.g. 'Spreadsheets' and 'Files'. And on my spread sheet saved in the 'Spreadsheets' folder, I link to a file located in the 'Files' folder. Is there anyway I could make the destination of the hyperlink something like "../Files/example.jpg", So that when I copy The main folder containing these files to a different computer the link still works?

Sorry if this is confusing and thanks for any help in advance.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2015-02-17 02:49:55 +0200

m.a.riosv gravatar image

I think the option in Menu/Tools/Options/LoadSave - Save URLs relative to file system, must work, don't worry if you see the whole path in the cell.

https://help.libreoffice.org/scalc/cu...

edit flag offensive delete link more

Comments

Thanks! You're right. Exactly what I wanted.

Hitch gravatar imageHitch ( 2015-02-17 03:17:01 +0200 )edit

Sounds nice... but when I control-click such a link, I get

"Microsoft.Explorer.Notification.{9C7AFFC7-DBBD-7901-5E08-3F415DD3661C}.png" is not an absolute URL that can be passed to an external application to open it.

So does that mean I should specify a fully-qualified URL to the file C:\temp\file But when I try it, then move it, it doesn't work.

guruglenn gravatar imageguruglenn ( 2015-12-11 06:12:03 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-02-17 02:16:27 +0200

Seen: 2,163 times

Last updated: Feb 17 '15