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: [email protected] 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
