Removing Highlights from Hyperlinks

Sucata · Newbie Joined: 07 May 2009 Posts: 2

Hi. Calc highlights hyperlinks. When creating a long list of hyperlinks (underlines removed), the highlighting creates a long unsightly swath down the page. Is there any way to remove the highlighting (and underlining) in Calc without destroying the hyperlink? This is not a problem in Excel. Thanks, Sucata.

JohnV · Posted: Thu May 07, 2009 11:54 am Post subject:

I think the best you can do is go to Tools > Options > OOo > Appearance and set Visited and Unvisited Links to white which will affect all applications.

Sucata · Newbie Joined: 07 May 2009 Posts: 2

Thanks, John. I tried that before posting this inquiry but it failed to remove the highlighting that Calc ADDED when I imported an Excel spreadsheet (which did NOT have the highlighting). Guess I'll just have to stick with Excel until the capability to control this feature is added to Calc. Regards, Sucata

Villeroy · Posted: Sat May 09, 2009 1:33 am Post subject:

pendle · General User Joined: 05 Jul 2009 Posts: 9

Sucata:
I had the same problem with the highlighted hyperlinks.
Experimenting with the options JohnV advised, I think he meant to say:
Tools>Options>Appearance>Set Field Shadings to White
This worked for me, for both new links and Excel imported ones.
I'd also like to see a color in the options called 'Transparent' because some of my links were in cells having a green or yellow background, so this still looks a bit messy.