[Solved] LibreOffice 5.3.6.1. Calc - Turn off autocomplete

Help with installation and general system troubleshooting questions concerning the office suite LibreOffice.

[Solved] LibreOffice 5.3.6.1. Calc - Turn off autocomplete

Postby gildionne » Sat Dec 09, 2017 11:41 am

In Calc, how do I turn off the autocomplete of cell entries when I type the first few letters? There are times when this feature is annoying and I wish to disable it in one particular sheet.

Solutions found in other posts refer to menu functions that do not exist in my version (LibreOffice 5.3.6.1)

In the menu is 'Tools'-'Autocorrect Options'
there are tabs for
'Replace' which has no entries
'Exceptions' which has no entries
'Options' with a series of tick boxes. Image 'SShot041.jpg' attached (note 'Use Replacement Table' is not ticked.)
and 'Localized Options' which only refers to punctuation marks and quotes.

I checked 'Tools' - 'Options' and can find nothing that seems to apply. The 'Paths' to 'AutoCorrect' leads to a 0 byte .dat file.

Any Ideas?
Attachments
SShot041.jpg
image of options dialog
SShot041.jpg (28.71 KiB) Viewed 404 times
Last edited by gildionne on Sat Dec 09, 2017 6:51 pm, edited 1 time in total.
LibreOffice 5.3.6.1 on Windows 10
gildionne
 
Posts: 2
Joined: Sat Dec 09, 2017 10:36 am

Re: LibreOffice 5.3.6.1. Calc - Turn off autocomplete

Postby Zizi64 » Sat Dec 09, 2017 1:01 pm

In the LO 5.3.x:
Uncheck - in the main menu - the "Tools - AutoInput" option.
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.3 and AOO4.1.4
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6215
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: LibreOffice 5.3.6.1. Calc - Turn off autocomplete

Postby John_Ha » Sat Dec 09, 2017 6:45 pm

AOO 4.1.5, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the up to date Writer guide for information. Click the Help button on a pop-up window for extensive help on that function.
John_Ha
Volunteer
 
Posts: 4857
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: LibreOffice 5.3.6.1. Calc - Turn off autocomplete

Postby gildionne » Sat Dec 09, 2017 6:50 pm

Thank You, Zizi64,

I finally found the correct tick box in 'Tools - Calculate - AutoInput'.

Previously tried 'Autocomplete' as search term in my LibreOffice Calc Help, with no success.
Searching online, and in the forums, the solutions presented all pointed to paths that were not on my machine.

You gave the feature name as 'AutoInput' and when I tried it in my search of the Help File, it brought up the article, but it still gave an incorrect path - 'Tools - Cell Contents - AutoInput'.
Help needs an update.

The search using 'Autocomplete' did not list 'Autoinput' at all.
It would help if the correct terminology was obvious, or if the index showed a greater range of search term variants.
Maybe in the future!
LibreOffice 5.3.6.1 on Windows 10
gildionne
 
Posts: 2
Joined: Sat Dec 09, 2017 10:36 am

Re: Solved - LibreOffice 5.3.6.1. Calc - Turn off autocomple

Postby Villeroy » Sat Dec 09, 2017 7:51 pm

Spell checking and auto correction replace certain character patterns after they have been typed. Spell checking is triggered after you finished typing a word. The other replacements may be triggered otherwise, for instance straight qutotes instantly replaced by typographic quotes.

Auto correct suggests text completions based on constant (not calculated) text values that have been entered in the same column before you finished typing the cell's text. This can be extremely useful for consistent list keeping where certain strings (names) occur repeatedly in the same column and must not mistyped. A very similar feature in Writer is called "Word Completion".
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24809
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to LibreOffice

Who is online

Users browsing this forum: No registered users and 2 guests