Created attachment 147932 [details]
Test ODS file
There are 41670 records in the attached spreadsheet. Searching in the auto filter search box makes Calc freezes.
Steps to Reproduce:
1. Click the autofilter drop down list in column A.
2. Type in some text (e.g., "2") in the autofilter search box to search.
Calc not responding.
You may wait for many hours to see whether Calc will become alive again.
Calc shows the search results within a reasonable time.
This kind of job works perfect in Excel. The data comes from real world daily work.
CPU 线程：4; 操作系统：Linux 4.15; UI 渲染：默认; VCL: gtk2;
区域语言：zh-CN (zh_CN.UTF-8); Calc: group threaded
Ubuntu 18.04.1 LTS x64.
Version: 22.214.171.124 (x64)
Build ID: 9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: de-DE (de_DE); Calc: group
but *not* reproducible with:
Version 126.96.36.199 (Build ID: e183d5b)
*** Bug 128072 has been marked as a duplicate of this bug. ***
The autofilter drop down has no search option in 188.8.131.52; whats the alternative?
It only takes some seconds now. I think Noel fixed this in bug 76481. Plz re-test
Version: 184.108.40.206.alpha0+ (x64)
Build ID: 7f6d7a0eb624d67421cd5af6462ee2a662fdff3a
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win
Locale: fi-FI (fi_FI); UI: en-US
(In reply to Buovjaga from comment #4)
No, none of those two commits fixed this issue, it still takes a long time to filter using the test document in this bug on master as of today.
In addition, when testing this bug, I find the following commit seems to have caused a regression: before this commit I am able to open the dropdown of the test document, but with this commit when I click on the drop list Calc simply hangs:
2020-06-12 20:03:54 +0200 a16e6122dc62f545df90b9ea4d1f4723c46336b6
author Caolán McNamara
I will report a new bug for this issue instead.