<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - CALC DATA EDITING Advanced Filter No Duplicates -- strange effects v.difficult to Summarise" href="https://bugs.documentfoundation.org/show_bug.cgi?id=141893#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - CALC DATA EDITING Advanced Filter No Duplicates -- strange effects v.difficult to Summarise" href="https://bugs.documentfoundation.org/show_bug.cgi?id=141893">bug 141893</a> from <a class="email" href="mailto:that.man.colin@gmail.com" title="Colin <that.man.colin@gmail.com>"> Colin</a> <pre>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</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>