Bug 144549 - Filter by Color does not work for colors, which are set by number format
Summary: Filter by Color does not work for colors, which are set by number format
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) alpha0+
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL: https://issues.oasis-open.org/browse/...
Whiteboard: odf
Depends on:
Blocks: AutoFilter-Color
  Show dependency treegraph
Reported: 2021-09-16 14:29 UTC by Regina Henschel
Modified: 2021-09-16 14:35 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:

Example of Color in number format (17.05 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-09-16 14:29 UTC, Regina Henschel

Note You need to log in before you can comment on or make changes to this bug.
Description Regina Henschel 2021-09-16 14:29:14 UTC
Created attachment 175075 [details]
Example of Color in number format

It is possible now to filter on colors. However, that covers only text color and background color. But it is possible to set colors in number-format. That is in the predefined number formats done for negative numbers. But you can define number-formats with other colors and other ranges too. Such example is attached.

Number-formats with colors can be used for the y-axis in charts too.

To include colors from number-format in a filter is important for exchange with Google Tables. That application considers colors set by number-format the same as colors set by text format.