Apache OpenOffice (AOO) Bugzilla – Issue 1342
Autofill overworked
Last modified: 2013-08-07 15:12:27 UTC
Check out the submitted file. Try to change the "tyPo" to "typo".
Created attachment 428 [details] Here's the file
Hi, I can reproduce this one. Beginnig 'Fix typo with a single quote helps. But I also think that autofill goes to far in this case. Rgds., Peter
Changing the case of the input to that of existing column entries is a useful feature that I don't want to remove. It is part of AutoInput, so if you turn that off, you can enter text in the "wrong" case. Unless you have a suggestion how to please everybody, I'll have to reject this.
I was just playing with Excel. They seem to handle both cases pretty well. Rules for "tyPo": 1. If you type "t", "ty", or "typ" in any case it will autofill to "tyPo". 2. If you type "typo", "Typo", or "TYpo"...etc. it will keep as you typed it. This makes sense since why would you use autofill if you're going to type it all in? 3. If you go back and edit "tyPo" to "tyPO" etc. it will keep you edits. Note: I'm not the only person that noticed this problem, see: http://www.openoffice.org/www-discuss/current/msg04705.html -Sep
The latest comments of Niklas and Sepehr are leading me to the conclusion that this is an feature wish. Regards, Peter
to Falko
This issue is re-assigned to Christian Jansen for further evaluation.
I have to agree to Sepehr and Peter, we should give users an easy solution to correct typos. This issue is also important for accessibility.
*** Issue 2014 has been marked as a duplicate of this issue. ***
Reopened
Changed state to accepted
This issue should: - title changed to 'Improve the way AutoInput deals with capitalization in Calc' - have 'platform' field set to 'All' - some milestone set?
Regardless of what the AutoInput settings are, if the user responds to an unwanted AutoInput by immediately retyping the cell contents the same way again, AutoInput should not modify the input the second time around. It seems that Excel disables all of its autocorrection if the user retypes the same thing twice, and many other text input UIs behave in a similar way (such as the iPhone and other mobile devices). It is extremely frustrating to users to not allow them to type the cell contents the way they want to, especially if they repeatedly enter the same information. It would seem to be an easy addition to add the capability to detect the user's "insistence" that they meant what they said. If the user insists, AutoInput should back down and not change case of what the user has typed. It seems like this would only very slightly complicate the code by needing to have a way to store the last input that AutoInput responded to and compare that against the current entry, but it seems like that should be fairly easy to implement and that should definitely be the default behavior.