Bug 117234 - FILTER: Typing in the autofilter box on a long list causes keyboard entry to be incorrectly entered
Summary: FILTER: Typing in the autofilter box on a long list causes keyboard entry to ...
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
 
Reported: 2018-04-25 17:15 UTC by David Mcgowan
Modified: 2019-03-21 11:25 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
sample data (353.74 KB, text/csv)
2018-04-26 18:37 UTC, David Mcgowan
Details
I can't reproduce it in LibreOffice 6.2 (218.61 KB, image/png)
2018-07-09 15:39 UTC, Xisco Faulí
Details

Note You need to log in before you can comment on or make changes to this bug.
Description David Mcgowan 2018-04-25 17:15:23 UTC
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
Comment 1 Jacques Guilleron 2018-04-26 16:14:43 UTC
Hi David,

Can you provide such a test file? This would be really very kind.
Thank you.
Comment 2 David Mcgowan 2018-04-26 18:36:06 UTC
Yeah, ive included a csv of sample data, hashed, except for the portion after the @ on emails ending guest.booking.com 

if you autofilter this csv and try typing in "booking" you will get the bug if it is reproducible.
Comment 3 David Mcgowan 2018-04-26 18:37:14 UTC
Created attachment 141658 [details]
sample data
Comment 4 Buovjaga 2018-06-07 17:21:56 UTC
Not reproduced.

Version: 6.0.4.2 (x64)
Build ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: fi-FI (fi_FI); Calc: group

Arch Linux 64-bit
Version: 6.0.4.2
Build ID: 6.0.4-1
CPU threads: 8; OS: Linux 4.16; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Comment 5 Xisco Faulí 2018-07-09 15:39:14 UTC
Created attachment 143400 [details]
I can't reproduce it in LibreOffice 6.2
Comment 6 Xisco Faulí 2018-07-09 15:39:54 UTC
I can't reproduce it in

Version: 6.2.0.0.alpha0+
Build ID: 67f3063b7c334d4d5c59132d90b938671aad09f0
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group threaded

Could you please paste the info from Help - about LibreOffice ?

I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' once the information has been provided
Comment 7 QA Administrators 2019-01-11 15:22:02 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2019-03-21 11:25:42 UTC
Dear Bug Submitter,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-20190321