[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 #9 from Eike <estolle at web.de> ---
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 on the CC list for the bug.