https://bugs.documentfoundation.org/show_bug.cgi?id=140760
--- Comment #2 from Eike <[email protected]> --- Created attachment 175750 --> https://bugs.documentfoundation.org/attachment.cgi?id=175750&action=edit Spreadsheet and explanation of the reported bug I added the spreadsheet file to the ticket because the bug still persists and I still have not lost hope that somebody will look at it. I tested it with 7.2.1.2 release and 7.2.2.2 rc2 on Kubuntu 20.04 trying both, with and without OpenCL. Just to make it clear: this is a fundamental bug in the pivottable functionality of LibreOffice Calc! Version: 7.2.2.2 / LibreOffice Community Build ID: 20(Build:2) CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: en-US Ubuntu package version: 1:7.2.2~rc2-0ubuntu0.20.04.1~lo1 Calc: CL Steps to reproduce bug 140760 1. Exclude value b from Constraint1 2. Open list of values for Constraint2 Result: a. - You will still be able to see value 3 (ERROR!) although it should not be there because value b was excluded from column Constraint1. - It is vital that the constraint values are valid subset and correspond to the current selection of constraints. Evidently, here is missing an update of the other constraint columns reflecting the last selection. b. - If you select value 3 only, you will get an empty set as result. c. - In Constraints1, select b again. Now all values should be selected. However,there is only one line shown, namely for Constraint1 = b (ERROR) - I believe this is caused by the missing update of constraints as well. c. - Try undoing operations with CTRL+Shift+Z. This causes even more strange effects. -- You are receiving this mail because: You are the assignee for the bug.
