Ask Your Question

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

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:


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.

edit flag offensive delete link more

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


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

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

m.a.riosv gravatar image

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

edit flag offensive delete link more


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


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

Seen: 77 times

Last updated: Oct 13 '16