Bug 46949 - When autocompletion suggests a string, the suggestion should be ignored when clicking outside the cell
Summary: When autocompletion suggests a string, the suggestion should be ignored when ...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL: https://help.libreoffice.org/6.4/en-U...
Keywords: needsUXEval
: 126117 (view as bug list)
Depends on:
Blocks: AutoCorrect-Complete
  Show dependency treegraph
Reported: 2012-03-04 01:50 UTC by jbotte
Modified: 2021-06-07 07:52 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description jbotte 2012-03-04 01:50:16 UTC
There is no means of disabling word completion. Almost every single text entry in a cell flashes a distracting "suggestion" and then requires additional keystrokes to leave the word as typed. Often only a space is required, however if a previous entry had the word and a space plus another word, then it requires entering a character not in any of the previously remembered entries to break out of the word completion. Clicking in a different cell does not leave the text already entered into the cell, but automatically inserts the full word completion text, requiring the additional text to be deleted. This behaviour destroys any chance of touch typing efficiently and slows entry down by a factor of two or three times. In my case, LibreOffice Calc is rendendered unusable (through frustration) by this behaviour.
Comment 1 jbotte 2012-03-04 04:24:18 UTC Comment hidden (obsolete)
Comment 2 sasha.libreoffice 2012-05-30 04:10:54 UTC
Thanks for new idea
Use this option:
Tools->Cell content->Auto input
to disable auto-completion

AFAIK currently impossible to set auto completion to specific area on sheet, only for all Calc simultaneously. 
IMHO it would be useful to set auto-completion to that area on sheet where it makes sense, and disable for all other cells.

Please, describe ideas about improving auto-completion here
Comment 3 sasha.libreoffice 2012-09-04 08:14:37 UTC
Noel Grandin <noelgrandin@gmail.com> changed status to NEW
Comment 4 Timur 2019-10-16 14:02:05 UTC
*** Bug 126117 has been marked as a duplicate of this bug. ***
Comment 5 Timur 2019-10-16 14:07:00 UTC
Repro 6.4+. AutoInput is now in Tools->Auto input. 
But no way to edit it, as is possible in Writer via Word Completion that is a tab in AutoCorrect dialog.

Note: please see keyboard shortcuts in Help link.
Comment 6 Buovjaga 2021-06-04 06:38:58 UTC
This old report had two issues. The first one is fixed by the commits to bug 142214.

I am changing the summary to describe the second complaint: "When autocompletion suggests a string, the suggestion should be ignored when clicking outside the cell"

Involving design team to ask, if the behaviour should actually be changed or not.
Comment 7 Heiko Tietze 2021-06-07 07:49:32 UTC
We now get the autocompletion only if there is one exact match. 

For example, A1="Hello" and A2="Helli" will not suggest anything in A3 after typing "Hell". However, if B1="Hello World" you get the full text in B2 for "He".

There is no urgent need anymore since suggestions are much more tailored. Pressing any other character stops the autocompletion, escape or backspace doesn't. Meaning if B2 in the upper example should be just "Hello" one has to type the full word and press backspace. Not intuitive but I don't see how this can be done faster. 

The better solution for the whole feature is probably to show a small number of options in a dropdown and allow to pick one per cursor up/down. Would be inconvenient for users who enter distinct terms like "Blue" and "Yellow".

Putting all together it's a WFM. Feel free to reopen.
Comment 8 Heiko Tietze 2021-06-07 07:52:48 UTC
Forgot to discuss the point of "clicking outside the cell". This works as a finalization of the input, otherwise every number requires confirmation per enter. Also going another direction than downward eg. per cursor right to the next adjacent cell, would be impossible.