Ask Your Question
0

Calc: hyperlink is unreadable

asked 2016-10-12 03:31:07 +0200

MikeAgner gravatar image

When I create a hyperlink in Calc, it's surrounded in grey, which makes it very hard to read. How can I fix this?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
1

answered 2016-10-12 04:16:56 +0200

mark_t gravatar image

updated 2016-10-13 03:48:31 +0200

You can use the function HYPERLINK and create with a formula in a cell.

For example:

=HYPERLINK("www.google.com")

Maybe also change color to blue and underline to make it more obvious its a link

Edit: If you want to display different text in the link then the second argument needs to be a text string, or a reference to a text string.

=HYPERLINK("http://vidgo.com";"Vidgo")
edit flag offensive delete link more
0

answered 2016-10-13 02:50:12 +0200

MikeAgner gravatar image

updated 2016-10-13 03:13:08 +0200

I tried using the function wizard, and the syntax for this function is different from what is shown in the online help menu; the difference is that the help menu shows a semicolon between the URL and name, while the function wizard doesn't show it. Regardless of how I enter it, I get a #NAME? error. For example, I entered

=HYPERLINK("http://vidgo.com";Vidgo)

I tried this with and without the http and it still flags this as an error. I even used the select buttons to enter the text, and it still doesn't work.

I really wish this worked like Excel does - SO much easier...any hints?

edit flag offensive delete link more
0

answered 2016-10-13 09:06:51 +0200

m.a.riosv gravatar image

=HYPERLINK("http://vidgo.com";"Vidgo") works fine for me, you need to put the text with quotes.

edit flag offensive delete link more

Comments

Thank you very much. That seem to work just fine. Much appreciated. I will add a bug report for the function wizard to correctly show the syntax for that command - right now, it's not correct.

MikeAgner gravatar imageMikeAgner ( 2016-10-14 03:46:59 +0200 )edit

Maybe it can be more detailed, but all text to include as part of functions must be with quotes. If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2016-10-14 12:29:15 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-10-12 03:31:07 +0200

Seen: 77 times

Last updated: Oct 13 '16