Bug 163207 - Pivot Table Column Headers change on Refresh
Summary: Pivot Table Column Headers change on Refresh
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.2.1 release
Hardware: IA64 (Itanium) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2024-09-29 19:08 UTC by Dave__I
Modified: 2024-09-30 04:31 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample ODS file to test saving as XLSX. (17.94 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-09-30 02:46 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Dave__I 2024-09-29 19:08:12 UTC
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
Comment 1 m_a_riosv 2024-09-29 21:01:29 UTC
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
Comment 2 m_a_riosv 2024-09-30 02:44:34 UTC
Reproducible
Version: 6.4.7.2 (x64) Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US Calc: CL
and
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: c7c52f60657baa65e104530247ed05a90479e99e
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

Saving as XLSX some title fields are copied from the first of the same fields.
It happens when there are several calculations on the same field.
Saving again as ODS doesn't solve the issue. It's needed a PT rebuild.


Something between V 5 and V 6 allows recovering the PT, but has the issue with the calculated fields headers.
Comment 3 m_a_riosv 2024-09-30 02:46:55 UTC
Created attachment 196791 [details]
Sample ODS file to test saving as XLSX.

I think not really a regression, previous versions don't allow recovering the PT.

Hope it is possible to find when the issue begins.