Bug 124972 - Remove Duplicates in Libreoffice Calc
Summary: Remove Duplicates in Libreoffice Calc
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Data-Filter
  Show dependency treegraph
Reported: 2019-04-26 06:36 UTC by Ankur Vishwakarma
Modified: 2019-04-26 20:44 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:

some values input data for remove duplicates (8.31 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-04-26 06:37 UTC, Ankur Vishwakarma

Note You need to log in before you can comment on or make changes to this bug.
Description Ankur Vishwakarma 2019-04-26 06:36:00 UTC
I used Advanced filter option to remove duplicate values in Libre Calc.The output that can was incorrect.

Steps to Reproduce:
1. List down numbers
2. Use Advanced Filter to remove duplicate
3. Output contains duplicat values
4. Sample file attached

Actual Results:
Output Contained duplicate values for only one element.

Expected Results:
Output should be unique

Reproducible: Always

User Profile Reset: No

Additional Info:
Please find the Calc file
Comment 1 Ankur Vishwakarma 2019-04-26 06:37:24 UTC
Created attachment 151020 [details]
some values input data for remove duplicates
Comment 2 Oliver Brinzing 2019-04-26 15:43:14 UTC
Thank you for reporting the bug. 

> 2. Use Advanced Filter to remove duplicate

Please add a detailed description how the bug can be reproduced.

I have set the bug's status to 'NEEDINFO'. 
Please change it back to 'UNCONFIRMED' once the requested info is provided.
Comment 3 m.a.riosv 2019-04-26 20:44:59 UTC
There is not such bug, you are using the 1 as label for the column, so it is used as label in the generated range with no duplicate values.