Hi :) I tried modifying the styles for "internet" and "Internet Visited" but it didn't seem to affect the results. I couldn't see how to use styles in Calc so i had to open Writer to modify the styles. Regards from Tom :)
On 21 January 2014 14:44, Tom Williams <tomd...@comcast.net> wrote: > 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 > -- 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