[libreoffice-users] Re: relative HYPERLINK

Am 15.08.2012 18:12, schrieb Andreas Säger [via Document Foundation Mail
Archive]:
> Am 15.08.2012 17:50, chilobo wrote:
> > Why can't Calc handle relative links correctly?
>
> Let's do a simple test with a relative URL:
> =HYPERLINK("./B/file.xyz")
> [Click]
> Security warning: "For security reasons, the hyperlink can not be
> executed."
This happened in version 3.5.x.y
I installed 3.6.0.4 today.
There Calc states:
... ist keine absolute URL, die zum Öffnen an eine externe Anwendung
übergeben werden kann.

> Whenever you use an ordinary static hyperlink anywhere in this office
> suite, it will be treated as a relative one even when it is displayed as
> an absolute URL:
> Insert>Hyperlink... point to ./B/file.xyz
> Now copy the document together with the B folder to some other place and
> open the new document. The hyperlink will point to the file in the new B
> folder.
I found that too, but that doesn't help me. I have a growing database, now
about 1000 datasets, in future about 4000. I will have about 5000 links to
pictures and PDF-documents of which about 4500 will be generated by
formulas, about 500 entered directly, but relative because I have to pass
the sheet to different users using Excel and Calc.




--
View this message in context: 
http://nabble.documentfoundation.org/relative-HYPERLINK-tp4001526p4001563.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