[libreoffice-users] Re: relative HYPERLINK

Am 15.08.2012 17:01, chilobo wrote:
> Hello!
>
> I'm working with Libre Office 3.6.0.4 on Windows 7 64-bit.
> In Calc I used the formula
> =HYPERLINK(VERKETTEN("B\";B974;".jpg");VERKETTEN("B\";B974;".jpg"))
> to produce an Hyperlink to a local Image based on the reference to B974.
> When moving the cursor above the cell the corresponding destination is shown
> and is OK (and its relative).
>
> When clicking oder Strg-clicking on the cell I get:
> B\20123.jpg ist keine absolute URL, die zum Öffnen an eine externe Anwendung
> übergeben werden kann.
>
> something like "Cannot submit URL to external Application because URL is
> relative."
>
> When I produce an absolute URL it works fine.
> Exporting to Excel with relative URL works.

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.


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