Please re-read my answer, your path it is not well formed, you need to write the path well, for this I explained how to create an hyperlink from Menu/Insert…, then you can see what how the path must be written.
Thank you for the reply. I did as suggested including creating the link from the insert menu with the same failure. Sorry that I did not specify in previous comment. For some reason in both examples it removed one of the backslashes in these comments, it should show 2 slashes after file:
@mariosv I appreciate your help. I need to point out that in both of your examples are for a file that is on YOUR machine (f drive). I am trying to access a file on the local area network on another machine. As you have suggested, with the file on my machine DOES work, the problem is the network
F: is not always in my machine, depend where I am. If you have not a assigned a driver letter, try with the computer name: file://servername/directory/File.ods#Sheet1.C30
Thank you mariosv. We just changed offices, sorry for the delayed response. That is actually exactly what I have tried. The info in edit2 leads me to beleive that it is a bug within LO that won´t open two active windows at the same time via a hyperlink. Any further suggestions are very welcome.
You can navigate to select the file, and after select a sheet, named range or a database range.
Then you can see the proper URL, it is the same to use in the function, you can add a cell address.
An hyperlink like next works for me:
=HYPERLINK(“file:///F:/2011/File.ods#Sheet1.C30”;“Link”)
You can do an hyperlink in Menu/Insert/Hyperlink, select document and complete the form, with path and target is enough, so you can see the right data for the HYPERLINK function.
Now it is getting interesting. @Fayaz answer made me testing a bit more:
I am running XP Prof / SP3 and followed the procedure given by @mariosv. LibO as already indicated 3.6.5.2
Files are saved in ods-format. xls or other are not tested.
Links tested: as in my previous answer
another workbook
a specific sheet in another workbook
a specific range in a specific sheet in another workbook
I not only closed but restarted my PC and the links are still there and are working.
Noｗ it is important - IMHO - what are the
- LibO versions
- OS versions
- steps made to create hyperlinks and safe and close files
Good to know that it is working for you… Well for me sadly i’m continuously having the issue when using hyperlink within the same sheet. I even tried with the latest version of Libre Office (v 4.0.1) - btw i’m running Win 7 Prof 32bit and Libre Office v 4.0.1 …Can anyone help me out
@Fayaz - Now we need someone with the same configuration as you have. If a test reveals a loss of the hyperlinks, there is a bug and it should be reported. However, you can also go ahead and file a bug report.
@kunzi wrote:
Thank you mariosv. We just changed offices, sorry for the delayed response. That is actually exactly what I have tried. The info in edit2 leads me to beleive that it is a bug within LO that won´t open two active windows at the same time via a hyperlink. Any further suggestions are very welcome.
If you think that there’s a bug in LibreOffice, please file a bug and provide a list of steps that can reproduce your problem. The QA team will be happy to help you track down this issue!
Please post a link to any bugs you file in a comment below using the format “fdo#123456”.
Thanks!
I just made a test in LibO 3.6.5.2 and links are working fine from 1 sheet to
- another workbook
- a specific sheet in another workbook
- a specific range in a specific sheet in another workbook
I tried hyperlink in calc. For me it is working perfectly be it within the workbook and between workbooks. But the only problem that I’m having is that the hyperlink works only for the first time. Once I save, close and reopen the workbook HYPERLINK DOES NOT WORK
I am trying to use hyperlink to access the web at http://itouchmap.com/latlong.html
This has worked for a long time with no problem, until 4.0. Now it ignores the click in the window.
When I rewrite the cell using =HYPERLINK(http://itouchmap.com/latlong.html," 2) Find City Lat & Long"), it says the URL is wrong and deletes one of the “/”, which means it can’t work.
I have a Mac OS 10.8.3
Addendum: It works fine in 3.6.6
Does this answer help? EDIT: Under Mac you need to use CMD+click. You also need quote marks around the URL.
OK, here’s what I have found:
OK, now things are getting weird. In 3.6, everything worked. In 4.0 on the same file, click in window didn’t work. I took your advice oweng and CMD-clicked on the hyperlink. It worked! No quotes around the URL. Then I clicked to URL again (no CMD) and it worked again (two different URLs).