Description: When a conditional formatting is applied on cells Ex : "bad" style on double values which set a pink background, you can not filter on pink values This is similar to : Bug 142076, is related to : Bug 76258 and its parents Bug 142076 Actual Results: rows are not filtered on visible color on screen Expected Results: Rows are filtered on visible color on screen Reproducible: Always User Profile Reset: No Additional Info: This is the behaviour of Excel
Hello Md, Would it be possible to have a sample document for this issue ?
Created attachment 175193 [details] A demo to make evident that CF conditions only are evaluated for the viewed range I attach a (slightly reworked) example I made in 2021-May for somebody else to back my claim that the conditions used for CF only are evaluated for (about) the view, or for cells just getting into the view. This as evidence for the claim that filtering for colors set by CF will not be possible without major code surgery ensuring CF evaluation for all the CFed cells independent of the view.
Created attachment 175194 [details] Example file with conditional filtering per instructions
Created attachment 175195 [details] The example files conditional format: Bad style for duplicate values
The example file was made on 5 days old bibisect-7.3-win repo version: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 00eed7d73ba482ff3433afaeb1fb968de515c09d CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL Column A can be filtered by the pink background color or by the dark red text color now, after bug 142579 and bug 142580 were fixed. (In reply to Wolfgang Jäger from comment #2) > This as evidence for the claim that filtering for colors set by CF will not > be possible without major code surgery ensuring CF evaluation for all the > CFed cells independent of the view. This problem does not seem to be manifesting itself for me. If I insert enough rows filled with text in front of the second row in the above example file so that the numbers are not visible on the screen, turn off and on the autofilter, then I can still filter by the colors not visible on screen. *** This bug has been marked as a duplicate of bug 142579 ***