Dan, Thanks for your response.
I looked in the options in the spreadsheet program, and there is NO SUCH TAB; however, if I start an empty word processing document, tuh duh!, there it is (try it: it's not in the spreadsheet component, but it is indeed there in the word processing component)! I did indeed turn it off from within the option inside the word processing options tab; unfortunately, the problem remains in the spreadsheet program (it still tries to suggest an autocomplete that I don't want, and I'm required to press Delete everytime before I press Enter -- and this is all the more irritating since I need the single character response and NOT the autocomplete response 99%+ of the time!). I tried to get creative and change the activating key from within the autocomplete option in the word processing program, but it seems to have no effect on the spreadsheet (Enter still activates the autocomplete in the spreadsheet program even if it's turned off in the word processing option and even if I change the activating key to a space or right arrow). Alas! I even tried closing the program and restarting it after changing the options, and though the option in the word processing program continuously shows autocomplete is now off, it's still continuously ON in the spreadsheet and I can't change the activating key either! Too bad, since this would have solved my problem if it had worked. Suggestion: The autocomplete tab should also appear in the spreadsheet program, not just in the word processing component. Thanks for your suggestion, but it doesn't work in the spreadsheet component of Open Office, only within the word processing part! This is not only inconsistent but it's quite an irritating feature (it's certainly not a time saver for me!!!). Thanks for you most kind help though! Thanks again! Ron Keller > ----- Original Message ----- > From: "Dan Lewis" <[email protected]> > To: "Ron Keller" <[EMAIL PROTECTED]> > Subject: Re: [users] I am using Open Office 2.0: How do you terminate > autocomplete? > Date: Thu, 18 May 2006 13:59:40 -0500 > > > On Thursday May 18 2006 11:31 am, Ron Keller wrote: > > In Microsoft, it's called autocomplete: it's how something you typed > > before is suggested when you type only a portion of it, especially in a > > spreadsheet cell and it's completed for you as suggested if you press > > enter. In Microsoft, this horrible feature, this work creators, can be > > turned off for those who do not find it useful. > > > > I need to turn this off in Open Office. It frustrates me and creates > > problems when I get help I didn't seek! > > > > How do I turn off this damn feature? I need to enter a single letter > > code many times in a spreadsheet cell, but the multiple letter version > > which was only entered once in a single cell is suggested every time, > > and now I'm struck with needing to press delete on every entry to remove > > the autocomplete before I press Enter in the cell! This increases my > > workload, since the single letter is needed hundreds of times and I > > can't get rid of the autocomplete suggestion without pressing delete > > before Enter. Infuriating! > > > > I've turned off all the dictionaries, I've deleted all the autotype > > words, I've unchecked every possible box I can find (and this is a waste > > of my time). Nothing turns off this horrible feature (at least, if you > > con't want it!). > > > > Thanks, > > Ron Keller > > Tools > AutoCorrect > Word Completion (tab). Remove the check mark from > "Enable word completion". > > Dan > -- _______________________________________________ Search for businesses by name, location, or phone number. -Lycos Yellow Pages http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
