Showing posts with label autocomplete. Show all posts
Showing posts with label autocomplete. Show all posts

Monday, June 4, 2012

Libre Office Writer & Calc: Disabling Autoinput and Autocomplete

Some time back I wrote a quick how-to on disabling autoinput and autocomplete in Open Office. Libre Office 3 has the same problem: defaults that make the tools harder to use. The instructions there are still essentially correct but the wording on the menus has changed slightly, and I'm working with a fresh install, so I decided this is a good time for an update.

In Libre Office Writer click Tools|Autocorrect Options. Then select the Word Completion tab and uncheck Enable Word Completion. Also uncheck Collect Words, because there is no need to collect words for a feature that will never be used.

In Calc, click Tools and then Cell Contents, and uncheck AutoInput.

[ Note added 10 September 2012: above I should have written OpenOffice and LibreOffice as one word each, not two. Oh well. ]

Wednesday, July 9, 2008

Disabling OpenOffice's Stupid Autocomplete

[ An updated version of this information appears here. ]

With autocomplete, OpenOffice has managed to make a completely useless, very annoying behavior default. They've also done a good job of hiding the menu options to disable the "feature," and have hidden it in different places in different tools. This is a case where consistency would reduce the impact of a stupid default. Anyhow, as others have mentioned, whenever I'm using a freshly-installed OpenOffice (e.g., after installing a hopefully less-buggy version of Ubuntu), OpenOffice reminds me how much I dislike this "feature." And I spend too much time hunting down how to kill it.

First, in OO Writer it's not really that well hidden. Copied from http://nowacki.org/blog/2004/05/disable_autocomplete_in_openoffice.html: * Tools -> AutoCorrect/AutoFormat… * Word Completion tab * Uncheck “Enable word completion” 

Unfortunately, this doesn't disable the "feature" in OO Calc, and the OO Calc option is very well hidden. Today I really was having trouble figuring it out--it is, of course, not in what passes for help in OO--which led me to nowacki.org via Google. From their blog entry: Tools -> Cell Contents -> AutoInput

Of course, this is the root of the problem: we're supposed to magically know that in OO Calc they call it autoinput rather than autocomplete. What, if anything, are the OO folks thinking? This has been a usability problem and unnecessary time sink for a lot of people for a long time now. When will they disable it by default, or at least make it possible to find the option in OO Calc? Or maybe talk about disabling it in OO Help?