The Autoinput setting in TOOLS seems to have two different functions (that I’ve noticed).
Not only does it toggle syntax tips when entering a formula but it will also automatically complete text in a cell when it finds a previous match in the column.
Shouldn’t these be two separate functions - especially as it only really seems to make sense in the text autocomplete context?
I had considered it might be a bug but was uncertain
Bugzilla – Bug tdf#144860 Submitted
1 Like
So, whats the meaning of:
When typing formulas using characters that match previous entries, a Help tip will appear listing the last ten functions used from Function Wizard, from all defined range names, from all database range names, and from the content of all label ranges.
Source: AutoInput
That’s mixing up things and wrong. The help tip displays function names, range names and label names matching the input. The last ten used functions (not only from the Function Wizard) are available in the Name Box, not in the help tip.
And it’s not related to AutoInput, except that disabling that also wrongly disables the function help tip.