Ask Your Question

LibreOffice Calc - Cell Background Color Menu

asked 2019-07-29 20:35:12 +0200

DrBen gravatar image

updated 2019-07-29 20:36:57 +0200


Is there a way to control the specific colors that appear in the Recent section of the Background Color menu that appears in Calc? Basically, I want to be able to select the specific colors that appear and to have them remain unchanged. See attached screen capture for details.

Somehow, it appears that the some of the colors that appear in the Recent section appear at random, and that the Recent section appears to be periodically emptied by the system. I would like to have more control over the Recent section, to add/delete specific colors, and to empty the Recent section based on my decision and not some system decision.

Is any of the above possible? Please advise. Thanks!

C:\fakepath\LibreOffice Calc - Background Color.jpg

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-07-29 20:56:14 +0200

ebot gravatar image

updated 2019-07-29 21:02:46 +0200

The "Recent Colors" selection always refers to the currently used document. To leave the colors in the "Recent colors" unchanged would contradict the actual purpose.

Up, above the colors is "Standard", there you can also select other color palettes.

There is also the possibility to create your own color palettes.

It is not a standard feature of LibreOffice and requires a bit of skill in dealing with an editor.

How to create your own color palette can be found here.

image description

If my answer has solved your problem, please click on the checkmark ✓ in the circle image description to the left of the answer and click on the arrow ^ for upvote. This will tell the community that the question has been answered correctly.

edit flag offensive delete link more


With me Windows 10 Home; Version 1903; 64-Bit | LibreOffice, Version: (x64).

ebot gravatar imageebot ( 2019-07-29 21:03:08 +0200 )edit

Thank you for the information! I was unaware that I could create a custom color palette, which will provide an even better solution for my needs.

I have followed the instructions on how to create a custom color palette, but I have a question for you.

Q: Does each color group need to consist of 12 unique colors? I have created two color groups, one consisting of 6 unique colors and another consisting of 7 unique colors. Unfortunately, when I attempt to access my custom color palette, these two groups do not appear separate but joined. Additionally, one of the specified unique colors does not even appear, even though its listing appears to be correct.

Any idea what I might be doing incorrectly?

DrBen gravatar imageDrBen ( 2019-07-30 20:49:05 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-29 20:35:12 +0200

Seen: 20 times

Last updated: Jul 29