https://bugs.documentfoundation.org/show_bug.cgi?id=144010
Bug ID: 144010
Summary: Filter by Background / Text Colour does not work for
cells formatted by condition
Product: LibreOffice
Version: 7.2.0.4 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The latest update of LibreOffice calc introduced the ability to filter by
Background or text colour which works if you manually change the cell colours.
If the Background or text colour are changed by conditional formatting this
does not show in the filter selection so you cannot filter by it.
Steps to Reproduce:
1.Create a list of numbers with some duplicates
2.used the conditional format - condition to format the duplicate values as
'errors' which have white text on a red background.
3.Apply an auto filter to the list.
4:Neither the red background or white text appear in the Text Colour or
Background colour in the filter selection.
Actual Results:
Background & text colour not shown in filter selection
Expected Results:
Background & Text colour should appear in filter selector allowing cells
formatted by conditional formatting to be filtered.
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
https://gerrit.libreoffice.org/gitweb?p=core.git;a=log;h=9a9c6381e3f7a62afc1329bd359cc48accb6435b
(the rest will not copy)
--
You are receiving this mail because:
You are the assignee for the bug.
