Issue 68780 - Case replacement from sort lists
Summary: Case replacement from sort lists
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.3
Hardware: PC Windows XP
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo
: 76574 (view as issue list)
Depends on:
Reported: 2006-08-18 18:40 UTC by tpetricek
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description tpetricek 2006-08-18 18:40:29 UTC
The case of typed word (contained in some sort list, but with different case) is
replaced by the one from the sort list (i.e. Sun, Mon, ...). When changed it is
always replaced after leaving editted cell (mon -> Mon, sun -> Sun etc.).
Comment 1 kpalagin 2006-09-14 08:03:14 UTC
Yep, happens to me as well (m180 2.0.4 RC1 on Vista).

Also, this behavior has nothing to do with "Start each sentence with a capital 
letter" as it changes from all upper case to all lower case when sort item is 
all lower case.
Comment 2 frank 2006-10-12 15:51:06 UTC

I'm sorry but I could not reproduce the problem. Please give us a step by step
description on how to repilcate it.

Comment 3 tpetricek 2006-10-13 21:35:31 UTC
Assuming that there is a sort list Sun, Mon, Tue, ... "sun" is changed to "Sun"
("mon" to "Mon", "tUE" to "Tue" etc.) after leaving the cell.
Comment 4 frank 2006-10-16 10:48:17 UTC

sorry for the missunderstanding, I should have explained in a better way. Yes,
the capitalization effect is seen by me too, but IMHO this is correct behaviour
and absolutly logical. A defined sortlist should work as it does now because you
have defined it that way. If you use Mon in a sort list, your intention is to
have the abbreviation for Monday. This is as far as I know to be written with
uppercase first letter.

But this is my opinion, let's hear how User Experience point of view is.

Matthias, please comment on this Issue and re-assign according to your decission.

Comment 5 tpetricek 2006-10-16 20:52:02 UTC

I think that sort lists should apply only when dragged through more cells and
only when the case matches (or this behavior should be customizable). There are
more reasons for it - sort lists are defined with application scope and if a
user want "MON" written this way he may have a good reason for it. Mon need not
mean only Monday (Motor Octane Number, Mixed Oxides of Nitrogen etc.). By now
the user has to delete the sort list which could be quity handy in other cases.

Case correction is a spellchecker job and can be turn on if needed.

Comment 6 kpalagin 2007-05-29 12:43:27 UTC
*** Issue 76574 has been marked as a duplicate of this issue. ***
Comment 7 matthias.mueller-prove 2009-09-06 10:20:24 UTC
I am no longer officially active on OOo. Please take over.
Comment 8 tab 2009-09-25 04:52:55 UTC
This problem seems to be related:
If you have 2 lists: A,B,C,... and a,b,c,...
Start with 'a' and drag it: you get 'B','C', ... instead of 'b','c',...
It seems the first (ie, created first) list gets priority: if the A,B,C,.. list
is deleted, then 'a' is followed (correctly) by 'b', 'c',...
Comment 9 kyoshida 2009-09-25 05:26:09 UTC
This behavior causes Issue 101046 too.  IMO this behavior is not desirable. 
Choice of capitalization should be left with the user.