https://bugs.documentfoundation.org/show_bug.cgi?id=150936
Bug ID: 150936
Summary: CALC MENU>DATA>More FILTER s> Advanced FILTER
>options>No duplicates Duplicates the first item in
the selection
Product: LibreOffice
Version: 7.3.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The Data Filter option for deduplicating a selected list will reproduce the
second iteration of the first item at the sequential location where it is
encountered and then complete the deduplication correctly
Steps to Reproduce:
With the enclosed sheet select the data in column E
MENU>DATA>More Filters>Advanced filter>Options check No Duplicates
Left mouse in the upper address box adjacent to "undefined"
Select the data in column E - Bug 1 it doesn't auto fill the selection
Check Copy results to
Left mouse in the lower address box adjacent to "undefined"
Focus H1 and "OK"
Observe that the second iteration of "One" is replicated at its unsorted
location and then the remaining entries are deduped.
The limitation of the three groups of seven is not significant - merely a short
list to demonstrate.
All other duplications have been removed when I intentionally replicated 119
full-length names ten times with only the first item duplicating once.
Actual Results:
The first item is duplicated when found in the list but only the 2nd iteration
of that item.
Expected Results:
deduplicated list
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 7.3.5.2 (x64) / LibreOffice Community
Build ID: 184fe81b8c8c30d8b5082578aee2fed2ea847c01
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
