Issue 75622 - Calc: better for autocomplet *not* to change upper/lower-case when leaving cell
Summary: Calc: better for autocomplet *not* to change upper/lower-case when leaving cell
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.1
Hardware: PC Windows XP
: P4 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: usability
Depends on:
Reported: 2007-03-22 02:31 UTC by zhongqiyao
Modified: 2017-05-20 11:13 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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.


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 seems to be 
related (and others from
Comment 2 frank 2007-03-30 12:02:03 UTC

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.

Comment 3 frank 2007-03-30 12:03:36 UTC
closed wontfix
Comment 4 zhongqiyao 2007-04-13 02:49:50 UTC

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.


Comment 5 frank 2007-04-16 11:24:01 UTC
Hi Niklas,

please have a look at this one.

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.


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 "".