On Thu, 2006-05-18 at 19:55 -0500, Ron Keller wrote:
> Thanks Dan, but, no, I had turned that check mark off long ago and
> autocomplete still works as I have indicated previously.
>
> I wish this could be fixed. Out of 100's of entries, only two varied
> in all the data in this particular column and autocomplete suggests
> these variations every time and it is simply a productivity killer
> since I don't know if I'll ever need again what autocomplete suggests
> everytime. It would be helpful if the activating key could be changed
> as in the word processing component, but changing it there does
> nothing within the spreadsheet and I need to press enter to go down a
> cell and that changes my input to the autocomplete suggestion which is
> exactly NOT what I need (then I have to go back to re-enter the data)!
> How VERY frustrating! All I can do is press Del before Enter every
> time and this is unnecessary and increases the number of keystrokes
> needed in 99%+ of my entries!
>
> I feel I may need to reload my copy of Excel to complete this
> pariticular job, since the OpenOffice spreadsheet is getting in my way
> instead of helping me do my work (I don't mean that as a slam of
> OpenOffice, since I am NOT a Microsoft fan; I mean this problem is
> destroying my being as productive as I need to be and my loyalties are
> to getting the job done!). In Excel, this damned feature can be
> turned off! I've wasted TOO much time at this point with this feature
> getting in my way causing multiple re-inputs and with my spending SO
> much time trying to figure out what to do to about it and searching
> and searching through screen after screen of FAQ's that didn't help
> and seeking email help about it that didn't help either.
>
> Autocomplete is supposed to be a productivity enhancer and not get in
> the users way, but it has been a destroyer of productivity in spite of
> what it may have been intended to do here!
>
> Again, thanks for trying to help, but you were UNABLE to suggest any
> way to make this problem stop, but I thank you SO much for trying! I
> really do!
>
> 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 18:05:18 -0500
> >
> >
> > You are right: there is no Autocomplete tab when using Calc.
> However,
> > there is an Options tab. The first choice in that tab is "Use
> replacement
> > table." If it is checked, remove the check mark.
> > [Tools > AutoCorrect > Options (tab)]
> >
> > Dan
> >
> > On Thursday May 18 2006 02:20 pm, Ron Keller wrote:
> > > 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
>
> >
>
Have you unchecked Tools > Cell Contents > Autoinput ? I ask because I
am uncertain whether or not anyone mentioned that this feature behaves
the same way as autocomplete in writer.
If it has been mentioned and you have disabled this feature and you
still have the problem, I suggest that you enter an Request for
Enhancement (RFE) into Issue
Tracker as this is the best way to have requests such as this evaluated.
If you haven't already registered, do the following:
1. To file an issue you must register with OOo by clicking the
My Pages tab and selecting the Register link
http://www.openoffice.org/servlets/Join
2. Fill in your information
3. Reply to the confirmation email that will be sent to the address
you provided.
4. Once you have confirmed, go to www.openoffice.org again
5. And click on the "My Pages" tab from which you can file and find
issues.
Thanks for bringing this to our attention. It is important that you file
any examples with the issue to ensure your need is understood.
--
PLEASE KEEP MESSAGES ON THE LIST.
OpenOffice.org Documentation Co-Lead
http://documentation.openoffice.org/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
