Bug 46949 - Functionality request for Calc EDITING: Improve word completion
Summary: Functionality request for Calc EDITING: Improve word completion
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.0 release
Hardware: x86-64 (AMD64) Windows (All)
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: AutoCorrect-Complete
  Show dependency treegraph
Reported: 2012-03-04 01:50 UTC by jbotte
Modified: 2017-06-06 21:57 UTC (History)
2 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
I re-installed OpenOffice.org and realized LibreOffice behaved the same way. When I used the OpenOffice.org Help system, it quickly located the relevant function to disable the problematic behaviour. Specifically, the option was under Tools->Cell Contents->AutoInput. This worked in LibreOffice exactly the same way and did result in the word completion being disabled. As a note, I did search the online LibreOffice help using "word completion" and several other things I thought of and no hints were provided in how to turn this off in Calc.

So, I'm not sure if this is a user interface issue (because the same logical functionality is managed in different ways depending on whether Writer or Calc is used), or a documentation issue, but I do believe it remains a usability issue. As an example, there is a bug report from OpenSUSE that was the only reference I found to turning off word completion in Calc (all other references were for Writer), and nobody in that thread seems to have known about the "AutoInput" control:


As a final comment, the fact that it is an on/off flag in the actual menus seems a little bit of a UI overkill, implying that people are going to want to switch back and forth between word completion and not often (vs. putting it in the Tools->Options... menu). In general, I will either have it on for a document or off, but it's possible it should be a "quick access" feature if others use it often enough.
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