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).
No further input from UX required, let's do it.
Very good Idea. The solution like in WPS seems to be a good one!
Kendy pointed out that we already have this - it just is not opened automatically. The UNO command is .uno:DataSelect and the default shortcut is Alt-down. Id is SID_DATA_SELECT See the function ScTabView::StartDataSelect in sc/source/ui/view/tabview.cxx and ScGridWindow::LaunchDataSelectMenu in sc/source/ui/view/gridwin.cxx
Spent a little time on this for bug150633 and bug 150644 The <alt><down> listbox is OK, but it needs a little more to be useful. Specifically, it defaults now to simply listing all the unique values contained in the column. What is needed to make it minimally functional on larger sheets is to filter the lb content based on a partial text entry being made. And idealy, filter the lb content with a regex pattern match (beginning or end of entry like quikee did for the HUD).