Problems with filtering by font color

Regina Henschel rb.henschel at
Mon Aug 16 19:32:41 UTC 2021

Hi all,

LibreOffice has got the new feature in 7.3 to filter by font color 
(strings and numbers) in Calc.
Such color can be determined by
a) direct style assignment, including direct formatting
b) by number-format, e.g. red for negative numbers
c) by conditional formatting

Filtering is not just a layout operation, but effects the values in the 
spreadsheet via the function SUBTOTAL. Therefore, it is important to 
define the filtering precisely so that all applications produce the same 

Unfortunately currently the behavior is:
LibreOffice: supports a)
Excel: supports a) and c)
Google spreadsheet: supports a), b) and c)
Gnumeric: not yet implemented, but wants to support a), b) and c).

How do you think filtering by font color should be specified in the ODF 

Kind regards

More information about the LibreOffice mailing list