Apache OpenOffice (AOO) Bugzilla – Issue 64209
Enhance consolidation to be able to be also case unsensitive
Last modified: 2013-08-07 15:12:27 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) Martin
Hi, please describe step by step what you're doing. If possible attach a document used for replication. Thanks Frank
Created attachment 35674 [details] example
no changes in milestone 169 martin
It's not obvious to me from the description and screenshot what you did and what you believe should happen. First please read http://www.openoffice.org/nonav/scdocs/issuewritinghelp.html and http://qa.openoffice.org/issue_handling/bug_writing_guidelines.html, and then add detail so that it's possible to attempt to replicate. Attaching the .ods example file itself would be helpful.
Hi, 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. Frank
closed invalid
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 Martin
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. Frank
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 Martin
reassign to fst for review.
Hi, 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. Frank
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 Martin
reassigned to requirements
just for the files: case-sensetive/case-insensetive is a feature so you should not set the target to the end of days please thanks Martin