Apache OpenOffice (AOO) Bugzilla – Issue 75622
Calc: better for autocomplet *not* to change upper/lower-case when leaving cell
Last modified: 2017-05-20 11:13:10 UTC
Windows XP Home, Chinese (Traditional characters). OpenOffice Calc 2.0.1, Chinese (Traditional characters). 1. Open blank document. 2. In cell "A1" type "a". 3. In cell "A2" type "A" and then <Enter>. 4. Now cell "A2" becomes "a", allegedly because of autocomplete. 5. COMMENT: "Autocomplete" is a nice feature especially for entering repeats of long text. However, sometimes you want to have autocomplete enabled, but *you* want ignore the suggesting of autocomplete, to decide what to input in any cell. You may want to: (1) Enter "a" and "A" in different cells in the same column; (2) Change all cells of "a" to "A". If you type "A" and leave the cell and it becomes "a", you cannot achieve this action. Thanks. Qiyao
Confirming behavior with 2.2m11 on WinXP (in order to enter "a" one needs to turn off "Capitalize first letter of every sentence"). Issue http://www.openoffice.org/issues/show_bug.cgi?id=73036 seems to be related (and others from http://www.openoffice.org/servlets/Search?artifact=issuezilla+issue&query=% 2bautocomplete%20%2bcase&resultsPerPage=140&scope=domain).
Hi, if we change this, it might give problems if you have at least two characters. Therefore I set this one as wontfix. The desired combination of lower case a in A1 and uppercase in A2 can be achieved if you type 'A in A2 instead of a single A. Frank
closed wontfix
CLARIFICATION: This issue is not related to capitalising the first letter, or having at least two letters in a cell. 1. In cell A1, type "aAA". 2. In cell A2, type "aaa" end press <Enter>. It becomes "aAA". 3. Now there is no way to type "aaa" in cell A2. 4. It would be inconvenient of someone needs: (1) a mix of uppercases and lowercases in the same column; (2) change a column of "aaa" to a column of "AAA" cell-by-cell. 3. People may not know that the single quote (') is a special too to tell the program *not* to follow the upper/lower-casing of previous rows. So, I am reopening it for reconsideration. Thanks. Qiyao
Hi Niklas, please have a look at this one. Frank
If you think the normal way to enter literal text is ('), e.g. entering digits as text instead of as number, or not wanting to auto-complete, you may close this one again as invalid. Thanks. Qiyao
Current behaviour is non-intuitive for other reasons. Enter any string eg AbCdefg After entry, go back and try to edit the string to eg Abcdefg You can't, unless you know about using ' The majority of users won't. When you explicitly edit a string, it certainly should be accepted. On the other hand, Excel works intuitively and AFAIK always has.
Reset assigne to the default "issues@openoffice.apache.org".