Ask Your Question

How do I remove link formatting in Calc?

asked 2018-05-26 09:43:25 +0200

stew23 gravatar image

How do I remove the blue text (and white background) for text links in LibreOffice Calc? Instead I would like to have the text and background be whatever colour I choose. I still want the hyperlinks to be clickable, I just do not want the default colours to be used for the text links. Note that I am aware of the ability to change the default text colours for links via Tools > Options > Appearance, however this changes every link to the same colour, whereas I would like to have different colour text with different colour backgrounds throughout my spreadsheet. Thanks.

edit retag flag offensive close merge delete


Also asked at And related: But my answer suggests a different approach.

Jim K gravatar imageJim K ( 2018-05-26 21:49:06 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-05-26 21:47:39 +0200

Jim K gravatar image

updated 2018-05-26 21:59:37 +0200

Use the HYPERLINK function instead of a field.

formatted hyperlink

For easier maintenance of formatting, modify the Hyperlink cell style and apply it. In your case, you would need to create multiple styles. If none have the same formatting, then styles may not be worth it.

Sample file.ods

edit flag offensive delete link more


Excel has a 256 character limit on equations so this will break for long urls.

demented hedgehog gravatar imagedemented hedgehog ( 2018-11-19 05:56:49 +0200 )edit

@demented hedgehog: The question is about LO Calc, not MS Excel. Anyway, for such long URLs, you could put the address in a different cell and then use a cell reference in the HYPERLINK formula.

Jim K gravatar imageJim K ( 2019-02-25 18:57:50 +0200 )edit

@"Jim K" I am aware that the question is about LO Calc. It's just that there's a fairly high probability that @stew23 will be handing the thing to someone on windows at some point based on my experience. So interoperability is often important.

demented hedgehog gravatar imagedemented hedgehog ( 2019-02-25 23:22:18 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-26 09:43:25 +0200

Seen: 415 times

Last updated: May 26 '18