https://bugs.documentfoundation.org/show_bug.cgi?id=140760
--- Comment #5 from Mike Kaganski <[email protected]> --- 1. Wrt only showing available elements in the filter dropdowns: I don't see a problem in making it consistent with how autofilter works - so if autofilter only shows the items available after other filters were applied, why not do the same here. 2. However, that would only be a convenience method, and would not prevent the result that is considered problematic - you only have to change the source, and update the pre-filtered pivot table, to get that. So the actual bug - that is still not explained how to reproduce - is that a "deadlock" can happen. There should not be a state when the pivot table can't be "unfiltered". Possibly that would happen using the "change source + update pivot table", when the source would not contain a single instance of the value that is only permitted in the filter? -- You are receiving this mail because: You are the assignee for the bug.
