Search hyperlink

[edwerf]

I would like to find a hyperlink in Libre Calc with the V-Lookup command. By clicking this lookup cell I would like to open my odt file which is located at my memory stick.

If the link is about a website it works. But when I try to open an .odt file I get the error “is not an absolute URL that can be passed to an external application to open it”.

Do I make a mistake, is it a bug or maybe I want to do something which is not possible? The version of my Libre Office is Version: 4.3.3.2 on Ubuntu.

[karolus]

Hallo

you need the target-path in URL-syntax with /slashes instead \backslashes and prefixed by file:///

if your VLOOKUP(...) returns only the path without file:///-prefix, try something like:

=HYPERLINK("file:///" & VLOOKUP( ... ); "click me" )

[edwerf]

Thank you very much for your quick respond. It works!!