[Solved] Cannot turn off automatic cell entry

Discuss the spreadsheet application
Post Reply
i75Dave
Posts: 44
Joined: Thu Mar 12, 2015 9:41 pm

[Solved] Cannot turn off automatic cell entry

Post by i75Dave »

In Calc, I need to turn off the automatic completion of unwanted text.

For example:
Cell A1 - I enter a name - "Bennett" and move the cursor to cell A2
Cell A2 - I enter "B", "ennett" appears in white letters and black background. If I press Enter, I get "Bennett" although all I want is "B"

I know there must be a setting somewhere to turn off this automatic function, but cannot find it.
Please help.
Thanks,
Dave
Last edited by i75Dave on Mon Feb 12, 2018 5:51 pm, edited 1 time in total.
OpenOffice 4.1.1 on Win 7 64bit
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Cannot turn off automatic cell entry

Post by FJCC »

The menu item is Tools -> Cell Contents -> AutoInput
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Post Reply