Issue 64209 - Enhance consolidation to be able to be also case unsensitive
Summary: Enhance consolidation to be able to be also case unsensitive
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.2
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo, oooqa
Depends on:
Reported: 2006-04-10 14:10 UTC by mhatheoo
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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

example (113.10 KB, image/jpeg)
2006-04-13 01:14 UTC, mhatheoo
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description mhatheoo 2006-04-10 14:10:31 UTC
see it in the summary

The consolidation is not functioning proper:
it separates lines by their label, if they are not in same case(small/capital),
even if the CALC-Options are set so(case-sensitiv is OFF)

Comment 1 frank 2006-04-10 14:40:15 UTC

please describe step by step what you're doing. If possible attach a document
used for replication.


Comment 2 mhatheoo 2006-04-13 01:14:51 UTC
Created attachment 35674 [details]
Comment 3 mhatheoo 2006-05-21 19:41:14 UTC
no changes in milestone 169

Comment 4 dridgway 2006-05-24 06:42:01 UTC
It's not obvious to me from the description and screenshot what you did and what
you believe should happen. First please read and, and then
add detail so that it's possible to attempt to replicate. Attaching the .ods
example file itself would be helpful.
Comment 5 frank 2006-05-26 10:21:23 UTC

as Case Sensitive is found under tools-options-OOoCalc-Calculate only, the
following help section applys :

Case sensitive
Specifies whether to distinguish between upper and lower case in texts when
comparing cell contents.
Example: Type the text 'Test' in cell A1; and the text 'test' in B1. Then type
the formula "=A1=B1" in cell C1. If the Case sensitive box is marked, FALSE will
appear in the cell; otherwise, TRUE will appear in the cell.

This is for text's only and not for a functionality like consolidation.
Therefore I've to close this Issue as invalid.

Comment 6 frank 2006-05-26 10:21:38 UTC
closed invalid
Comment 7 mhatheoo 2006-07-12 16:59:22 UTC
well Frank,

You can not close an issue, if you have no clue, what the problem is.
Pls be so kind to reread in the helpfiles, what the function of labels in a
calc-sheet are.

Although the sorting in calc-sheets is proper functioning, the second step need
to have the ability to consolidate defined areas without the prior conversion to
"all in capitals".

This is a mistake in concept. 
Thats why the issue is reopend

Comment 8 frank 2006-07-13 10:23:37 UTC
Hi Martin,

I can close this Issue as invalid, because the setting you want to use isn't
valid for the purpose you have in mind. Therefore and without any answer on our
questions the decission to close it as invalid is correct.

Nevertheless, I checked consolidation with Excel and found out that Excel
everytime ignores the case. This is IMHO a defect, as 'abc' is something verry
different than 'ABC'. So Calc is working in the correct way.

So I take this Issue as enhancement request for enhancing the UI to be able to
consolidate also case sensitive.

Changed Summary accordingly.

Comment 9 mhatheoo 2008-01-24 21:42:28 UTC
hallo Frank

I just reread this issue - and found it is still an issue

If you - personally - prefer to destinguish between upper and lower-case for
labels, it is okay, even if it is not common for dealing with data.
(Note: in that case aa AA aA and Aa are all different)

However, I really need it  in the way as stated within the Help-File,
and the settings within options have no function,
so I set it to defect and set the milestone to 2.4

Comment 10 Martin Hollmichel 2008-01-28 11:46:51 UTC
reassign to fst for review.
Comment 11 frank 2008-02-11 13:14:35 UTC

it seems to me it's a bad idea to re-assign this one again to me as my opinion
is stated clearly earlier. So I re-assign this Issue to OC for clarification.

Comment 12 mhatheoo 2008-04-02 13:36:27 UTC
As expected: this issue is not solved in 2.4.0

Just as a hint to Frank(fst), where the problem lies:

there is no option to force cell-entry (that will be a
label lateron) to be treated - or change to - capital letters.
This is a missing feature anyway.
However, if you can not control data-entry - the format of data-entry - you can
not set sorting-options to be case-sensitive - that is not a logical concept.

Hope you set this on the line to reach version 3.0


Comment 13 oc 2008-09-23 11:07:47 UTC
reassigned to requirements
Comment 14 mhatheoo 2008-10-06 15:55:40 UTC
just for the files:
case-sensetive/case-insensetive is a feature
so you should not set the target to the end of days please