Bug 45990

Summary: Unique values functionality not working normally
Product: LibreOffice Reporter: Marin <marinblu0000>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: major CC: markus.mohrhard
Priority: medium    
Version: 3.4.5 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Calc file with 10digit numbers

Description Marin 2012-02-13 05:12:12 UTC
Created attachment 56965 [details]
Calc file with 10digit numbers

If you create i.e. a list of 30000 10digit numbers (with
duplications) and try to apply the unique value function (from data>typical filter->more options->no duplicates), then the returned list of values has only & always 16384 rows. 
Values that are unique are hiding at the end of the column with the duplicates !

(check the attached calc file ...)
Comment 1 Markus Mohrhard 2012-02-15 14:50:52 UTC
Your file does not seem to contain duplicates. I tried and the algorithm seems to recognize duplicates but does not find some if I do not modify the data in your sheet.

Maybe I'm wrong but then t would be nice if you could name two cells in the sheet that have the same value.
Comment 2 Markus Mohrhard 2012-03-18 09:59:21 UTC
Please reopen and and some more details if you think that there is really a bug.