[Libreoffice] [PATCH] fdo 42286 in calc solved ?

[Pierre-André Jacquod]

Hello,
thanks for the answer

>> My solution: suppress this call...
> is that, you've just removed a valid functionality.  I'm afraid I can't
> push your change, since the line you wish to remove is there for a
> reason.
which is ?? (not to argue, just to understand since I really tried to 
find a sense at this call before writing the mail. And did not found any 
and I have tested in different cases and did not noticed any side effect).

Ok for all what you say about auto-range I agree with it and I 
understood from the code that this is the intention. BUT where I do not 
see the rational :

this removed call i.e. the determination of the auto-range is called 
only (and each time) the drop-down button of the filter is clicked, just 
when building the drop-down list value. This path is NOT used on filter 
activation. This path is used each time you change the value by which 
the column is filtered, (in the drop down list) the auto-range is again 
calculated and changes.

In other words, it means, that each time you change the filtered value, 
the area which is under "filter control" changes: is this really the 
intended design ?

As user, I do not think that this is intuitive and awaited. I would 
await that the filter is working on the selected area and that changing 
the value active for filtering does not alter its working area.

(If I repeat, that's not because I think you are dumb, that's because I 
really do not know if I am able to express myself in an understandable 
way in English :-(

OK, that said, where did I missed the steps and fall one floor down ?

> Also, your use case is a weird one.  Normally Calc users don't want to
> filter out the bottom empty rows.
ergh, just a point of view.... :- ) And no, I see a lot of people doing 
this... and giving up. (btw I do not know the one who opened the ticket)

just a basic action (which is not weird):
cell A1: a, cell B1 b
cell A2 aa, cell B2 bb
select the whole sheet, activate standard filter
filter for value like aa in column a
.....

and to have funnier results just play changing the filtered value, not 
forgiving to go regularly through the filter value (ALL)
cell A1: a, cell B1 b
cell A2 aa, cell B2 bb
select column A and B, active auto-filter (with header, that's nice)
filter for value aa in column A
filter for non empty in column B
filter for ALL in B
filter for ALL in A
filter for value aa in column A


I hope not to waste (too much of) your time. Just I am very rational and 
like to understand, Especially when I have the impression that this is 
against the (or my ?) logic.

Thanks
Best regards
Pierre-André