https://bugs.documentfoundation.org/show_bug.cgi?id=163207
Bug ID: 163207
Summary: Pivot Table Column Headers change on Refresh
Product: LibreOffice
Version: 24.8.2.1 release
Hardware: IA64 (Itanium)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
After creating a pivot table, where some of the data fields have functions
other than Count, if a Refresh on the data is performed, the column headers
display "Count" instead of the chosen function, e.g. Max, Avg, Min, etc. The
data displayed in the pivot table is correct in that it shows the Max, Avg,
Min, etc.
Steps to Reproduce:
1. Create a spreadsheet with a column for Class and values of Freshman, Junior,
etc with a header titled "Class." Create a column for student age with a
column header of "Age"
2. Value several rows with each row representing a different student
3. Use the wizard to create a pivot table. The Row should be Class. Drag the
Age field to the Data Fields 3 times and apply the functions Count, Max, Min.
Actual Results:
Immediately after creating the pivot the column headers are correct in the
Pivot and display "Count - age", "Max - age" and "Min - age"
However, if you then right click within the pivot table that was created and
select "Refresh", the column headers change to "Count - age", "Count - age" and
"Count - age". The functions are correctly applied to the data, but the column
headers are incorrect.
Expected Results:
the column headers are correct in the Pivot and display "Count - age", "Max -
age" and "Min - age" even after a Refresh.
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
--
You are receiving this mail because:
You are the assignee for the bug.
