Issue 75622

Summary: Calc: better for autocomplet *not* to change upper/lower-case when leaving cell
Product: Calc Reporter: zhongqiyao <lotus>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues, khirano, kpalagin, mike.hall
Version: OOo 2.0.1Keywords: usability
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description zhongqiyao 2007-03-22 02:31:57 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
Comment 1 kpalagin 2007-03-25 14:35:04 UTC 
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).
Comment 2 frank 2007-03-30 12:02:03 UTC 
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
Comment 3 frank 2007-03-30 12:03:36 UTC 
closed wontfix
Comment 4 zhongqiyao 2007-04-13 02:49:50 UTC 
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
Comment 5 frank 2007-04-16 11:24:01 UTC 
Hi Niklas,

please have a look at this one.

Frank
Comment 6 zhongqiyao 2007-09-07 11:33:36 UTC 
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
Comment 7 mike_hall 2009-10-02 23:27:07 UTC 
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.
Comment 8 Marcus 2017-05-20 11:13:10 UTC 
Reset assigne to the default "issues@openoffice.apache.org".