At 12:16 08/05/2007 -0400, Scott Featherstone wrote:
I imported an Excel spreadsheet and everything works great but I do have a question. In all the cells that have HyperLinks, url's & email address', there is a blue background around the link and I can't get rid of it. I have attempted to change the font color and the background fill color to no avail. Am I stuck with this background color or can I eliminate it altogether. Since both the background & the font is colored blue I'd like at the very least be able to change one of the colors so the links are easier to read, but I have been unable to. Can you provide some assistance?? Thanks and have a great day!!
In my version of Calc (I'm still on 2.0), hyperlinks appear by default in blue on a grey background. Is that what you mean, or something different? The grey background is just an indication that the contents of the cell are a hyperlink, and is not the genuine background colour. You can see that this is so either by expanding the cell so that it is bigger than necessary to contain the hyperlink, when you can see the true background colour around it in the cell, or else by using Page Preview, which will also show the true colours.
Do you want these to remain as hyperlinks? If not, just use right-click and then select Default in the context menu to remove the hyperlink. Then you can format the cell in the normal ways.
But anyway, I think I have found the answer to your question. In the case of normal (non-hyperlink) text, you can change the font colour or background colour simply by selecting the relevant cell. But, as you have discovered, this does not appear to work for hyperlinks. It does work for the background colour, in fact, but you may not be able to see the effect as it is hidden by the hyperlink's automatic grey shading, as mentioned above. To change the font colour, select the cell but then *also select the relevant text in the copy that appears in the input line at the top of the sheet*. Now you can change the font colour effectively.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
