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.
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! https://dev-builds.libreoffice.org/daily/master/ 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 ***