[Libreoffice-bugs] [Bug 76481] Using autofilter pulldown - !type in search box! - on column with particular amount of records will freeze graphical mode, after few minutes normal state is restored
https://bugs.documentfoundation.org/show_bug.cgi?id=76481 Kevin Suo changed: What|Removed |Added Resolution|--- |FIXED Status|REOPENED|RESOLVED --- Comment #31 from Kevin Suo --- There are (were) 2 different problems in the autofilter: 1. When a sheet contains may records, then it was slow when you open the autofilter dropdown list (without typing any text in the search box). This is what the original bug reporter has reported. And it was true in previous versions, but based on my test it has improved a lot. At least, on master branch under Fedora 32 I can open the 1st test doc attached to this bug (attachment 96201) within 4 seconds. This was reported to take several minutes to open up the autofilter dropdown. As a result, this issue was RESOLVED. 2. When a column contains many unique items, then it is very slow when you type in a char in the autofilter dropdown search box. It is only slow when there are many unique items (i.e., it is not slow to type in the search box if the column only contains several limited number of unique values) This (the 2nd) bug behaviour is still reproducible on master builds as of today, and I suspect a lot of duplicated bug reports. One example was the one I have reported in bug 122419. The bad thing is that, a lot of bugs with behaviour #2 (but not #1) was wrongly marked as duplicates of this bug (i.e., the bug I am now posting). For instance, bug 102927. As a result, I will mark this bug as RESOLVED FIXED, and move those with behaviour #2 to bug 122419. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76481] Using autofilter pulldown - !type in search box! - on column with particular amount of records will freeze graphical mode, after few minutes normal state is restored
https://bugs.documentfoundation.org/show_bug.cgi?id=76481 Kevin Suo changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||2419 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76481] Using autofilter pulldown - !type in search box! - on column with particular amount of records will freeze graphical mode, after few minutes normal state is restored
https://bugs.documentfoundation.org/show_bug.cgi?id=76481 --- Comment #30 from Roman Kuznetsov <79045_79...@mail.ru> --- 20 sec when I try type a "W" letter in Version: 7.1.0.0.alpha0+ Build ID: 2047a5978ac8188e61da9cd3b2f40d86df5570bb CPU threads: 4; OS: Mac OS X 10.15.4; UI render: default; VCL: osx Locale: ru-RU (ru_RU.UTF-8); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76481] Using autofilter pulldown - !type in search box! - on column with particular amount of records will freeze graphical mode, after few minutes normal state is restored
https://bugs.documentfoundation.org/show_bug.cgi?id=76481 --- Comment #29 from Commit Notification --- Noel Grandin committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/98aced3625168e454679d3a14ebcdf55a67cbc18 fix tree disabled in autofilter pulldown, tdf#76481 related It will be available in 7.0.0.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76481] Using autofilter pulldown - !type in search box! - on column with particular amount of records will freeze graphical mode, after few minutes normal state is restored
https://bugs.documentfoundation.org/show_bug.cgi?id=76481 Commit Notification changed: What|Removed |Added Whiteboard|target:7.0.0 target:7.1.0 |target:7.0.0 target:7.1.0 ||target:7.0.0.1 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76481] Using autofilter pulldown - !type in search box! - on column with particular amount of records will freeze graphical mode, after few minutes normal state is restored
https://bugs.documentfoundation.org/show_bug.cgi?id=76481 --- Comment #28 from Commit Notification --- Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b81432a23c900329ece07854fd06a35a97c1 fix tree disabled in autofilter pulldown, tdf#76481 related It will be available in 7.1.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76481] Using autofilter pulldown - !type in search box! - on column with particular amount of records will freeze graphical mode, after few minutes normal state is restored
https://bugs.documentfoundation.org/show_bug.cgi?id=76481 Commit Notification changed: What|Removed |Added Whiteboard|target:7.0.0|target:7.0.0 target:7.1.0 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76481] Using autofilter pulldown - !type in search box! - on column with particular amount of records will freeze graphical mode, after few minutes normal state is restored
https://bugs.documentfoundation.org/show_bug.cgi?id=76481 --- Comment #27 from NISZ LibreOffice Team --- (In reply to Telesto from comment #26) > (In reply to b. from comment #25) > > @Noel: don't see real better performance, neither with lin (master form > > today homebrew) nor with win (daily from today), > > No difference indeed With the first attachment, filtering for a letter (tried W) in 220 000 lines in Version: 6.4.0.3 (x86) Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win; Locale: hu-HU (hu_HU); UI-Language: en-US Calc: CL took about 2.5 mins, now with latest nightly Version: 7.0.0.0.alpha1+ (x64) Build ID: 21875558f6c478f07d68ff39e025d7ffd451674f CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL it takes between 22-28 secs (I measured multiple letters with my phone stopwatch). I see real difference, but there should still be room for further improvement. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76481] Using autofilter pulldown - !type in search box! - on column with particular amount of records will freeze graphical mode, after few minutes normal state is restored
https://bugs.documentfoundation.org/show_bug.cgi?id=76481 Telesto changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|FIXED |--- --- Comment #26 from Telesto --- (In reply to b. from comment #25) > @Noel: don't see real better performance, neither with lin (master form > today homebrew) nor with win (daily from today), No difference indeed Version: 7.0.0.0.alpha1+ (x64) Build ID: b587de60d4e6aa96238766272d94f1499b22f696 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win; Locale: nl-NL (nl_NL); UI: en-US Calc: CL -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76481] Using autofilter pulldown - !type in search box! - on column with particular amount of records will freeze graphical mode, after few minutes normal state is restored
https://bugs.documentfoundation.org/show_bug.cgi?id=76481 --- Comment #25 from b. --- @Noel: don't see real better performance, neither with lin (master form today homebrew) nor with win (daily from today), @all: technically it is! possible to have the results of an instring search even with 100k random! cells within milliseconds, see standard filter and 'contains', thus why is it a problem for autofilter since 6+ years with 11+ duplicate and plenty similar and related bugs ... -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76481] Using autofilter pulldown - !type in search box! - on column with particular amount of records will freeze graphical mode, after few minutes normal state is restored
https://bugs.documentfoundation.org/show_bug.cgi?id=76481 Noel Grandin changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76481] Using autofilter pulldown - !type in search box! - on column with particular amount of records will freeze graphical mode, after few minutes normal state is restored
https://bugs.documentfoundation.org/show_bug.cgi?id=76481 --- Comment #24 from Commit Notification --- Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f71557e958a8a626dfc1eef646b84b3c8b72569a tdf#76481 speed up searching in autofilter pulldown It will be available in 7.0.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76481] Using autofilter pulldown - !type in search box! - on column with particular amount of records will freeze graphical mode, after few minutes normal state is restored
https://bugs.documentfoundation.org/show_bug.cgi?id=76481 Commit Notification changed: What|Removed |Added Whiteboard||target:7.0.0 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76481] Using autofilter pulldown - !type in search box! - on column with particular amount of records will freeze graphical mode, after few minutes normal state is restored
https://bugs.documentfoundation.org/show_bug.cgi?id=76481 b. changed: What|Removed |Added CC||danieldiazdelaiglesia@gmail ||.com --- Comment #23 from b. --- *** Bug 124080 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76481] Using autofilter pulldown - !type in search box! - on column with particular amount of records will freeze graphical mode, after few minutes normal state is restored
https://bugs.documentfoundation.org/show_bug.cgi?id=76481 b. changed: What|Removed |Added Summary|Using autofilter pulldown |Using autofilter pulldown - |on column with particular |!type in search box! - on |amount of records will |column with particular |freeze graphical mode, |amount of records will |after few minutes normal|freeze graphical mode, |state is restored |after few minutes normal ||state is restored --- Comment #22 from b. --- this bugs file and the initial bug description working fine - open dropdown nopro, selecting value nopro - and thus leading to the idea 'solved', while the description to key something into the search box is hidden in plenty comments, and other bugs with better description are pulled away as duplicates, blocks getting in touch with the problem, thus i changed the title to - !type in search box! - because that triggers the mentioned bug on my system, there are! other conditions and other freezes in similar and dup bugs, and hints on specific conditions as well in this thread, with 7.0.0.0.a1+ on win7 x64 i could only repro the search box issue, but that 'all the time'. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
