https://bugs.documentfoundation.org/show_bug.cgi?id=117234
Bug ID: 117234
Summary: FILTER: Typing in the autofilter box on a long list
causes keyboard entry to be incorrectly entered
Product: LibreOffice
Version: 6.0.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: davidjmcgo...@outlook.com
Description:
When using autofilter against a large (ish) list (3 columns, 5000 rows, csv
format, unique id - email address - name) typing in the filter box causes a
delay, the delay causes the user input to be entered in a different order to
keys pressed.
example
actual - booking, hotmail, @guest.
result - bokingo, hotmail, @gust.e
the number of results in the list matching the search query influences the
resulting level of disorder in the input.
adding a delay in the processing of the characters as opposed to immediately
trying to sort per letter, if you wait for each letter to restrict the list,
the performance increases dramatically for each additional letter entered.
I get the same issue on ubuntu 17 as i do on fedora 21
Steps to Reproduce:
1.create a large csv approx 5000 rows
2.ensure that at least 2000 rows share a common word or phrase
3.add autofilter to the csv data
4.enter the common word or phrase into the search box, typing at normal speed
5.wait for the word to appear, words longer than 7 characters are likely to be
garbled, if not, elongate the list or use a longer word the problem will show
Actual Results:
user input is garbled
Expected Results:
user input is entered correctly
Reproducible: Always
User Profile Reset: Yes
Additional Info:
OpenGL (or in my case "hardware acceleration") being toggled on or off makes no
difference.
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/66.0.3359.117 Safari/537.36
--
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
