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+h...@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