https://bugs.documentfoundation.org/show_bug.cgi?id=162971
Bug ID: 162971
Summary: When right-clicking and sorting PivotTable data,
totals row treated as data
Product: LibreOffice
Version: 24.8.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Suppose you have a PivotTable with a totals row at the bottom (and some lines
of actual data). If you:
1. Click somewhere in the PT's data area
2. On the menu, click Data > Sort...
3. Click Sort
You'll notice two problems.
While the entire PivotTable is selected, including header rows, the dialog
doesn't have "Range Contains Column Labels". But - that's the minor issue
(although maybe it also merits a bug). The bigger problem will be that the
"Total" or "Total Result" row will now be placed according to its value, so
that if you sorted-descending on a certain column, then the "total" will appear
as the first row under the header.
--
You are receiving this mail because:
You are the assignee for the bug.
