Created attachment 127783 [details] version used Greetings, Kindly asking your support for LibreOffice Calc, when I put strings as in autofilter of the spreadsheet the application crashed down. Sincerely, Chuscky
Please attach a minimal sample file where to test the issue.
Created attachment 127796 [details] ODS File
By crash you mean Calc hangs, right? Hangs for me with 5.2.1.2 and 5.3 master builds (id: 4563921f23d79f6e3e431a314064c6dd201cfee2) / Windows 7. Document itself loads slowly because it has 482195 rows, and opening the autofilter is slow as well for the same reason, at least on columns with many different entries. Hang only happens when filtering on such columns (like Cell ID and not on Vendor for example).
(In reply to Aron Budea from comment #3) > By crash you mean Calc hangs, right? > > Hangs for me with 5.2.1.2 and 5.3 master builds (id: > 4563921f23d79f6e3e431a314064c6dd201cfee2) / Windows 7. > > Document itself loads slowly because it has 482195 rows, and opening the > autofilter is slow as well for the same reason, at least on columns with > many different entries. Hang only happens when filtering on such columns > (like Cell ID and not on Vendor for example). Yes it hangs then (Not Responding) I will terminate the session by Task Manager. 482195 rows is almost 50 percent of the maximum rows allotted, it this the limitation of the program? Hangs happen on all columns except for Vendor, because it had only one string format.
Some slowness can be expected, but no, it shouldn't be a limitation.
Created attachment 129498 [details] a backtrace I confirmed on both: Version: 5.2.2.2 Build ID: 1:5.2.2-0ubuntu2 CPU Threads: 2; OS Version: Linux 4.9; UI Render: default; Locale: en-US (en_US.UTF-8); Calc: group (My debug dev build) Version: 5.4.0.0.alpha0+ Build ID: f35d29c8388744be1f95ec4acfca12eec706911a CPU Threads: 2; OS Version: Linux 4.9; UI Render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); Calc: group
*** Bug 105406 has been marked as a duplicate of this bug. ***
I can reproduce this bug with v5.3.1 on Linux (Xubuntu 16.04). Using autofilter on a column with > 100k rows and entering a single letter in the search box will completely freeze Libreoffice *and* (surprisingly) the whole X, i.e. I have to switch to a console terminal (Ctrl+F1) and kill soffice to be able to continue. Libreoffice is using 100% CPU of one core and does not return within reasonable time (10-20s). To reproduce this issue: - ungzip file in attachment - run libreoffice --calc aaa.txt and keep default values for import - Mark whole sheet, set autofilter on all columns - Choose autofilter on column "GeneSymbol" - Try to enter something in search box -> LO will freeze immediately (before even showing the entered letter)
Just found out that the test file is too big for upload. Please use this one instead: ftp://ftp.sanger.ac.uk/pub/gencode/Gencode_mouse/release_M12/gencode.vM12.metadata.MGI.gz - ungzip file to file aaa.txt - run libreoffice --calc aaa.txt and keep default values for import - Mark whole sheet, set autofilter on all columns - After selecting auto filter, click "yes" when asked if the first row should be used as header line. - Choose filter second column - Try to enter something in search box -> LO will freeze immediately (before even showing the entered letter) Interestingly, If the first line is not chosen as header line, Calc still freezes but X stays responsive.
*** This bug has been marked as a duplicate of bug 76481 ***
Reopened because bug 76481 (opening of autofilter UI freeze) seems to be resolved. Version: 6.2.6.2 Build ID: 1:6.2.6-0ubuntu0.16.04.1~lo1 CPU threads: 8; OS: Linux 4.4; UI render: default; VCL: gtk2; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded i7-4712MQ CPU @ 2.30GHz Opening the autofilter UI and entering a single character in the search box freezes the UI for several minutes. Same for removing the character afterwards. Time of freeze seems to depend on the length of the list of remaining entries in the list (i.e. the entries in the listbox below), as entering more characters reduces the waiting time. Tested with attachment #2 and also with data set from bug 76481 (220k rows).
The issue is still unresolve both in stable and fresh release . Version: 6.3.5.2 (x64) Build ID: dd0751754f11728f69b42ee2af66670068624673 CPU threads: 8; OS: Windows 10.0; UI render: default; VCL: win; Locale: en-PH (en_PH); UI-Language: en-US Calc: threaded
Mark as a duplicate of bug 122419 instead, see my comment in: bug 76481#c31 *** This bug has been marked as a duplicate of bug 122419 ***