Issue 90253 - Case insensitivity in duplication checking for Standard Filter is broken
Summary: Case insensitivity in duplication checking for Standard Filter is broken
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.4.0
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-06-02 13:36 UTC by estan
Modified: 2013-01-29 21:41 UTC (History)
1 user (show)

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

Example ODS test case (7.02 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-06-02 14:26 UTC, estan
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description estan 2008-06-02 13:36:26 UTC
Steps to reproduce:

* Create a new spreadsheet.
* Enter "abc" into A1 and "ABC" into A2.
* Press the column label for column A to select the column.
* Go to "Data->Filter->Standard Filter" in the menus.
* Click "More" to open the extra options.
* Uncheck the "Range contains column labels" check box.
* Check the "No duplication" check box.
* Change the "Value" of the first filter criteria to "- not empty -".
* Press OK.

Expected result:

The duplication checking should work case-insensitively since the "Case
sensitive" was not checked, and hence "abc" and "ABC" should be treated as a
duplicate and only "abc" should be kept.

Actual result:

Both "abc" and "ABC" is kept, they are both treated as unique values.

Additional info:

I found this in 2.4.0 (Kubuntu package), but Richlv on IRC ( @ could reproduce this on DEV300_m14 as well.

Could it be that the duplication checking was added after the case insensitivity
checking, and so the case insensitivity checking was left to only pertain to the
three "normal" filter criterias at the top of the Standard Filter dialog?
Comment 1 estan 2008-06-02 14:26:58 UTC
Created attachment 54171 [details]
Example ODS test case
Comment 2 amy2008 2008-07-14 07:27:23 UTC
Fedora8, can reproduce it in Dev300_m23
Comment 3 jm38706415 2008-08-07 07:09:57 UTC
Validating on Dev_DEV300_m28_winXP en. 
Comment 4 redflagzhulihua 2008-08-22 04:49:59 UTC
reproduce not only in linux.