Issue 60144 - cannot enter case-varying 2 letter "words" in column
Summary: cannot enter case-varying 2 letter "words" in column
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
: 61591 (view as issue list)
Depends on:
Reported: 2006-01-06 19:26 UTC by lars
Modified: 2017-05-20 11:13 UTC (History)
3 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 lars 2006-01-06 19:26:36 UTC

I want to enter AA, Aa, aa in column A. However, the content in A2++ is always 
corrected to the case-formatting of A1. So if I have AA in cell A1 and enter aa 
or Aa in cell A2, this gets corrected to AA. I have AutoCorrect Options 
Capitallize first letter of every word and Correct two initial capitals 
disabled. Enabling them doesn't change anything with the problem however.
Comment 1 parmruss 2006-01-07 20:51:44 UTC
Could not confirm on OOo 2.01 winxp sp2.

I can disable tools-autocorrect-captilize first letters of every sentence, then
enter in column A the three rows you described.

Note that in each subsequent row, after you enter the first letter you get a
highlighted choice for the next letter.  On my end I simply type over the
suggested letter.
Comment 2 hwoarang 2006-01-11 22:27:28 UTC
Can reproduce with OOo 2.0.1 WinXP SP2.

Typing 'Test' in A1 there's no way to get 'TEST' in any A column cell...

Unchecking all AutoCorrect options do not help...

I think this is related with issue 2838 and/or issue 3349 but I'm not sure.

Comment 3 kelkdavid 2006-01-17 17:43:37 UTC
This occurs in OO Calc 2.0.1 on Win XP SP 1

Further characterizations of the bug:

1) Start a Calc document
2) Go to Tools->Options->Language Settings->Writing Aids
3) Uncheck all the boxes (Except IgnoreAllList, which I
   could not uncheck)
4) Go to Tools->Autocorrect
5) Unselect all the checkboxes on the second through
   fourth tabs

6) type 'test' in all small letters in A1.  Hit enter
6a) Observe 'test' is changed to 'Test' (capital T)
7) type 'TEST' in all caps in A2.  Hit enter
7a) Observe 'TEST' is changed to 'Test'

As stated earlier, autoformatting is still occuring.

I'm not sure if this is related or not, but it is 

8) Type 'test' in a5 (say)
9) Select cell a5 and select Format->Change Case->
   Upper Case
9a) Observe 'test' changes to 'TEST'
10) Select cell a6 and type 'test' in it
10a) Observe 'test' changes to 'TEST'
11) Select cell a6 and select Format->Change Case->
   Lower Case
11a) Observe 'TEST' changes to 'test'
12) Select cell a7 (say) and type 'test' in it
12a) Observe 'test' changes to 'TEST'

I would expect that after step 11 - where we switch from
upper case to lower case - that 'test' in step 12 would
stay in lower case.


13) If you close and restart Calc after completing
the steps above, all text entered (TEST, Test, etc..)
is converted to lower case.  Presumably this occurs
because of the case change command in step 12.
Comment 4 hwoarang 2006-01-17 19:20:06 UTC
Shouldn't this get P2 ?
Comment 5 frank 2006-01-18 08:34:47 UTC

this is not a defect or a matter of Autocorrection, but a matter of Autoinput
which can be disabled under Tools-Cell Content - Autoinput.

And as this isn't a bug, this can't get Prio 2.

Comment 6 frank 2006-01-18 08:35:07 UTC
closed invalid
Comment 7 hwoarang 2006-01-19 23:14:28 UTC
Hwoarang -> FST:
Thank you for the explanation, but I think that still a bug here...

Consider this:

With Autoinput on:
Type test in A1
Type TEST in A2

As I typed the full word (no a part of it as T, TE or TES) I'm not using the
Autoinput's suggestion, so I'm not expecting to get test.
The expected behavior to Autoinput is to get the word completed not changed.
Got what I meant ?

What do you think ?

Thank you.

Comment 8 lars 2006-02-02 14:15:22 UTC
see hwoarangs last comment
Comment 9 frank 2006-02-03 13:49:55 UTC
Hi Niklas,

please have a look at this one and give us your comment about it.

Comment 10 hwoarang 2006-02-10 23:42:44 UTC
*** Issue 61591 has been marked as a duplicate of this issue. ***
Comment 11 clement_pillias 2009-02-11 18:46:56 UTC
Issue 1342 is similar to this one and has been accepted as enhancement.
Comment 12 Marcus 2017-05-20 11:13:27 UTC
Reset assigne to the default "".