Created attachment 172489 [details] 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
Created attachment 172490 [details] Screenshot of the original document in Excel
Created attachment 172491 [details] Screenshot of the original document in Calc
Reproduced in Version: 7.2.0.0.alpha1+ / LibreOffice Community Build ID: f49e5902a3737c02fabf5bec23243ccb126426c4 CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
looks mostly the same as bug 142579, except that one is about text, the other about background color
Samuel Mehrbrodt committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0f5edf0899962bc696cd1c40646c8d4b5add2208 tdf#142580 Consider cond. format text colors in color filter It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e2e1da3cc89942443832ea018ced68eb41e3d75a tdf#142580, tdf#143103: sc: Add UItest It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Samuel Mehrbrodt committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/52596dedfe629a008e198d023ffcae45a8a791ee tdf#142580 Consider cond. format text colors in color filter It will be available in 7.2.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in Version: 7.2.3.0.0+ / LibreOffice Community Build ID: 2391d8073624004e0cd657ab07ff947f6a9ef0c7 CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded @Samuel, thanks for fixing this issue!!