Bug 145765 - Calc reacts slowly during filter
Summary: Calc reacts slowly during filter
Status: RESOLVED DUPLICATE of bug 133835
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2021-11-18 19:28 UTC by Lagoda Nico
Modified: 2021-11-25 15:43 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Calc "example" file (5.88 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-11-18 19:28 UTC, Lagoda Nico

Note You need to log in before you can comment on or make changes to this bug.
Description Lagoda Nico 2021-11-18 19:28:00 UTC
Created attachment 176349 [details]
Calc "example" file

Hello, I'm new in using Libreoffice. A good tool but to be honest, as I'm an Excel worker Calc is the most important software. In normal using it works fine but a mjor problem is the speed in general (only Calc the other work verry normal). An example is the attached file. It takes +/ 26 secondes to open the filter on any place. Ok thats not bad, but, if you are working fluend it is annoying.
Comment 1 Kevin Suo 2021-11-25 15:43:49 UTC
Dear Lagoda Nico:

Thanks for reporting. Yes, auto-filter on large datasets *was* very slow, that was an known issue. However, this has improved now, see bug 133835 and bug 136838. For most test cases with large datasets, the autofilter now is instant.

I tested and your test document, after opened, now the autofilter opens instant on my master build. However, I do see that your document opens very slow, which seems to be slow in the calculation of formula, and should be a separate issue.

To test, you may use a daily build tomorrow (those commits will only be included in the daily builds starting from the end of today(, to see if it is fixed there. PLEASE BE AWARE THAT DAILY BUILDS CAN NOT BE USED FOR DAILY WORK, AS IT MAY BREAK YOUR DOCUMENT! MAKE A BACKUP OF YOUR DOCUMENT BEFORE TRYING!


I do not expect those improvements will be backported to the 7.2 branch, due to regression concerns. So I am afraid you have to wait for the upcoming 7.3 release before enjoining the faster autofilter. If possible, please help us to test and improve. Thanks!

*** This bug has been marked as a duplicate of bug 133835 ***