[Libreoffice-ux-advise] [Bug 140760] (PIVOTTABLE) selection of invalid constraint values possible and probably this irreversibly results in an empty pivot table

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #11 from Eike <estolle at web.de> ---
Just to be more precise on my expectations on Autofilter using bug 117276 as
example: The order of filtering is 

1.column B
2.column I

Let's do that step by step. First deselecting some cars in column B cancels out
some possible selections in all the other columns. Deselecting I=8000 implies
effects to all other colunms as well including column B. But there it only
cancels out one line for VW.

Then column B is updated by selecting "Tesla". This is only possible because
I=22000 is not deselected or cancelled out before. If in the first step one
deselects B=Porsche and step 2 is repeated, then one can't reselect B=Tesla
because I=22000 is missing as Porsche is the only other car providing I=22000

This is exactly the behavior of MS Excel 365 (I just tested it). So I come to
the conclusion that Calc has a problem with keeping the order of filters. Think
of filters as conditions and there order is crucial. And I am convinced the
Pivot Table is flawed due to the same reasons.

-- 
You are receiving this mail because:
You are on the CC list for the bug.