Ask Your Question
0

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

Comments

1

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
1

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
0

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
0

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

Comments

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

Stats

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

Seen: 9,380 times

Last updated: Apr 03 '14