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

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
--

Best Regards

Alain R.

The information contained in this e-mail message is privileged and 
confidential and is for the exclusive use of the addressee. The person 
who receives this message and who is not the addressee, one of his 
employees or an agent entitled to hand it over to the addressee, is 
informed that he may not use, disclose or reproduce the contents 
thereof. Please do not disclose the contents to anyone, but notify the 
sender by return email and delete this email (and any attachments) from 
your system. Thank you.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted