Bug 124972 - Remove Duplicates in Libreoffice Calc
Summary: Remove Duplicates in Libreoffice Calc
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Data-Filter
  Show dependency tree / graph
 
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:

Attachments
some values input data for remove duplicates (8.31 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-04-26 06:37 UTC, Ankur Vishwakarma 		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 Ankur Vishwakarma 2019-04-26 06:36:00 UTC 
Description:
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.