[libreoffice-users] Re: relative HYPERLINK

Andreas Säger wrote
>  wrote:
>
> Excel does not even know what an URL is. Excel uses Windows specific 
> path names.
>
> Open some local *.html file in your favourite browser and look at the 
> file:// URL in the address bar.
> More specific information about the internet world:
> > http://de.wikipedia.org/wiki/URL
>
> Save the document somewhere so it has some path.
> Tools>Options>Calc>Calculation: "Enable regular expressions in formulae"
> Insert>Names>Insert [Ctrl+F3]
> [Add]
> Name: MyPath (or something else)
> "Range" (idiotic label since "named ranges" are formula expressions):
> MID(CELL("filename");2;SEARCH("/[^/]+$";CELL("filename"))-1)
> in German:
> TEIL(ZELLE("filename");2;SUCHEN("/[^/]+$";ZELLE("filename"))-1)
> [Add], [OK]
>
> Test with cell formula =MyPath should return the URL-path including a 
> trailing slash.
>
> =HYPERLINK(MyPath&"B/"&B974&".jpg") creates a hyperlink pointing to a 
> .jpg file in subdirectory B with the name in cell B974.
> chived and cannot be deleted

I was thinking about a similar solution: My users of the spreadsheet would
have to enter the absolute directory where they store the spreadsheet (and
the directory for the images) and I would use this path to produce an
absolute path. 

This enlarges my sheet and because I also have hardlinked (without formula,
just relative links) data in the spreadsheet requires further action ....

Why can't Calc handle relative links correctly?

Thank you for your answer.



--
View this message in context: 
http://nabble.documentfoundation.org/relative-HYPERLINK-tp4001526p4001542.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+help@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