[Libreoffice-bugs] [Bug 142580] New: FILEOPEN XLSX Conditional text format colors not considered by color filter

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142580

            Bug ID: 142580
           Summary: FILEOPEN XLSX Conditional text format colors not
                    considered by color filter
           Product: LibreOffice
           Version: 7.2.0.0 alpha1+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: implementationError
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: m.weghorn at posteo.de, nemeth at numbertext.org,
                    samuel.mehrbrodt at allotropia.de, varga.balazs3 at nisz.hu
            Blocks: 103512

Created attachment 172489
  --> https://bugs.documentfoundation.org/attachment.cgi?id=172489&action=edit
Example file from Excel with text color conditional formatting

Attached example file from Excel demonstrates a difference in behaviors: when
cells are formatted by text color and conditional format both, Excel offers the
conditional format text colors for filtering by color while Calc does not.

Steps to reproduce:
    1. Open attached file
    2. Dropdown the B1 autofilter, select Text color

Actual results:
Text color option offers orange color only.

Expected results:
Text color should also offer the blue and green text colors defined by
conditional format along the orange.
Also this should happen with new Calc files in the editor.

LibreOffice details:
Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: 187136265d26c014e842550c2f1fc5997736e4fa
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=103512
[Bug 103512] [META] AutoFilter-related bugs and enhancements
-- 
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/20210531/75c9be9c/attachment-0001.htm>