On 01/21/2014 05:03 AM, Carl Paulsen wrote: > Hi Tom, > > You can try View->Value Highlighting for the email column. That works > on my Mac running LO 4.1.4. But it still leaves the gray cell > background fill. As for gridlines, I don't know if that can be done. > > Carl
Thanks for the reply! Peace... Tom > > > > On 1/20/14 9:29 PM, Tom Williams wrote: >> Hi! This is my first time posting to the mailing list. :) >> >> A client of mine is in need of editing some Excel spreadsheets on her >> shiny new Windows 8 system. I installed LibreOffice 4.1.3 and it mostly >> works but she's not able to do some of the things she used to do with MS >> Excel 2000. >> >> Primarily, she wants to be able to change the color of hyperlinks of >> email addresses. In MS Excel 2000, she could simply select the column >> of email addresses and change the color to black or any other color and >> the color of the links changes. >> >> In Calc, we select the column of email address and change the text color >> to black and the hyperlinks remain blue. I did some web searching and >> found I needed to edit the hyperlink style, but that appears to be only >> for cells that use the "HYPERLINK" formula (if that's what it's called) >> and not on cells that have email addresses listed that aren't using >> "HYPERLINK" syntax. I have a test Excel spreadsheet (generated with MS >> Excel 2000) I can send, if necessary. >> >> Any ideas on how I can get the color of the email address links to >> change color? She would like to preserve the links, in the spreadsheet, >> as she'll occasionally click them to send messages from Mozilla >> Thunderbird. >> >> Also, is it possible to adjust the thickness of grid lines shown in a >> spreadsheet, if we enable display of grid lines? >> >> Thanks in advance! >> >> Peace... >> >> Tom >> > -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
