Calc: Use self-defined colors in style / add them to palette

asked 2017-11-05 13:45:53 +0200

sweber
3 ●1 ●1 ●3

updated 2017-11-05 21:51:13 +0200

I'm using LibreOffice 5.3.5.2 as provided by the reporitories of my OpenSuse 42.3 installation.

If I want to change the background color of a cell in CALC by hand, there is an option to choose any possible color below the predefined palette.

Now, I would like to define a style, but there, only the predefined palette is available. My first thought was that this is just inconvenient, since one can add colors to the palette somewhere in _tools > options_.
__But I'm, quite surprised that there is no entry to alter the color palette__

__Furthermore, this only applies to background color, text and border color can be defined freely!__

So, how do I use self-defined colors in CALC styles? Since I'd like to set up my own color scheme, how do I add colors to the palette?

edit retag flag offensive close merge delete

add a comment

0

answered 2017-11-05 15:43:09 +0200

KH

351 ●1 ●3 ●12

updated 2017-11-06 01:42:43 +0200

In recent versions of LO (including 5.4) the full color selection controls are not available in some dialogs.

Not exactly what you mean when you talk about "defining a template". Style maybe?

In any case, there are several bugs reported. See bug #10352 for background color in Calc.

A workaround in the linked bug report for accessing the full color menu in Calc is to insert any shape, right click, and open the area dialog. You can add a color to the "Custom" palette there.

Then you can apply your new color using the background color button on the toolbar or sidebar. Actually, this is all you need to do if you find an acceptable color in one of the other bundled palettes.

Assuming you want to get the color into a style, you should be able to do it using the "update style" button.

You may also want to download or create a .soc palette file and save it in your user directory. The new "standard" palette for 5.4 is quite nice. Google will give plenty of hits.

Edit (spurred by Regina's answer): You can also use the button on the sidebar, not just the toolbar. Corrections for clarity.

edit flag offensive delete link

Comments

You are right, I mean styles. And the workaround works fine - but I hope this will be fixed in a future release. Thanks!

sweber ( 2017-11-05 21:58:26 +0200 )edit

add a comment

0

answered 2017-11-05 15:53:26 +0200

Regina

9165 ●8 ●54 ●92

Do not use Format > Cell > Background, but use the section Cell Appearence in the sidebar. It has a drop-down to choose the color. There you can select one of the predefined palettes or define an own color.

You cannot add own colors to a palette from within LibreOffice, but use an editor to add the color to the .soc file. Own colors, which you define inside LibreOffice, are not stored in a palette but in the file registrymodifications.xcu.

edit flag offensive delete link

Comments

Own colors, which you define inside LibreOffice, are not stored in a palette but in the file registrymodifications.xcu.

You're referring to the "custom" option in the palette selection dropdown, right? Is there a principled reason why these colors are stored differently?

KH ( 2017-11-06 01:50:04 +0200 )edit

Yes, about the "custom" option. The entire palette management was removed to simplify the dialogs for normal users. I personally do not like the decision, to put just another information into the already huge registrymodificatons.xcu, and I do not know why the decision was done. Nevertheless, the palette management is no problem for advanced users, because generating or changing a palette manually is easy.

Regina ( 2017-11-06 11:33:16 +0200 )edit

add a comment

Calc: Use self-defined colors in style / add them to palette

2 Answers

Comments

Comments

Question Tools

Stats

Related questions

Calc: Use self-defined colors in style / add them to palette edit

2 Answers

Comments

Comments

Question Tools

Stats

Related questions

Calc: Use self-defined colors in style / add them to palette