[Libreoffice-bugs] [Bug 144010] New: Filter by Background / Text Colour does not work for cells formatted by condition

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Aug 22 22:11:10 UTC 2021


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: libreoffice-bugs at lists.freedesktop.org
          Reporter: Bug2020 at JohnMurrell.org.uk

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210822/a931d34a/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list