https://bugs.documentfoundation.org/show_bug.cgi?id=157476
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 Status|UNCONFIRMED |NEW Version|7.5.6.2 release |7.2.0.4 release Keywords| |bibisectRequest, | |implementationError, | |regression --- Comment #2 from ady <[email protected]> --- In attachment 189848, when unchecking "empty" from the filter, results with the following rows also hidden (not just the 3 empty rows): value row 25 8.26 171 201 8.26 213 0.65 261 353 Repro in version LO 7.2 and newer, but not in older versions. This seems some kind of mix between regression and implementation error, when the "not-empty" explicit filter option disappeared and the "empty" filter option remained as part of the list of check-boxed values. Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 80a24870491385ba145757bf517c5f1cf7939017 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded I have not investigated the reason for this unexpected result. Showing _all_ rows and clearing the format of the entire column containing the relevant values (column A); when filtering again by "not-empty" values will result in the correct expected result. It sounds strange that some format of some cells/values would make the filter hide such cells when the applied filter is "not-empty"; the cell is not empty (whichever special format was applied to it). Setting to NEW. -- You are receiving this mail because: You are the assignee for the bug.
