Created attachment 161390 [details]
Word completion suggestions
When typing in Calc, words that already exist in the document are suggested while typing.
Hitting return accepts the suggestion.
This sometimes makes you accept the suggestion unintentionally, as you also use return to go to the next cell.
WPS Sheets has solved this with a dropdown instead of autocomplete (see attached screenshot). This way users can choose from multiple suggestions, and also they don't unintentionally accept a suggestion, since hitting Return just finishes editing in the current cell and moves to the next.
I suggest to implement a similiar kind of dropdown in LO too.
Seems reasonable, if it remains light weight--performant.
And, would the listbox of suggestions be drawn from current column, sheet, or the full ODS?
Yes, as known from intelligent code completion (aka IntelliSense).
Do you need further input from UX?
(In reply to V Stuart Foote from comment #1)
> And, would the listbox of suggestions be drawn from current column, sheet,
> or the full ODS?
In WPS this list comes from the current column (which probably makes sense especially in large spreadsheets).