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

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+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