Bug 150861

Summary:	Autofilter result is wrong when I deselect one item, click OK, then click on the dropdown again
Product:	LibreOffice	Reporter:	Kevin Suo <suokunlong>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	minor	CC:	telesto
Priority:	medium	Keywords:	bibisectRequest, regression
Version:	7.0.3.1 release
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=151152 https://bugs.documentfoundation.org/show_bug.cgi?id=157476
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	103512

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)

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.

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.