Bug 168193 - Significant delay in autofilter lock
Summary: Significant delay in autofilter lock
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
 
Reported: 2025-08-30 06:00 UTC by Kevin Suo
Modified: 2025-10-09 05:44 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
test ods file (218.46 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-08-30 06:00 UTC, Kevin Suo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Suo 2025-08-30 06:00:42 UTC
Created attachment 202612 [details]
test ods file

There is a significant delay when you click the "Lock" in the autofilter dropdown.

Steps to Reproduce:
1. Open the attached test document.
2. Click the autofilter dropdown for any of the columns, then click "Lock" which appears in the dropdown.

--> For me, it takes ~5 seconds to respond.

Version: 25.8.1.0.0+ (X86_64) / LibreOffice Community
Build ID: 3c8a54698ef7ea11d17f564d273464640c5b02b9
CPU threads: 8; OS: Linux 6.15; UI render: default; VCL: gtk3
Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN
Calc: threaded

This is a possible regression.
Comment 1 m_a_riosv 2025-08-30 09:56:16 UTC
Less than 3 seconds for me.
Version: 25.8.1.0.0+ (X86_64) / LibreOffice Community
Build ID: 1e040b72222012f9a5f1e47d19aaf0c0369e08ad
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 2 Saburo 2025-10-09 05:44:06 UTC
Less than 3 seconds for me.
Performance has not changed since the commit in which the lock feature was added.
remove keyword: possibleRegression

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: d4c34206bcf64b94eac4f0761aeacc285e08af55
CPU threads: 2; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: en-US
Calc: threaded

tdf#133836 Autofilter allow adding up members to the current selection

Added a new checkbox [x] Lock, which if checked locks the current
selection, and further items then can be added to that locked
selection