Re: [libreoffice-users] Help needed with LibreOffice Calc 4.1.3.2

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


As for the gridlines,

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

--

Carl Paulsen

Dover, NH 03820


--
To unsubscribe e-mail to: users+unsubscribe@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