Hi there! I have the latest versions of LibreOffice and Windows 11. I created a spreadsheet in Calc and inserted hyperlinks in a few cells. I then tried to change the appearance of the hyperlinks (font colour and no underline) by going to Styles > Cell Styles > Default > Text > Hyperlink. However, the hyperlinks’ appearance did not change. Have I done something wrong? Many thanks for your help.
You make nothing wrong. You can only set the font color by direct formatting. Set cursor into the cell, mark the entire hyperlink and set its color by the font color drop down. It is a direct formatting of the text, not a property of the cell. You cannot remove the underline by direct formatting. It would be reintroduces when reopening the file.
The current behavior in regard to underline was intentionally implemented, see tdf#153880. But not everyone is happy with this solution, see tdf#156849 or the closed bug tdf#168413. However, I think, using the HYPERLINK function as suggested by @EarnestAI is a good solution.
Click Tools > Options > LibreOffice > Appearance.
In the dialogue, under Customisations, change the colour for Unvisited links and for Visited links.
Note well: this will change the colour for all LibreOffice applications
A workaround without changing the colour for all LibreOffice applications is to use the HYPERLINK function, e.g. =HYPERLINK('www.libreoffice.org') and then apply the cell style
1 Like
@EarnestAI Thanks for your reply. What is the purpose of the styles I described in my initial post?
The HYPERLINK function has no colour indication to show it is a hyperlink, this can be helpful but at other times you want to show a colour to make it stand out, the Hyperlink style does that