[Libreoffice-bugs] [Bug 140760] New: Pivot table: 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

            Bug ID: 140760
           Summary: Pivot table: selection of invalid constraint values
                    possible and probably this irreversibly results in an
                    empty pivot table
           Product: LibreOffice
           Version: 6.1 all versions
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: estolle at web.de

Description:
I have a large table with a lot of constraints and data columns. After
generating a pivot table I want to analyze the content by selecting a certain
choice of constraint values.

Observation: given a pivot table with a specific selection of filter values
(constraints) of some columns, it is possible to apply a constraint value
(value in the column filter) to an column which is not element of any cell in
that column.

1. This is very bad because the population of filter values should be adapted
to the current selection. 
2. And, when applying this selection, the result is empty - which is correct,
because the filter value is not element of any cell in the column. However, one
can't undo that - neither by hitting Undo nor by unselecting the filter value.
The only remedy is to close the file and reopen it.

The bug is old. I selected release 6.1 because I believe I already saw it
there.

Steps to Reproduce:
1. Generate a pivot table
2. Apply some filter values such that there is one column (let's call it X)
where one element is cancelled out.
3. Now filter column X by selecting the value that shouldn't be there (yes,
that's possible)

Actual Results:
You will get an empty pivot table in a deadlocked situation. One has to delete
the table and generate a new one in order to continue working or close the file
(don't save, of course) and reload.

Expected Results:
The filter values should be updated each time any filter is applied in order to
prevent selection of empty sets.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.1.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: kf5
Locale: de-DE (de_DE.UTF-8); UI: en-US
Ubuntu package version: 1:7.1.1~rc2-0ubuntu0.20.04.1~lo1
Calc: CL

OpenCL is not an issue here.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210302/d5bd0fcc/attachment.htm>