Ask Your Question
0

Hyperlink Background Color in Spreadsheets [closed]

asked 2013-01-01 21:29:18 +0200

Nerves gravatar image

When I add a hyperlink to text in a spreadsheet it adds a grey background color around the text. Is there a way to eliminate or customize this?

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 2015-10-19 19:08:59.853627

1 Answer

Sort by » oldest newest most voted
0

answered 2013-01-01 22:10:22 +0200

w_whalley gravatar image

Two ways I know of:

Enter your hyperlink as a function, e.g. `=HYPERLINK("http://www.google.com")

Set the field shading to your background color using Tools/Options/Libreoffice/Appearance Then in the Custom Colors Text Document section set the field shadings color setting to your cell background color.

You can save this as a custom color scheme for easy switching back and forth. You can change the unvisited links color for the hyperlink too. However I could not get the visited links color to change.

edit flag offensive delete link more

Comments

That is still entering a color. I color code cell backgrounds. Entering the sheet background color only changes the highlight color of the hyperlink. Now instead of gray it will be white. That is no solution. I want no color like in excel. I want to try libreoffice, but this appears to indicate a serious lack of thought by the designers.

wilceee gravatar imagewilceee ( 2013-12-25 18:47:49 +0200 )edit

Question Tools

Stats

Asked: 2013-01-01 21:29:18 +0200

Seen: 23,230 times

Last updated: Jan 01 '13