[libreoffice-users] Re: relative HYPERLINK

2012-08-15 Thread chilobo
Jay Lozier wrote > > I am puzzled by the sharing of the spreadsheet. Are the files stored on > a server with a fixed location or they passed out to users to install > locally? > > Also, I would try setting up the linked files in a sub-folder of the > spreadsheet folder. If the the spreadsheet

[libreoffice-users] Re: relative HYPERLINK

2012-08-15 Thread chilobo
Andreas Säger wrote > > > You can not misuse a spreadsheet like this and expect that it works in 2 > applications. Things may change if Excel 13 really provides full ODF > support but nobody believes that MS will go that far. > Needless to say that no spreadsheet application will ever work lik

[libreoffice-users] Re: relative HYPERLINK

2012-08-15 Thread chilobo
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")

[libreoffice-users] Re: relative HYPERLINK

2012-08-15 Thread chilobo
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.wi

[libreoffice-users] relative HYPERLINK

2012-08-15 Thread chilobo
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 destina