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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
