[calc] how to insert a relative path in a cell to open file ?

users
#1

Hi,

I'm working on a central document in CALC that should be later convert to PDF.
in a column i would like to have relative path in such manner that if a user click on the link it open the file at this path.
However i discover that everything is not relative but only absolute path.

so till now it is on my hard disk, but later on it will be on a DVD and the absolute path will not work.

so how to do to have relative path ?

e.g. on my hard disk:
C:\lawyers\videos
C:\lawyers\recordings
C:\lawyers\emails
C:\central doc.pdf

next on DVD
E:\lawyers\videos
E:\lawyers\recordings
E:\lawyers\emails
E:\central doc.pdf

in the cell i have for example
C:\lawyers\videos\2014.03.12 - meeting with customer 123.avi

and i just would like to have
videos\2014.03.12 - meeting with customer 123.avi
and to allow a simple click opening.

thx

#2

Hi,

I'm working on a central document in CALC that should be later convert
to PDF.
in a column i would like to have relative path in such manner that if a
user click on the link it open the file at this path.
However i discover that everything is not relative but only absolute path.

so till now it is on my hard disk, but later on it will be on a DVD and
the absolute path will not work.

[Solved] Hyperlink - Relative references: