Ask Your Question

search hyperlink

asked 2015-04-02 09:14:32 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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: on Ubuntu.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2015-04-02 11:06:32 +0200

karolus gravatar image


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" )
edit flag offensive delete link more

answered 2015-04-02 13:26:47 +0200

edwerf gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-04-02 09:14:32 +0200

Seen: 400 times

Last updated: Apr 02 '15