[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [libreoffice-users] Appearance of hyperlinks in Calc spreadsheets

Philip Jackson [mailto:philip-jackson@gmx.com]
Tuesday, October 22, 2019, 11:43 UTC
Subject:[libreoffice-users] Appearance of hyperlinks in Calc

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.


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

Re: [libreoffice-users] Appearance of hyperlinks in Calc spreadsheetsPhilip Jackson <philip-jackson@gmx.com>
[libreoffice-users] Appearance of hyperlinks in Calc spreadsheetsPhilip Jackson <philip-jackson@gmx.com>
Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.