Calc Guide

Note
The reference for a file has three forward slashes /// and the
reference for a hyperlink has two forward slashes //.
Hyperlinks and URLs
Hyperlinks can be used in Calc to jump to a different location from
within a spreadsheet and can lead to other parts of the current file, to
different files or even to web sites.
Relative and absolute hyperlinks
Hyperlinks can be stored within your file as either relative or absolute.
A relative hyperlink says, Here is how to get there starting from where
you are now (meaning from the folder in which your current document
is saved) while an absolute hyperlink says, Here is how to get there no
matter where you start from.
An absolute link will stop working only if the target is moved. A
relative link will stop working only if the start and target locations
change relative to each other. For instance, if you have two
spreadsheets in the same folder linked to each other and you move the
entire folder to a new location, a relative hyperlink will not break.
To change the way that OOo stores the hyperlinks in your file, select
Tools > Options > Load/Save > General and choose if you want
URLs saved relatively when referencing the File System, or the
Internet, or both.
Calc will always display an absolute hyperlink. Don’t be alarmed when
it does this even when you have saved a relative hyperlink—this
‘absolute’ target address will be updated if you move the file.
Note
Make sure that the folder structure on your computer is the
same as the file structure on your web server if you save your
links as relative to the file system and you are going to upload
pages to the Internet.
Tip
When you rest the mouse pointer on a hyperlink, a help tip
displays the absolute reference, since OOo uses absolute path
names internally. The complete path and address can only be
seen when you view the result of the HTML export (saving the
spreadsheet as an HTML file), by loading the HTML file as Text,
or by opening it with a text editor.
Chapter 10 Linking Calc Data 303