Bug 73712 - FILTER: Removing duplicate string
Summary: FILTER: Removing duplicate string
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-01-16 20:21 UTC by leon244@comcast.net
Modified: 2018-11-06 11:55 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description leon244@comcast.net 2014-01-16 20:21:09 UTC
I have a column of terms that I pasted from two text files. I have
tried to remove duplicate terms from the list but have the continued
problem of having some of the duplicated terms not removed. One
example is the term "Adrenal hyperplasia" and the other duplicate is
"adrenal hyperplasia".  I have used the standard filter with the
filter being "Col A = Not Empty" and have checked the buttons for
"remove duplicates". I have left unchecked the button for "Case
sensitive" assuming that that would allow for 'Adrenal' to
be the same as 'adrenal'.

Removal of duplicates is not case insensitive whether or not the "Case Sensitive" checkbox is checked or empty.

This happens every time. Using v 4.1.4.2 on Mac
Comment 1 Julien Nabet 2014-01-16 21:39:10 UTC
On pc Debian x86-64 with master sources updated today, I can reproduce this.
Comment 2 leon244@comcast.net 2014-01-17 00:00:47 UTC
I also reproduced it on my Mageia machine x86_64 running v 4.1.3
Comment 3 Joel Madero 2015-05-02 15:43:19 UTC Comment hidden (obsolete)
Comment 4 Julien Nabet 2016-06-26 12:45:33 UTC
On pc Debian x86-64 with master sources updated yesterday, I could still reproduce this.
With gdb, I noticed we enter there:
http://opengrok.libreoffice.org/xref/core/sc/source/core/data/table3.cxx#2919

But I don't know where we should take into account "bCaseSens".
Comment 5 QA Administrators 2017-09-01 11:19:00 UTC Comment hidden (obsolete)
Comment 6 eisa01 2017-11-05 20:37:49 UTC
I can reproduce this, this is also inherited. As per comments this was also reproduced on Linux, so setting OS to all

Version: 6.0.0.0.alpha1+
Build ID: 7e03c4eed72452fdfb87341214a21956c08ba969
CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2017-10-25_23:45:02
Locale: en-US (en_US.UTF-8); Calc: group
Comment 7 QA Administrators 2018-11-06 03:56:22 UTC Comment hidden (obsolete)
Comment 8 Thomas Lendo 2018-11-06 08:45:42 UTC
I set this issues as a duplicate of a newer bug, but there is more discussion and a comment from a developer.

*** This bug has been marked as a duplicate of bug 85976 ***
Comment 9 leon244@comcast.net 2018-11-06 11:55:29 UTC
Version: 6.1.2.1
Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: en-US (en_US.UTF-8); Calc: group threaded