https://bugs.documentfoundation.org/show_bug.cgi?id=153217
Bug ID: 153217
Summary: Pivot grouping expands to all pivots
Product: LibreOffice
Version: 7.5.0.2 rc
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
In the attached spreadsheet the first sheet contains a source table and a pivot
side by side. The pivot is grouped by month and year. The second pivot on the
other sheet has been created by just dragging the date to column fields and the
values to data fields. It has been grouped by month automatically, but not by
year since the Janurary sums include the values of both Januaries.
When you remove the grouping from either pivot, it is removed from the other
pivot as well even without manual refresh.
Steps to Reproduce:
1. Click a pivot cell in the in one of the year/quarter/month columns and
remove the grouping from one pivot (Ctrl+F12)
2. The pivot shows single dates
3.
Actual Results:
The second pivot also shows singel dates
Expected Results:
2 pivots should be grouped independently from each other
Reproducible: Always
User Profile Reset: Yes
Additional Info:
https://ask.libreoffice.org/t/how-to-properly-filter-by-date-in-a-pivot-table/86966/4
--
You are receiving this mail because:
You are the assignee for the bug.
