[libreoffice-users] Problems with filtering by font color

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)

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy