Re: Problems with filtering by font color

2021-08-16 Thread Heiko Tietze
On 16.08.21 21:32, Regina Henschel wrote: a) direct style assignment, including direct formatting b) by number-format, e.g. red for negative numbers c) by conditional formatting The META ticket is https://bugs.documentfoundation.org/show_bug.cgi?id=142076 with a few more requests. Bug 142579

Re: Problems with filtering by font color

2021-08-16 Thread Thorsten Behrens
Hi Regina, Regina Henschel wrote: > Unfortunately currently the behavior is: > LibreOffice: supports a) > We might get support for c) added soonish - > Excel: supports a) and c) > Google spreadsheet: supports a), b) and c) > Gnumeric: not yet implemented, but wants to support a), b) and c). >

Re: Problems with filtering by font color

2021-08-16 Thread Regina Henschel
Hi Caolán, Caolán McNamara schrieb am 16.08.2021 um 23:00: On Mon, 2021-08-16 at 21:32 +0200, Regina Henschel wrote: How do you think filtering by font color should be specified in the ODF standard? FWIW we have extras/source/palettes/html.soc which lists the color- names of

Re: Problems with filtering by font color

2021-08-16 Thread Caolán McNamara
On Mon, 2021-08-16 at 21:32 +0200, Regina Henschel wrote: > How do you think filtering by font color should be specified in the ODF > standard? FWIW we have extras/source/palettes/html.soc which lists the color- names of https://www.w3.org/TR/css-color-3 so maybe some subset of the non-deprecated

Problems with filtering by font color

2021-08-16 Thread Regina Henschel
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