Hi If I need to go up one directory and then down two, the following formulae works in excel.

In Libre I seem to need to create an absolute path with the drive letter specified, this creates problems with portability from one PC or OS to another. How best in Libre to achieve the same relativity. I have specified Save URLS as relative to file system, but still the drive letter remains, it is not referencing the directory TOP but the Drive letter. Perhaps I have missed something critical, and have tried to research this but came up empty handed.

Have a beautiful day Bob

edit retag close merge delete

1

( 2018-07-10 20:47:16 +0200 )edit

Sort by » oldest newest most voted

Relative paths can be obtained by going to Insert -> Hyperlink. The full path is shown; however, it is in fact saved as relative because the file can be moved and it still works.

Sadly, this does not work with the HYPERLINK function. Only absolute paths are possible. A workaround is to include the path to the current document, as explained at https://forum.openoffice.org/en/forum.... For this formula to work, regular expressions must be enabled under Tools -> Options -> LibreOffice Calc -> Calculate.

=MID(CELL("filename");2;SEARCH("/[^/]+'#";CELL("filename"))-1)


more

Note that for URIs you have to use / forward slashes instead of \ backslash, independent of OS. Also, as this uses regular expressions it won't work in Excel and other formula expressions / functions in your document that understand either wildcards or regular expressions will be affected as well by the Tools Options setting.

( 2018-07-10 21:54:59 +0200 )edit
2

As a side note, the next version 6.2 may support relative references as URI references when clicking a HYPERLINK() result.

( 2018-07-12 17:44:59 +0200 )edit
( 2018-07-13 07:52:00 +0200 )edit

Thank You... Trust Villeroy, a Knight of the GNU Office Round table. One day we need to gather all his notes into a book. Look forward to 6.2. Have a beautiful day Bob

( 2018-07-15 18:41:55 +0200 )edit