Calc cell style background colour uses only the default palette

[crlMIDI]

Version: 5.3.5.2 (x64) W10, French

I updated the version just now, because of the very recent introduction of more subtle colour palettes.

However, in styles and formating, only the standard palette is presented for selecting the background colour of a named cell style, though the full choice of palettes is available for the border colour.

I’d like to know if this is the current state of development or if I should I report this as a bug.

[Regina]

That is work in progress. The bug https://bugs.documentfoundation.org/show_bug.cgi?id=105225 collects the places, which are currently missing.

For Calc you can use the workaround, that has worked since the beginning: Add a shape to the spreadsheet. Click on item “Area…” in its context menu. Change the palette there. Go back to the cell and open the cell formatting dialog. Now the new palette is available there too. When you do not need the shape any longer for changing color palettes, delete it.

[crlMIDI]

Thanks for your quick reply.

The workaround also works when creating and modifying named cell styles, which are needed for conditional formating.

Recently-used colours are not shown, which isn’t a problem if I have remembered to note down their parameters or make a shape for each!

[libreoffiguess]

For some reason the workaround isn’t working 100% for me. I had to add the colour in question as a custom palette (it had been part of the Document Palette originally), and even then, applying it to a document style made it slightly off-shade (from hex #ccffcc to #ccf4c6). Reapplying it doesn’t make any difference. Seems like the background colour selector might be restricting the palette to “websafe” hues?

[Alechan]

Another workaround is to Update the style with a color

Steps

1. Define a new Style with any color. In this case, we leave it at “No fill” because we will be changing it later

2. Set the new Style to a cell. In this case we set it to an entire row.

3. Change the color of the cell to the color you want for the Style. In this case we set it to 150, 150, 150 in RGB.

4. The color of only that cell will change

5. Finally, while positioned it that cell, click on “Update Style” to update the color of the style.

6. The color has been assigned to your Style and all the cells with said style have been updated. In this example, the whole row changed color.

[mikekaganski]

Nice and smart; but the workaround is not required since version 6.2.