Bug 36875 - Unique values functionality not working normally
Summary: Unique values functionality not working normally
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.0 RC1
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Kohei Yoshida
URL:
Whiteboard: target:3.6.0
Keywords:
Depends on:
Blocks:
 
Reported: 2011-05-05 09:10 UTC by Marin
Modified: 2012-04-27 03:58 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
calc file (205.04 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-05-05 09:12 UTC, Marin 		Details
two columns with numbers (850.00 KB, application/vnd.ms-excel)
2011-05-06 23:40 UTC, Marin 		Details
screenshots (477.79 KB, application/pdf)
2012-04-27 03:58 UTC, Rainer Bielefeld Retired 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Marin 2011-05-05 09:10:52 UTC 
If you create i.e. a list of 30000 10digit numbers (with
duplications) in calc and try to apply the unique value functionality (data->filter), then the return list of values is wrong. 
Values that are unique are hiding at the end of the column with the duplicates ! 

(test it with the attachment)
Comment 1 Marin 2011-05-05 09:12:11 UTC 
Created attachment 46366 [details]
calc file
Comment 2 Noel Power 2011-05-06 08:49:29 UTC 
can you please give more details ( step by step ) of what you do to set up the filter. Also if you show what values are in error it might help to see the problem you describe ( at least for me )
Comment 3 Marin 2011-05-06 23:40:20 UTC 
Created attachment 46412 [details]
two columns with numbers
Comment 4 Marin 2011-05-06 23:50:37 UTC 
(In reply to comment #2)
> can you please give more details ( step by step ) of what you do to set up the
> filter. Also if you show what values are in error it might help to see the
> problem you describe ( at least for me )

I did some more tests (you can use the attached files) and as I can see the problem is more generic. 
Just create a column with numbers ie from 1 to 20000 - something more than 16384 rows. Select the column and go at menu Data->Filter->Typical, choose this column not to be null, next press the button more options->no duplicates. The return rows are always 16385.
Comment 5 Noel Power 2011-05-09 04:09:20 UTC 
ok, clearer now, seems there is some bug imposing a limit on the rows in the result. 

Kohei, please can you have a look
Comment 6 Marin 2011-05-19 02:35:07 UTC 
(In reply to comment #5)
> ok, clearer now, seems there is some bug imposing a limit on the rows in the
> result. 
> 
> Kohei, please can you have a look

Is there a how to or fix ?
Comment 7 Philippe Geoffroy 2011-10-25 07:49:57 UTC 
Bug still present in version 3.4.3 (release).

I have several data files with more than 40,000 lines of where I need to filter out duplicates, and the result always returns 16385 rows max.
Comment 8 Rainer Bielefeld Retired 2012-04-27 03:56:05 UTC 
Still [Reproducible] with "LibreOffice 3.5.3.2 (RC2) German UI/Locale [Build-ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80] on German WIN7 Home Premium (64bit) 

Now works fine with parallel  installation of  Master "LOdev 3.6.0alpha0+  – WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 8a78020]" (tinderbox: Win-x86@6-fast pull time 2012-04-18 23:51:20).

I doubt that we can get the unknown fix backported to 3.5, so I close this one.
Comment 9 Rainer Bielefeld Retired 2012-04-27 03:58:31 UTC 
Created attachment 60658 [details]
screenshots

comparison shows that problem vanished for 3.6