[Libreoffice-bugs] [Bug 141893] CALC DATA EDITING Advanced Filter No Duplicates -- strange effects v.difficult to Summarise

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=141893

--- Comment #3 from Colin <that.man.colin at gmail.com> ---
To enhance the report I have added another example file containing 2 sheets
which I perceive is a more definitive example of the issue. The second sheet
contained therein is just a duplicate for "control" data.

To recreate the issue:-

In Sheet 1 "Filter error"

Marquee Select B2:B88
Activate B2 "filter" chevron
Select "standard filter"
Expunge "field name" - top selection to leave "none"
Activate "options"
Select "No-duplicates" AND ensure "Range contains column labels" is enabled
select "OK"

Observe the list now contains 23 deduplicated elements

Select any cell to deactivate focused cells
Activate "filter chevron"
Sort Ascending

Observe the entries no longer reflect the deduplicated list and contain
duplicates - sorted ascending.

"undoing" last actions to reverse everything re-establishes the original values

If the "field name" is not expunged then the results are an empty array list
which in itself seems quite an anomalous response

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210703/f13c2c0f/attachment.htm>