[Libreoffice-bugs] [Bug 117234] New: FILTER: Typing in the autofilter box on a long list causes keyboard entry to be incorrectly entered

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: davidjmcgowan at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180425/be839406/attachment-0001.html>