Bug 153038 - Autocomplete fails to find data further away than 101-102 rows
Summary: Autocomplete fails to find data further away than 101-102 rows
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
7.0.4.2 release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-01-16 06:33 UTC by Sean Cusack
Modified: 2023-01-16 07:09 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
actionable annotated example (11.91 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-01-16 06:33 UTC, Sean Cusack 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Sean Cusack 2023-01-16 06:33:09 UTC 
Description:
If you try to fill in data that is 101 rows down or more, or 102 rows up or more, the autocomplete will not find it

Steps to Reproduce:
See attached broken-libreoffice-autocomplete.ods

Go to A104 and A105 and try to type "abeyance" to see if it autocompletes

Go to A109 and A110 and try to type "aardvark" to see if it autocompletes

Actual Results:
Ignores data more than 101-102 rows away

Expected Results:
Should use all data, or at least be selectable or configurable


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.0.4.2
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 1 Sean Cusack 2023-01-16 06:33:54 UTC 
Created attachment 184677 [details]
actionable annotated example
Comment 2 Sean Cusack 2023-01-16 06:51:44 UTC 
Argh, i should have upgraded to 7.4.4 before filing this. It it no longer a bug in 7.4.4.
Comment 3 Julien Nabet 2023-01-16 07:09:04 UTC 
No pb, let's put this one to WFM then.