https://bugs.documentfoundation.org/show_bug.cgi?id=140760
--- Comment #9 from Eike <[email protected]> --- I now have upgraded to LibreOffice 7.4.1.2 Using the sample file attached I ran a retest on Autofilter and Pivot Table. = Autofilter works as far as I can see. = To be precise, with Autofilter I tested setting - Constraint 1 to "b" and then the filter of Constraint 2 displayed "3" as the only possibility. - I tried selecting all other combinations of first Constraint 1 and then Constraint 2 or the other way round. MS Excel shows the same behavior. = Pivot Table does not work. = I set Constraint 1 to "b" and then the only rows displayed contains a "3" for Constraint 2. However, the filter of Constraint 2 displays "1,3". If one now sets the filter of Constraint 2 to "1", the result will be an empty Pivot Table. Further, the column of Constraint 2 vanishes and one can't even Undo that, i.e. the command Undo has no effect here as well as Refresh so one is effectively locked out. That's it and the game starts again. This is a bug because providing filter settings that cannot be applied to the given subset makes no sense at all. Just imagine having a table with 30 columns and 50k rows (as I deal with from time to time). After applying a filter on the first column, how am I able to find out the allowed set of filter values for another columns in order to avoid lockout? It's important to have the file saved before each step of filtering. = My workaround = Well, my solution to that problem (using Calc) is that after I applied the first filter step I copy the resulting table to a new sheet, create a second Pivot Table and then I can filter the second column and then its filter shows the correct subset of filter values. Then I go back to the first Pivot Table and apply these on column 2. This process I repeat for all other columnns I additionally need until I am done. Another solution of course would be to use a SQL database for example but that cannot always be the solution. So to make a long message short: Autofilter subsequently updates the filter values, so why doesn't Pivot Table do that but instead produced vanishing columnns with lockout-effect and what is the reason for such nasty behavior? -- You are receiving this mail because: You are the assignee for the bug.
