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)
Version:
(earliest affected)
4.4.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, perf, regression
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
 
Reported: 2019-01-02 11:58 UTC by Kevin Suo
Modified: 2019-04-21 06:49 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


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

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.


版本:6.1.4.2
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: 6.1.4.2 (x64)
Build ID: 9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: de-DE (de_DE); Calc: group

and with

Version: 4.4.7.2
Build-ID: f3153a8b245191196a4b6b9abd1d0da16eead600
Gebietsschema: de_DE

but *not* reproducible with:
Version 3.6.7.2 (Build ID: e183d5b)