Bug 150861 - Autofilter result is wrong when I deselect one item, click OK, then click on the dropdown again
Summary: Autofilter result is wrong when I deselect one item, click OK, then click on ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.3.1 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
 
Reported: 2022-09-08 15:58 UTC by Kevin Suo
Modified: 2023-09-28 05:18 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Suo 2022-09-08 15:58:55 UTC
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
Comment 1 Kevin Suo 2022-09-08 16:30:17 UTC
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+
Comment 2 Kevin Suo 2022-09-08 17:23:02 UTC Comment hidden (obsolete)
Comment 3 Kevin Suo 2022-09-08 17:36:21 UTC
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.
Comment 4 Kevin Suo 2022-09-08 17:59:25 UTC
Already an issue in 7.0.0 alpha 1
2020-05-27 13:56:28 +0200 574c57090642347980d2395e1e183cc7b5c171ad
Comment 5 Timur 2022-09-09 11:09:23 UTC
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.