Calc - Header & Footer - Background Color: No Custom Colors Selection UI

[PeterLairo1]

I want to select custom colors for my header and footer background in LibreOffice Calc (ver. 5.x) but it is not possible.

Under Page Settings / Header / Additional (German: “Zusätze”) / Background, the UI does not provide a way to select the Custom (or User, German: “Benutzerdefiniert”) color palette. In Writer, the UI is different, and it is possible to select other color palettes there.

Is there a workaround? Is this a known Issue/bug? Could you please tell me the URL to the bug - I couldn’t find it.

Thank you.

[mikekaganski]

https://bugs.documentfoundation.org/show_bug.cgi?id=105225 - all “Enable custom color …” bugs get duplicated to it.

See also Under Options, there is no "Colors" tab. How do I add a custom color?

[librebel]

Hello @PeterLairo1,

a Custom background color for Page Headers and Footers can be set using a macro:

Sub Set_Custom_Page_Header_And_Footer_BackgroundColor( Optional strPageStyleName As String )
	If IsMissing( strPageStyleName ) Or strPageStyleName = "" Then strPageStyleName = "Default"
	Dim oDoc as Object			: oDoc = ThisComponent
	Dim oPageStyles as Object	: oPageStyles = oDoc.getStyleFamilies().getByName( "PageStyles" )
	Dim oPageStyle As Object	: oPageStyle = oPageStyles.getByName( strPageStyleName )
	
	oPageStyle.HeaderBackColor = RGB( 2, 220, 255 )		REM <---- Set here your desired colors.
	oPageStyle.FooterBackColor = RGB( 2, 255, 220 )
End Sub