Ask Your Question

how to change the format of the hyperlink in Calc ? [closed]

asked 2012-12-10 13:28:07 +0100

Dodo gravatar image

how to change the format of the hyperlink in Calc ?

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 2016-02-20 18:37:18.027975



Format? Text to button? F2, Home, Insert-Hyperlink: Form -> Button. Or you ask about color? Tools/Options/LibreOffice:Appearance:Field shadings

JohnSUN gravatar imageJohnSUN ( 2012-12-10 14:43:25 +0100 )edit

Or use the hyperlink function (=HYPERLINK("http://www.your-url"), then create a hyperlink cell format style and apply it.

w_whalley gravatar imagew_whalley ( 2012-12-10 15:20:25 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2012-12-10 15:39:50 +0100

Remember that the grey box around the "link" text is only to show you the text is a link. If you print it, only a blue text appears. Follow the others tips to create a style format to apply to your text.

edit flag offensive delete link more

answered 2014-04-03 11:14:31 +0100

icc97 gravatar image

I found that the Field Shadings route was the correct route (Tools > Options > Libre Office > Appearance > Field Shadings). But I found a problem when turning off the field shadings that meant the whole cell would be treated as a URL.

So I recommend just setting the Field Shadings to white.

edit flag offensive delete link more


Thanks for this! (sadly I'm not allowed to vote...) Somehow in my LO Calc (5.4.x), links are rendered light orange on dark grey which is very close to unreadable. Note the path has changed to *Tools > Options > LibreOffice > Application Colors > (Text Documents) > Field Shadings. I've set mine to "Light Gray 5" and that works.
I think the handling of the entire cell as a URL isn't related to this; it's a general LO usability issue...

sxc731 gravatar imagesxc731 ( 2018-03-04 15:36:42 +0100 )edit

Hello, Can somebody ,please, update the intsruction above after the option Appearance was removed from LO Options? I cannot read hyperlinks now they are light green and background is light grey so there is minimal contrast.

vlbl64 gravatar imagevlbl64 ( 2018-10-09 19:13:19 +0100 )edit

The field shadings value seems to be shared across spreadsheets?

demented hedgehog gravatar imagedemented hedgehog ( 2018-11-19 05:55:31 +0100 )edit

Question Tools


Asked: 2012-12-10 13:28:07 +0100

Seen: 9,021 times

Last updated: Apr 03 '14