[Libreoffice-bugs] [Bug 141893] New: 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

            Bug ID: 141893
           Summary: CALC DATA EDITING Advanced Filter No Duplicates --
                    strange effects v.difficult to Summarise
           Product: LibreOffice
           Version: 7.0.5.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: that.man.colin at gmail.com

Description:
Firstly, I'm not even certain how much of the effect is planned and how much is
anomalous. I was experimenting with Advanced Filters.
It seems to be imperative that the entire data array is pre-selected prior to
then selecting it within the advanced filters.
It also requires the "AutoFiltered" label to be included within the selection
or the process fails to complete.
The eventual deduplicated list is impacted by SOME changes made to the source
and, following deletion, will reappear after further manipulation of the
source.
The effect is persistent, surviving file saves & reloads until the deduplicated
column is deleted and the file saved.
Deselecting items in the source autofilter impacts the deduplication list but
NOT the source list. Deletions of all instances of a data event in the data in
the source list has no impact on the deduplicated list.
Amending the data in the source list has no impact on the deduplicated list but
does manifest in the source autofilter contents.
I don't know how many - or if any - of the "effects" are an integral part of
the procedure. I feel a bit like a magician pulling rabbits from a hat -
somebody else's hat!
Perhaps I shouldn't have placed the de-duplicated list adjacent to the filter
list. I'm aware that placing two discrete autofilters alongside each other is
not possible as the second event simply disables the first.
Perhaps I shouldn't even have placed it on the same sheet.
If I selected and moved the deduplicated list to a second sheet the link was
broken but further manipulation of the source list simply made it reappear in
its original location.
I did not check to see if I could create the list on an alternate sheet so I am
unable to comment on the potential impact.
I did not experiment with cutting and pasting or moving within the same sheet.

Steps to Reproduce:
1 Create a list of 8 unique events at B:4 and then replicate them 5 times.
2 At B:3, create a label "Events" and an AutoFilter from the toolbar using the
"Events" label
3 Mouse select the label and all events
4 Data>More Filters>Advanced Filter

Observation - the process fails if the selected column of data - step 3 -
doesn't include the label "Events" or has NOT previously been selected/focused
prior to 4&5

5 From within the little Advanced filter pane AGAIN select the entire data
column - NOT the column in its entirety
6 Expand >options
7 Select >No duplicates
8 Select >Copy results to
9 Mouse select E:3 which is conveniently adjacent to the Filtered List
commencing B3
As demonstrated, there is a filtered no de-duplicated list with a nice label
but inactive autofilter symbol  Should the symbol even be reproduced?
10 sort "Events" Descending --- NO observable impact upon Array E3:E11
11 Deselect Event 1 & Event 2 from the "Events" list --- Observe the
de-duplicated list is amended
12 "PLAY" with any of the sort, deselect, reselect functions in the "Events"
filter list --- Observe that selection and deselection impact Array E3:E11
13 Select & Delete column E In its entirety --- Observe that array E3:E11 no
longer exists
14 Deselect anything in "Events" filter list and --- Wow, Where did that come
from?
15 Repeat 12 ONLY
16 Save and Exit or Exit and Save
17 Reload the file
18 Repeat 10, 11, 12 & 13 - Observe that array E3:E11 no longer exists
19 Save & Exit or Exit and Save 
20 Reload the file Wow, There it was GONE!

Don't panic, you can always re-download the source file to recreate the demo

Actual Results:
The deduplicated list remains actively attached to the source, surviving
deletions and file saves, reappearing following further manipulation of the
source. It is also surprising that the source data and AutoFilter label must be
actively focused prior to the event and actively selected again during the
event.

Expected Results:
I anticipated the list being set in stone and the requirement for selection
being a one-time operation


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Module: SpreadsheetDocument

Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a
CPU threads: 4; OS: Windows 10.0 Build 19042; 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210425/da42430b/attachment-0001.htm>