Ask Your Question
0

hyperlink in scalc not working [closed]

asked 2013-03-24 12:10:20 +0200

Fayaz gravatar image

updated 2015-10-23 14:07:28 +0200

Alex Kemp gravatar image

Hi all,

Hyperlinks I create work only for the first time. As I create the hyperlink it works fine, but once I save the document close and reopen it, hyperlink doesn't work. I cannot even edit the hyperlink button that I created. I'm facing this problem when creating hyperlinks; 1.Within the same workbook 2.Between two workbooks 3.Linking to a website 4.Linking to another document

I was initially using LibreOffice v3.6.3 but then upgraded to LibreOffice v4.0.1 thinking issue might have been solved. But sadly still facing the same problem

My PC config:- Dell Optiplex 380 Windows 7 Enterprise 32bit LibreOffice v4.0.1

Any help is much appreciated

PS- I'm saving scalc files in ".xls" format

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-23 14:08:53.252786

Comments

Can a moderator (if @Fayaz is unable) please edit the question to make it clear this is a Form of "Button" + XLS specific issue, rather than a generic hyperlink issue? Thanks.

oweng gravatar imageoweng ( 2013-05-20 08:29:33 +0200 )edit

3 Answers

Sort by » oldest newest most voted
1

answered 2013-05-20 08:26:01 +0200

oweng gravatar image

updated 2013-05-20 09:47:39 +0200

This appears to be bug fdo#35392. From the description "I cannot even edit the hyperlink button that I created" it is an issue that relates specifically to using the Insert > Hyperlink > Internet/Document > Further Settings > Form of "Button" method and only for the XLS file format. As indicated in the attachment to the bug Description, one workaround is to use plain text link (Form of "Text") instead. Another workaround is to use the HYPERLINK function.

Also note that since v4.0.3 to open a hyperlink either CTRL+click (Linux/Win) or CMD+click (MacOS) is required to avoid automatically launching the browser when clicking on a cell, as described in this thread.

edit flag offensive delete link more

Comments

Thx oweng :) Confirming CTRL+click on the link (Linux/Win) works

Francewhoa gravatar imageFrancewhoa ( 2014-05-20 17:52:09 +0200 )edit
0

answered 2013-03-24 12:50:37 +0200

ROSt52 gravatar image

@Fayaz - I think it was a good idea to move your qeustion out of the previous question originally created by @kunzi.

However let me add here two links that others can read what has been exchanged on the this topic:

http://ask.libreoffice.org/en/question/12130/hyperlinks-in-calc-to-another-calc-doc-not-working/
http://ask.libreoffice.org/en/question/8485/solved-hyperlink-vs-insert-hyperlink/

I keep fingers crossed that someone with the some OS and LIbO configuration makes some tests.

edit flag offensive delete link more

Comments

@ROSt52 - Thanx alot

Fayaz gravatar imageFayaz ( 2013-03-25 06:22:54 +0200 )edit
0

answered 2013-05-19 20:51:27 +0200

BenG gravatar image

I have exactly the same problem on my Mac with version 4.0.

edit flag offensive delete link more

Comments

When you say "exactly the same problem" I presume you are not referring to your post here, because that is a different issue.

oweng gravatar imageoweng ( 2013-05-20 03:47:24 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2013-03-24 12:10:20 +0200

Seen: 3,924 times

Last updated: May 20 '13