Bug 133494 - Improve word completion suggestions
Summary: Improve word completion suggestions
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Keywords: needsUXEval
Depends on:
Blocks: AutoCorrect-Complete
  Show dependency treegraph
Reported: 2020-05-29 09:49 UTC by Samuel Mehrbrodt (allotropia)
Modified: 2020-06-05 21:25 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Word completion suggestions (13.03 KB, image/png)
2020-05-29 09:49 UTC, Samuel Mehrbrodt (allotropia)

Note You need to log in before you can comment on or make changes to this bug.
Description Samuel Mehrbrodt (allotropia) 2020-05-29 09:49:44 UTC
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.
Comment 1 V Stuart Foote 2020-05-30 13:46:44 UTC
Seems reasonable, if it remains light weight--performant. 

And, would the listbox of suggestions be drawn from current column, sheet, or the full ODS?
Comment 2 Heiko Tietze 2020-06-03 11:09:16 UTC
Yes, as known from intelligent code completion (aka IntelliSense).
Do you need further input from UX?
Comment 3 Samuel Mehrbrodt (allotropia) 2020-06-04 05:44:47 UTC
(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).