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

[bugzilla-daemon at bugs.documentfoundation.org]

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

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

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

--- Comment #16 from b. <newbie-02 at gmx.de> ---
Created attachment 161485
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161485&action=edit
a file with some defined ranges

hi, 

sorry for undigging an old bug ... 

the OP problem is quite easy, the overall problem very complex: 

you have to distinguish between - at least - three cases: 

1. you did not! define a range / database-range for the area you wish to filter
(<data - define range> please do not confuse with 'named ranges'): 

in this case calc seeks the area to be filtered by itself, 'the smallest
rectangle containing the actual focus bordered by 'all empty' cells in columns
left and right and rows on top and bottom', sheet borders may substitute empty
cells, and defines a "__Anonymous_Sheet_DB__0" name for it, i think that's what
happened to the OP, 

it's sometimes indicated by colouring the background, but hard to spot on large
sheets, 

already confused? single cells are 'expanded' in a different way than selected
ranges, single cells in all directions, ranges only downwards? 

2. you did! define a range / database-range for the area you wish to filter: 

then instead of the actual focus the range(s) it touches are taken, and!!!
expanded to a 'empty bordered rectangle' as described above, but that's not
given a name, 

3. you did define a range and! a preexisting "__Anonymous_Sheet_DB__0" range
exists: 

congratulations, the ranges interact, but you have no handle to steer the
anonymous one, just to see if it's defined you have to unzip the file, once
defined they are never deleted (?), but changed, 

4. you have defined several areas: pay attention to which area is the focus, 

5. you have defined several overlapping areas: the chaos grows, 

6. you have defined several areas and a previous anonymous area exists: it
becomes quite hard to get the results you want or to understand what happens, 

7. you save the file and recall it: the irregularities are getting more and
more 

8. you additionally apply 'sort', which follows a different scheme for
selecting the area to be processed: an uncontrollable situation, 

9. you use sort 'horizontal' (left to right, sort columns): forget anything and
start with a new sheet :-(

10. above is how it works mostly, but not in every case ... 

11. just try to activate autofilter for cell B5 on the attached sheet, 

12. apart from blaspheme: calc does a good job doing many things in the
background in a 'semi-intelligent' way so that the users have little work and
achieve good results quickly, 

this works for many simple tasks, but unfortunately in some cases it leads to
irritation and in more complex cases to immense difficulties that the
developers did not foresee, 

two sides of the same coin - either take work off the user, or give the user
control, or ... irritating 'middle ways' that combine the disadvantages of both
sides ...

-- 
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/20200601/8d70d2b5/attachment.htm>