[Libreoffice-bugs] [Bug 35923] Calc - Standard Filter produces wrong display (Selection range is automatically expanded)

[bugzilla-daemon at bugs.documentfoundation.org]

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

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |newbie-02 at gmx.de

--- Comment #23 from b. <newbie-02 at gmx.de> ---
for the Bug Hunting Session 7.0.0.0.a1+: 

bug still as described by the OP, 

It's an ambiguous decision: a normal - inexperienced - user would of course
like automatic range selection and newly added data to be filtered or sorted as
well, but the same - inexperienced - user would not like his column-totals or
footnotes to be filtered or sorted. 

It is difficult for a more algorithmic than intelligent program to meet both
requirements. 

I think there have been long discussions and lonely decisions about this ... 

Are my observations correct: 

sort considers in the following order: 

1. the current selection in the sheet, if it is larger than one cell, 

2. an "__Anonymous_Sheet_DB__0" - automatic database area - if it is left over
from the previous creation of a filter and the focus is in this area, if this
area is divided by empty columns or rows only contiguous areas are taken? (the
'anonymous' areas are never deleted but only redefined once they are on a
sheet?) 

3. a defined 'data range' if the focus is in it, 

3a. overlapping database areas are evaluated a little bit strange, with focus
in the first (older or upper or 'left') area this is selected, with focus in
the overlapping area also, with focus in the second (newer, deeper or
'righter') database area both areas are combined?

4. otherwise sort itself defines a rectangular area bordered by empty cells, 

and if this includes only the one selected cell ... 

5. just sorts this one cell, 

6. sort has an option to 'sort by row' - horizontally - and then re-arranges
columns instead of rows, 

whereas filters - all filters? -  

1. simply always according to sort-4. define a filter range by themself and
ignore all specifications from the user? 

2. have no 'horizontal' option and therefore should neither evaluate tags
'table:orientation="column"' from the files nor handle parameters 'bByRow' or
'bByColumn' in the evaluations for the filtering (UI and basic / macros) or let
them influence the field assignments? 

- puhhh that was long, is that described somewhere as 'target behaviour'? - 

my approach would be: 

- sort is much more user friendly than the filters, 

- sort should not consider the automatic data area, which is not intuitive or
manageable for the user, 

and filter should either: 

- behave as sort, and respect the user's specifications, 

or: 

- have a query in the filter definition: 'which area do you want to edit?
"defined" B3:F165, or "automatic" B2:H182'

but there may be more ideas, and they may become difficult once excel
compatibility is taken into account?

-- 
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/20200511/9c9eaec0/attachment-0001.htm>