https://bugs.documentfoundation.org/show_bug.cgi?id=171616
Bug ID: 171616
Summary: autofilter locks up KDE desktop while filtering
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Version: 26.2.3.0.0+ (X86_64)
Build ID: cda8d3bd61037ee5b9fa5d935c33a3b478c750c1
CPU threads: 20; OS: Linux 6.19; UI render: default; VCL: kf5 (cairo+xcb)
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded Jumbo
Operating System: Fedora Linux 43
KDE Plasma Version: 6.6.3
KDE Frameworks Version: 6.24.0
Qt Version: 6.10.2
Kernel Version: 6.19.8-200.fc43.x86_64 (64-bit)
Graphics Platform: X11
Processors: 20 × 12th Gen Intel® Core™ i7-12700K
Memory: 128 GiB of RAM (125.5 GiB usable)
Graphics Processor: AMD Radeon RX 6600 XT
Manufacturer: Dell Inc.
Product Name: XPS 8950
Loaded a 6.5M row x 8 column csv file (335MB) with the following column
characteristics:
A: 100 unique values
B: 3 unique values
C: integers (no value in filtering)
D: 23 unique values
E: random dates (no value in filtering)
F: 3 unique values
G: integers (no value in filtering)
* Enable AutoFilter.
* click a column's autofilter button
* w...a...i...t...
Worse: while waiting, even the ability to grab & move any window is
blocked, as is the ability to enter text as I was trying to do in this
report...
I was going to file this as an enhancement, until realizing the entire UI is
blocked while autofiltering... Only ONE of 20 processors is at 100%, yet all
the UI is affected.
The enhancement suggestion would be to cache up to N values so that a repeat
autofilter could avoid re-scanning the entire column to display the possible
values.
N probably should be user configurable (most of my work would be happy with
N=100).
With minimal autofilter caching, only the initial autofilter would lockup the
UI.
Sample file: https://s3.amazonaws.com/dl.ncsbe.gov/NVRA/nvra_stats_all.txt
which is UTF16LE; convert with: /usr/bin/iconv -f UTF-16LE -t UTF-8 infile >
outfile
--
You are receiving this mail because:
You are the assignee for the bug.
