Steps to Reproduce: 1. Open attachment 182038 [details] from bug 150618. 2. Switch to tab "RM_Withdraw_Summary", click on the autofilter dropdown in column H, deselect one item (e.g. 0.00 or 0.60), click OK. 3. Click on the autofilter dropdown in column H again. Current Result: There are several other items deselected in step 3 (other than the one item you have previously explicitly deselected in step 2). Expected Result: Since I have deselected only one item in step 2, when I click on the autofilter dropdown again in step 3 it should deselect the exact one item. Reproduced in: Version: 7.3.6.1 / LibreOffice Community Build ID: 92b673af3a5e8f7cf4716be88dfaca424612f244 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN Calc: threaded And Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: 86498bcd73050e44ea5ea53c384edb0baf033d16 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN Build Platform: Fedora34@X64, Branch:master, bibisect-linux-64-7.4-CN Calc: threaded Ubuntu 22.04
Bug already exists in the earliest commit of my 7.3 branch bibisect repo: 2021-06-13 17:27:33 +0200 a565968c2d5c7822f99266b36631e073234d48ab bump product version to 7.3.0.0.alpha0+
Works ok in Version: 7.1.0.0.beta1+ Build ID: 38372ccbfd1c6380d8655364c39c55b99459ad34 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN Build Platform: Fedora32@X64, Branch:master, bibisect-linux-64-7.2-CN Calc: threaded Although it was slow to do autofiltering in that column in this version. Regress. Bibisecting.
There were still some items deselected in 2020-11-22 14:57:49 +0100 38372ccbfd1c6380d8655364c39c55b99459ad34 bump product version to 7.1.0.0.beta1+ Although there are some difference on the UI (due to improvements such as use formatted number in the dropdown list and put the "(empty)" item on the top rather than at the bottom of the list.
Already an issue in 7.0.0 alpha 1 2020-05-27 13:56:28 +0200 574c57090642347980d2395e1e183cc7b5c171ad
This was annoying to test as sample is large and slow for me. At first it seemed from repro 6.2 but later seemed no repro with 7.1 in Lin repo, repro 7.2 and 7.5+ Win and Lin. So this is a regression.
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/9ebcb0271b4f1a4a1381e32c3c133e099a451806 tdf#157476 tdf#150861 - sc fix autoFilter is filtering incorrectly It will be available in 25.8.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.
Balazs Varga committed a patch related to this issue. It has been pushed to "libreoffice-25-2": https://git.libreoffice.org/core/commit/97bab05d04393bf4f04ff4df17aac8b6843f1a85 tdf#157476 tdf#150861 - sc fix autoFilter is filtering incorrectly It will be available in 25.2.0.0.beta2. 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.
Balazs Varga committed a patch related to this issue. It has been pushed to "libreoffice-24-8": https://git.libreoffice.org/core/commit/a20cf841d0217e7a75e306ed97ac54da56c19bfd tdf#157476 tdf#150861 - sc fix autoFilter is filtering incorrectly It will be available in 24.8.5. 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.