OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How to turn off autocorrect for similar item, same column?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
hop-frog
Power User
Power User


Joined: 22 Jul 2004
Posts: 74

PostPosted: Wed Aug 16, 2006 4:58 pm    Post subject: How to turn off autocorrect for similar item, same column? Reply with quote

  1. Open new spreadsheet
  2. Type "apple" in A1.
  3. Next type "Apple" with uppercase "A" in A2 and hit ENTER.

"Apple" automatically becomes "apple" and hitting CRTL+Z immediately doensn't fix it back to "Apple".
I went into the Autocorrect configuration dialog and the help on this feature, and can't find any item that describes this behavior so I can shut it off.
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Wed Aug 16, 2006 5:31 pm    Post subject: Reply with quote

Try Tools >Cell Contents >AutoInput. (De-select the horrible thing.)
_________________
search forum by month
Back to top
View user's profile Send private message
hop-frog
Power User
Power User


Joined: 22 Jul 2004
Posts: 74

PostPosted: Fri Aug 18, 2006 9:02 am    Post subject: Reply with quote

This must be a bug. Turning off AutoInput did solve my problem. However, it also got rid of a feature that I do like. The two features seem to be very tightly related. That is, when I type in an entry that is similar to another column, it shows me a match by highlighting it, but it only uses that suggestion if I hit enter. Otherwise it lets me type in what I want.

(I'm not quite sure if I managed to adequately describe this autocomplete thing)

Anyway, thanks for the help.
Back to top
View user's profile Send private message
geoff80fg
OOo Advocate
OOo Advocate


Joined: 26 Jul 2006
Posts: 420
Location: UK

PostPosted: Fri Aug 18, 2006 10:50 am    Post subject: Reply with quote

These AutoWhatever features cause no end of heartache. I've found people who have not come across the numbered bullet feature trying to use small Roman numerals (i, ii, iii, etc.) to number paragraphs only to be thwarted when the first one is capitalised. In desperation they turned to (a), (b), etc. and then (c) turned into the copyright sign. Fury was unbounded and the explanation didn't seem to help them.

I agree with noranthon and turn the damn things off. The time saved by having them is surely undone by the frustration of trying to sort out the messes they cause.

Geoff
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group