[Libreoffice-bugs] [Bug 119949] Filter broken by blank line

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #18 from b. <newbie-02 at gmx.de> ---
@yury reg. c#12:

looked into your ods file, as well as @dan in OP you have an
"__Anonymous_Sheet_DB__0" range defined in the sheet / the file, this range is
affecting the selection for autofilter definitions. The range is not! defined
'on purpose' by you, but likely from former attempts to apply an autofilter to
an area which is not defined as a database range. 

the definition for that range is: 

<table:database-range table:name="__Anonymous_Sheet_DB__0"
table:target-range-address="Sheet1.F1:Sheet1.F363"
table:display-filter-buttons="true">

covering cells down to F363, accordingly the rows below stay unfiltered. 

it may / might be that the 'error' will also show up without that range
definition (on a fresh sheet), it looks as if calc uses different 'intelligent
algorithms' to decide which range to filter (if you didn't manually do it),
depending if you selected / the focus is on a) a single cell, b) a range, c) a
full column / full columns, d) a full row / full rows???, e) full sheet, f)
multiple sheets???, and each of them split and differentially handeled if
anonymous and / or defined ranges are touched by your selection and / or by
automatic expansions of that ... very complex, 

from a short test i'd say in your case: calc says 'full column' is likely too
much, i'll take the anonymous range / the part of the column filled with data. 

observe different behaviour if you manually select F1:F382, 

@Timur: thanks for the hint with the help / documentation, it is - as often -
not very detailed and not really exact, e.g. it does not deal with the
different initial situations, and the sentence 'to assign different AutoFilters
to different sheets, you must first define a database range on each sheet' is
simply wrong, you can easily create auto filters on several sheets without
defining ranges there, calc will automa(t/g)ically do it for you, probably it
means 'to different ranges / areas of a sheet', there you really have to define
ranges first, otherwise the 'automatic' anonymous range is always moved away
from one range when a filter is defined somewhere else. 

All very complex, in the attempt to find a comfortable solution for simple
cases of application one has created a confusing mess for more complicated
cases ... 

my attempt to describe the behaviour in c16 is not! fully exact and fully
covering, just a hint how complex simple things might grow as each 'special use
case' or 'comfort wish' is added as an exception, doubling the complexity for
programmers and! users ...

-- 
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/20200605/cb1a4d82/attachment-0001.htm>