Issue 89016 - Please increase (or even make configurable) scanrange of autoinput
Summary: Please increase (or even make configurable) scanrange of autoinput
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: DEV300_m10
Hardware: PC All
: P3 Trivial with 15 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-05-05 08:08 UTC by pmike
Modified: 2013-02-07 22:40 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

sample (14.66 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-05-05 08:09 UTC, pmike
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description pmike 2008-05-05 08:08:39 UTC
Load sample file any type letter 'O' in cell D273.
Autoinput will suggest word "On" from D69, but ignores "Off" from D68.

Then have a look at column E, where backward numbering shows that only last 200
items are considered by autoinput.
Comment 1 pmike 2008-05-05 08:09:23 UTC
Created attachment 53374 [details]
Comment 2 kpalagin 2008-05-05 14:11:49 UTC
Help says:
"Switches the AutoInput function on and off, which automatically completes 
entries, based on other entries in the same column. The column is scanned up 
to a maximum of 2000 cells or 200 different strings."

Calc behaves exactly by description, but sometimes this is just not enough.
Please make the number of cells and distinct strings configuable (via 
calc.xcu, if not via GUI).
Comment 3 oc 2008-07-15 10:44:47 UTC
reassigning features and enhancements to user which
will be the default owner for those tasks (was introduced some time ago)