Ask Your Question

shading http link

asked 2017-07-12 22:54:23 +0200

EduardoJuan gravatar image

updated 2017-07-12 23:20:23 +0200

How do I get rid of the annoying shading for hyperlinks?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-07-12 23:01:16 +0200

RGB-es gravatar image

updated 2017-07-12 23:35:17 +0200

By default Writer applies the character style "Internet Link". You just need to edit that style in order to change the appearance of any internet link on the document.


To modify the character style open the style editor with F11, click the second icon on top of it (Character styles) and scroll the list of styles until you find "Internet Link". Right click on the style → Modify. Look on the "Font Effects" tab. By default this style is set with a blue colour and underlined.

edit flag offensive delete link more


right. But i couldn't find a way to do it.

EduardoJuan gravatar imageEduardoJuan ( 2017-07-12 23:21:34 +0200 )edit

I edited my answer to indicate how to edit the style.

RGB-es gravatar imageRGB-es ( 2017-07-12 23:35:48 +0200 )edit

Could you tell me where to find "character style"? I can't find it anywhere under "Options"

EduardoJuan gravatar imageEduardoJuan ( 2017-07-12 23:49:29 +0200 )edit

I can follow your instruction to the point I find "Excel Built-in Hyperlink". None of what you indicate is available after that (Right click on the style → Modify. Look on the "Font Effects" tab). Right clicking on the style does not produce the choices you mention. Stuck again!

EduardoJuan gravatar imageEduardoJuan ( 2017-07-13 00:06:16 +0200 )edit

answered 2017-07-13 01:45:33 +0200

librebel gravatar image

updated 2017-07-15 09:19:29 +0200

Hello @EduardoJuan,

If your shading is a “Field Shading”, you could:

1. select the menu “Tools  :  Options...  :  LibreOffice  :  Application Colors”,
2. in the listbox “Custom Colors”, uncheck the checkbox called “Field shadings”.
( NB. This removes the shading for all automated Textfields ).

Or if your shading is really a “normal” background color, then you could:

1. Right-click on your Hyperlink and select the option “Edit Style...”,
2. in the dialog that pops up, select the tab called “Area”,
3. in the dropdown listbox called “Fill”, select the item “None”.

EDIT 2017-07-15

Took me a while to realise that your Hyperlinks are from Calc instead of Writer. In that case you could use the following macro to get rid of the background color: ( Just specify the same background color as the cell's background color, e.g. White ):

Calc_Format_HyperLinks( "A30", "Ubuntu", 12, 150, RGB(0,0,255), RGB(255,255,255), 1, 0, 0 )

Sub Calc_Format_HyperLinks( strCellAddress$, strFontName$, dFontSize#, dFontWeight#, lTextColor&, lBackgroundColor&, iUnderline%, iOverline%, iContour% )
REM Changes the text style of all Hyperlinks inside the specified cell.
REM <strCellAddress>    : Must be the address of a single cell, e.g. "A1".
REM <strFontName>   : Name of the Font for the Hyperlink, e.g. "Ubuntu".
REM <dFontSize>     : Height of the Font in points, e.g. 12.0.
REM <dFontWeight>   : Weight of the Font, e.g. 100=Normal; 150=Bold.
REM <lTextColor>        : Color for the Hyperlink Text, e.g. RGB( 0, 0, 255 ).
REM <lBackgroundColor>  : Color for the Hyperlink Background, e.g. RGB( 255, 255, 255 ).
REM <iUnderline>        : 0=No Underline; 1=Underline.
REM <iOverline>     : 0=No Overline; 1=Overline.
REM <iContour>      : 0=No Contour; 1=Contour.
    Dim i As Integer
    Dim oSheet As Object, oCell As Object
    Dim oTextFields as Object, oTextCursor As Object
    oSheet = ThisComponent.CurrentController.ActiveSheet
    oCell = oSheet.getCellRangeByName( strCellAddress )
    oTextFields = oCell.getTextFields()
    For i = 0 To oTextFields.getCount() - 1
        oTextCursor = oTextFields.getByIndex( i ).getAnchor().createTextCursor()
        oTextCursor.CharFontName = strFontName
        oTextCursor.CharHeight = dFontSize
        oTextCursor.CharWeight = dFontWeight
        oTextCursor.CharColor = lTextColor
        oTextCursor.CharBackColor = lBackgroundColor
        oTextCursor.CharUnderline = iUnderline
        oTextCursor.CharOverline = iOverline
        oTextCursor.CharContoured = iContour
End Sub
edit flag offensive delete link more


Thanks for the reply. However, your instructions do not match the choices offered me. In following the first set of instructions, I did uncheck "field shadings" but the choice under appears available for TEXT DOCUMENTS, & not for SPREADSHEETS.

Trying the second set of instructions, right-clicking on one of the hyperlinks does not offer the choice of "Edit Style". Besides, I want to set up the default for all spreadsheets and not modify each cell one by one. Any other suggestions?

EduardoJuan gravatar imageEduardoJuan ( 2017-07-15 05:28:57 +0200 )edit

Updated my earlier answer based on your new information, but no default :(

librebel gravatar imagelibrebel ( 2017-07-15 09:17:39 +0200 )edit

Librebel: Thanks for the macro. But I can't believe that there's no other mechanism to set up "no shading for hyperlinks" as a choice for all of my spreadsheets. If so, this is a major weakness of the Libre software.

EduardoJuan gravatar imageEduardoJuan ( 2017-07-17 06:41:05 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-07-12 22:54:23 +0200

Seen: 258 times

Last updated: Jul 15 '17