From:</b>
Philip Jackson [mailto:[email protected]]
Sent:</b>
Tuesday, October 22, 2019, 11:43 UTC
To:LibreOffice
Subject:[libreoffice-users] Appearance of hyperlinks in Calc
spreadsheets
LO 6.0.7.3
in UbuntuStudio 18.04 LTSIn a Calc spreadsheet, I have a column
consisting only of
hyperlinks to websites. They are correctly formed and work fine
with Ctrl-click.My problem is the appearance of the column. Each link is
in black
text backed by a dark gray background colour (like indications of
'fields' in Writer).� That makes it difficult for me to read. My
preference would be black or even blue text on a plain white
background like the rest of the spreadsheet.The Help file provides the
same information for formatting
hyperlinks under Calc as it does for Writer. Essentially it
suggests changing the attributes via character stylesinternet links. I
can't find any access to character styles in
Calc let alone internet links styles. Nor is there anything
applicable to hyperlinks in cell formatting.(And in any case, the Help
text doesn't apply even to my version
of Writer either - but in Writer, I can at least change paragraph
styles to get the effect I would like).I think I have searched thoroughly
but I know it's easy to miss
some details so I'm appealing for any useful tips that you may be
able to provide to help me modify these attributes.Philip
What happens if you tap the F11 function key or select the menu
option View -Styles ? Either one should open the the StylesFormatting
panel, where you should see Hyperlink in the list
of cell styles. Right click on Hyperlink and select modify. In the
Cell Style: hyperlink dialog there are options to set font and
background colors.
Note your existing cells with hyperlinks in them will have the
default style and you will have to select those cells and apply
the Hyperlink style to them.
I don't have access to the Ubuntu edition of LibreOffice at the
moment, but the above procedure works perfectly for me using the
standard edition downloaded from TDF mirror servers.
Hope that helps.
Dave
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
