| Summary: | FILEOPEN XLSX Conditional format background colors not considered by color filter | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | NISZ LibreOffice Team <libreoffice> |
| Component: | Calc | Assignee: | Samuel Mehrbrodt (allotropia) <samuel.mehrbrodt> |
| Status: | VERIFIED FIXED | ||
| Severity: | normal | CC: | Bug2020, joselp, maxime, m.weghorn, nemeth, prempa, rb.henschel, samuel.mehrbrodt, varga.balazs3, xiscofauli |
| Priority: | medium | Keywords: | implementationError |
| Version: | 7.2.0.0 alpha1+ | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=76258 https://bugs.documentfoundation.org/show_bug.cgi?id=142580 https://bugs.documentfoundation.org/show_bug.cgi?id=144010 |
||
| Whiteboard: | target:7.3.0 target:7.2.3 | ||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 103512, 142076 | ||
| Attachments: |
Example file from Excel
Screenshot of the original document in Excel Screenshot of the original document Calc |
||
Created attachment 172486 [details]
Example file from Excel
Created attachment 172487 [details]
Screenshot of the original document in Excel
Created attachment 172488 [details]
Screenshot of the original document 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: x11 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Samuel Mehrbrodt committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/817ef891cf2bef8fdc82852f73acb422afb89bd2 tdf#142579 Consider color scale background 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. *** Bug 144010 has been marked as a duplicate of this bug. *** Samuel Mehrbrodt committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/88e81b3c5f7167d7dfc93617c3f9d9d6633ba0ad tdf#142579 Consider cond. format background 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/4ba0460e3cf3ce33794090968fd4c906422bbd25 tdf#142579, 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. *** Bug 144662 has been marked as a duplicate of this bug. *** Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/2dd6c7e5d59126e28bf478439c25f9f4cbc3422c tdf#142579: sc: Add UItest for cond. format background colors 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/63b004d4cab295c708686989869c9033ec91e449 tdf#142579 Consider color scale background 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. Samuel Mehrbrodt committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/2391d8073624004e0cd657ab07ff947f6a9ef0c7 tdf#142579 Consider cond. format background 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!! *** Bug 145105 has been marked as a duplicate of this bug. *** |
Attached example file from Excel demonstrates a difference in behaviors: when cells are formatted by background color and conditional format both, Excel offers the conditional format colors for filtering by color while Calc does not. Steps to reproduce: 1. Open attached file 2. Dropdown the B1 autofilter, select Background Color Actual results: Background color option offers green and yellow colors. Expected results: Background color should offer only the blue-white-pink colors defined by the conditional formatting and hide the actual cell background colors. 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