Bug 127227

Summary:	Calc formula should use a color palette as highlight color
Product:	LibreOffice	Reporter:	Thomas Lendo <thomas.lendo>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	22shubh22, erack, heiko.tietze, kainz.a
Priority:	medium
Version:	6.3.0.4 release
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=105622 https://bugs.documentfoundation.org/show_bug.cgi?id=112541
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	104118, 108253

Description Thomas Lendo 2019-08-29 21:24:39 UTC

The highlighting of a Calc formula should use the colors of a default color palette and no hardcoded colors(?) and should use more different colors than now.


Andreas Kainz already mentioned this in another bug.
Copied from https://bugs.documentfoundation.org/show_bug.cgi?id=105622#c14 :

Created attachment 152862 [details] (highlight cells with chart color palette)

I would recommend to use the chart color palette cause this is defined for the same issue. Separate elements from each other.

In the image you see:
left: master build 
center: standard color palette (problem colors are next to each other similar) 
right: chart color palett (background saturation: 10% and brightness: 100 %)

I know the chart color palette didn't has 16, 32, 64, 128, ... different colors. For now there are only 12 colors defined, but that doesn't mean that we can't add there more colors.

When we use an color palette the colors are not hardcoded somewhere, so I think it's an good plan.

Comment 1 Heiko Tietze 2019-09-17 07:18:29 UTC

Not sure that colors are really hard-coded but even more concerned what would happen when the user/designers change the chart (or other) palette making it hard to read? If we go this way I recommend a UI test that blocks unintentional modifications later.