Calc - Pasting links relative to a folder

users
#1

Hi

Calc - Pasting links relative to a folder

I have spreadsheets named '2012' '2013' in a folder and within each
spreadsheet end result info for each year. In the same folder I want to have
a spreadsheet named 'combine' that combines the data from the two year
spreadsheets. Can I/is there away to paste the data from the two year
spreadsheets into the combine spreadsheet but have the links relative to the
folder all three sheets are within - not relative to the actual storage
system (in this case a NAS)

#2

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

In the help.
"
Save URLs relative to file system
This option allows you to select the default for relative addressing of URLs
in the file system and on the Internet. Relative addressing is only possible
if the source document and the referenced document are both on the same
drive.
A relative address always starts from the directory in which the current
document is located. In contrast, absolute addressing always starts from a
root directory. The following table demonstrates the difference in syntax
between relative and absolute referencing:
Examples
File system
Internet
relative
../images/img.jpg
../images/img.jpg
absolute
file:///c|/work/images/img.jpg
http://myserver.com/work/images/img.jpg

The Help tip always displays an absolute path. However, if a document is
saved in HTML format, LibreOffice will enter a relative path if the
appropriate check box is selected.
"
Miguel Ángel.