[libreoffice-users] Re: Editing Auto-completion List in Calc

Am 24.02.2012 18:18, Rich Shepard wrote:
> In LO-3.5.0 Calc I am offered a completed word or phrase as I start typing
> in a cell. The list of potential completions varies with the column.
> However, there are some mis-spelled words in that list and I would like to
> edit them out.
>
> How do I access these lists? I find nothing in the Tools->Options menus.
> And Tools->Cell Contents only lets me turn on or off this completion
> feature.
>
> TIA,
>
> Rich

This has nothing to do with the Tools>AutoCorrect options.
Since 95% of today's spreadsheet users try to misuse spreadsheets as a 
database for text data, all constant text values within the same column 
are offered as a category list analogue to a combo box in a database form.

This can be turned off for the entire Calc component in 
Tools>CellContents>AutoInput

List validation provides a more controllable feature where you define a 
list of values which is supposed to be valid for a defined range of 
cells. Data>Validity... Type: "List" or "Cell Range".



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted