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

From:</b>
          Philip Jackson [mailto:philip-jackson@gmx.com]
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: 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