Hyperlinks in OpenOffice Calc are displayed with a solid background which covers the background color of the cell. I don't want a solid background; I want the background color of the cell to show through. Is there any way to do this?
A web search reveals any number of forum results suggesting the setting
Tools > Options > OpenOffice > Appearance > Text Document > Field shadings
I can change the color of the background using the dropdown box at the right, but there is no transparency support. You'd think unchecking the box in front of this setting would make the background go away, but it doesn't.
I've checked the settings
Tools > Options > OpenOffice > Appearance > General > Unvisited links
Tools > Options > OpenOffice > Appearance > General > Visited links
but those control the text color, not the background.
Other web search results suggest the
HYPERLINK function, but that only allows one link per cell, and I need more than one link in some of these cells.
In asking this question I'm hoping to create a definitive reference for this: is there anything I can do, short of modifying the OO Calc source code and recompiling it, to make the hyperlink background go away?