Bug 91307 - Editing: (calc) using autofilter pulldown in file with 10.000+ rows. Checking and unchecking boxes freeses Libreoffice. Pulldown menu disappears sometimes.
Summary: Editing: (calc) using autofilter pulldown in file with 10.000+ rows. Checking...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: x86 (IA32) Windows (All)
: medium critical
Assignee: Markus Mohrhard
URL:
Whiteboard:
Keywords: perf
: 98082 (view as bug list)
Depends on:
Blocks:
 
Reported: 2015-05-15 13:33 UTC by Haico
Modified: 2016-12-13 20:20 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
File containing 10.000+ rows with autofilter. (693.02 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-05-15 13:33 UTC, Haico
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Haico 2015-05-15 13:33:48 UTC
Created attachment 115624 [details]
File containing 10.000+ rows with autofilter.

The graphical outlook of the pulldown menu of calc got a new look in the 4.2 LibreOffice version. After that the pulldown menu is not working for me any more. It can't handle 10K+ rows. So I'm still with the latest release of the 4.1 series.
Pulling down the menu is not a problem. Unchecking all boxes takes a very long time. Checking a view boxes and selecting isn't going very smoothly but gives the desired result. Now I'm trying to check all boxes again. Calc freezes and after a while the pulldown menu disappears. Can't use it anymore.
Tried many versions since, up to the current 5.5 alpha release. Everytime I get the same result. It's the reworked graphical look of the autofilter pulldown menu which Libreoffice has since the 4.2 release which is giving me problems.
Comment 1 Buovjaga 2015-05-18 17:48:50 UTC
Tried with the filter in column A.
Unchecked all by clicking "All" checkbox. No delay.
Selected one. OK.
Checked All. No delay.

Btw. found a crash bug in 5.0: bug 91364
It seems related to the recent internal UI changes (VclPtr).

Win 7 Pro 64-bit, Version: 4.4.3.2
Build ID: 88805f81e9fe61362df02b9941de8e38a9b5fd16
Locale: fi_FI
Comment 2 Carlos Rodriguez 2015-06-13 16:18:14 UTC
I see the problem with columns B or C from the first sheet. Big delay, about 25s to check/uncheck "All".

The menu is ok, does not disappears, just got the problem with the delay.

Same behaviour on:

Versión: 4.4.3.2
Id. de compilación: 88805f81e9fe61362df02b9941de8e38a9b5fd16
Configuración regional: es_ES

Version: 4.4.5.0.0+
Build ID: e37cf07d5fc9aaa7143cb98a71ee3c2662cfc263
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-4, Time: 2015-06-12_11:50:46
Locale: es_ES.UTF-8

Version: 5.0.0.0.beta3+
Build ID: c9be3ebba438d202906ddb9da05a27a7fb5c1ab6
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-5-0, Time: 2015-06-12_23:27:58
Locale: es-ES (es_ES.UTF-8)

Version: 5.1.0.0.alpha1+
Build ID: a9286c302e96258f32d13fb66aced25750e82cd3
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-06-13_00:03:04
Locale: es-ES (es_ES.UTF-8)
Comment 3 Buovjaga 2015-06-13 16:29:49 UTC
Well let's set to NEW per comment 2.
Comment 4 Kevin Suo 2015-10-13 06:01:45 UTC
Reproduced with
Version: 5.0.3.1
Build ID: fd8cfc22f7f58033351fcb8a83b92acbadb0749e
Locale: zh-CN (zh_CN)
Win10 X86

Filtering conlum B and C hangs Calc.

Adding bug 78664 as see also.
Comment 5 Robinson Tryon (qubit) 2015-12-09 18:07:57 UTC Comment hidden (obsolete)
Comment 6 Markus Mohrhard 2016-02-20 08:31:47 UTC
Fix for this is in gerrit.
Comment 7 Markus Mohrhard 2016-02-20 09:07:09 UTC
I forgot the bug number in the commit msg:

https://cgit.freedesktop.org/libreoffice/core/commit/?id=7967e5e51e5210b8c3d3dc63502bd7d875eb36b7
Comment 8 Cor Nouws 2016-02-22 12:23:56 UTC
Hi Markus,

Can this be please added to 5.0.6. and 5.1.1(2)?
Thanks,
Cor
Comment 9 Markus Mohrhard 2016-02-22 13:40:08 UTC
(In reply to Cor Nouws from comment #8)
> Hi Markus,
> 
> Can this be please added to 5.0.6. and 5.1.1(2)?
> Thanks,
> Cor

@Cor: It will surely not go into 5.0. I'm still not sure about 5.1 until I can be more sure that the shortcut that I took is safe.
Comment 10 Cor Nouws 2016-02-22 21:09:01 UTC
*** Bug 98082 has been marked as a duplicate of this bug. ***
Comment 11 Cor Nouws 2016-03-29 06:32:21 UTC
(In reply to Markus Mohrhard from comment #9)
> 
> @Cor: It will surely not go into 5.0. I'm still not sure about 5.1 until I
> can be more sure that the shortcut that I took is safe.

@markus,
did you have any opportunity to look at/more info about the possibility to push this to 5.0 / 5.1 too?
Thanks,
Comment 12 Aron Budea 2016-08-24 20:23:46 UTC
Haico, the bugfix is in v5.2. If the fix didn't get rid of your bug, reopen this bug report instead of complaining in a different one (bug 78664) without giving any new detail.
Comment 13 Markus Mohrhard 2016-08-24 20:36:15 UTC
(In reply to Cor Nouws from comment #11)
> (In reply to Markus Mohrhard from comment #9)
> > 
> > @Cor: It will surely not go into 5.0. I'm still not sure about 5.1 until I
> > can be more sure that the shortcut that I took is safe.
> 
> @markus,
> did you have any opportunity to look at/more info about the possibility to
> push this to 5.0 / 5.1 too?
> Thanks,

This is going to be a 5.2 only fix. The fix already caused one regression and I don't plan to take that risk for 5.1.