Bug 46949 - Calc EDITING: Improve word completion / make AutoInput editable
Summary: Calc EDITING: Improve word completion / make AutoInput editable
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
URL: https://help.libreoffice.org/6.4/en-U...
: 126117 (view as bug list)
Depends on:
Blocks: AutoCorrect-Complete
  Show dependency treegraph
Reported: 2012-03-04 01:50 UTC by jbotte
Modified: 2019-10-16 17:26 UTC (History)
4 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.