https://bugs.documentfoundation.org/show_bug.cgi?id=140760
--- Comment #11 from Eike <[email protected]> --- 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 the assignee for the bug.
