Download it now!
Bug 122419 - AutoFilter Search Freezes Calc in the Attached Spreadsheet
Summary: AutoFilter Search Freezes Calc in the Attached Spreadsheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: bibisectRequest, perf, regression
: 128072 (view as bug list)
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
Reported: 2019-01-02 11:58 UTC by Kevin Suo
Modified: 2020-09-17 12:34 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

Test ODS file (145.00 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-01-02 11:58 UTC, Kevin Suo

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Suo 2019-01-02 11:58:30 UTC
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.

Current Result:
Calc not responding.
You may wait for many hours to see whether Calc will become alive again.

Expected Result:
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.

Build ID:9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3
CPU 线程:4; 操作系统:Linux 4.15; UI 渲染:默认; VCL: gtk2; 
区域语言:zh-CN (zh_CN.UTF-8); Calc: group threaded
Ubuntu 18.04.1 LTS x64.
Comment 1 Oliver Brinzing 2019-01-02 12:30:28 UTC
reproducible with

Version: (x64)
Build ID: 9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: de-DE (de_DE); Calc: group

and with

Build-ID: f3153a8b245191196a4b6b9abd1d0da16eead600
Gebietsschema: de_DE

but *not* reproducible with:
Version (Build ID: e183d5b)
Comment 2 Oliver Brinzing 2019-10-10 17:13:52 UTC
*** Bug 128072 has been marked as a duplicate of this bug. ***
Comment 3 Telesto 2020-05-23 18:54:48 UTC
The autofilter drop down has no search option in; whats the alternative?
Comment 4 Buovjaga 2020-06-14 15:47:37 UTC
It only takes some seconds now. I think Noel fixed this in bug 76481. Plz re-test

Version: (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
Calc: threaded
Comment 5 Kevin Suo 2020-06-16 11:43:05 UTC
(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
weld checklistmenu

I will report a new bug for this issue instead.