Created attachment 201004 [details] test ods file This bug is very annoying and is difficult to explain in narrative description, so please follow the simple steps. The attached ods file contains the following simple data: a b 1 10 2 10 3 11 4 10 Steps to Reproduce: 1. In autofilter dropdown column B, check “10” only, click OK. 2. In autofilter dropdown column A, check "1" only, click OK, and change the value in cell B2 to something else (e.g. "Y"). 3. In autofilter dropdown column A, check "2" only, click OK. Expected Result: Only entry "2" is shown in step 3. Current Result: All the remaining entries are shown (i.e. "2" and "4").
It is also observed that after the wrong result in step 3 is shown, repeating step 3 will show the expected result.
Version: 25.2.4.0.0+ (X86_64) / LibreOffice Community Build ID: 1cb3d5dfdebf705c89ef00a2292b791a86ea3922 CPU threads: 8; OS: Linux 6.14; UI render: default; VCL: gtk3 Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN Calc: threaded
Works for me Version: 25.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 043b186d10fca4a613ce62c1e0d04f86ec63799c CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win Locale: en-US (es_ES); UI: en-US Calc: CL threaded
Thank you for reporting the bug. I can confirm that the bug is present in both versions of LibreOffice below running on Linux Mint. Other notable behavior is that when attempting to change the Column A filter from '1' to '2' in step 3, the '1' is visibly selected, but cannot be toggled to deselect (it is greyed out/faded). Selecting the '2' adds to the already-selected '1', but after 'OK' is chosen, the filter now shows '2' and '4' as having been selected. Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 866538a4aeb30a598a6ede3d1763d898eb1920b0 CPU threads: 2; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Version: 24.2.7.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 2; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.4 Calc: threaded