Problems with filtering by font color

users
#1

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 values.

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 standard?

With kind regards
Regina Henschel
(Member of the ODF Technical Committee)