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
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.
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.
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.