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.
If it's a bug that occurs when opening xlsx files, it may be related to a fix between version 3.5 and 3.6. I ran bisect on linux-43all, but linux-43all couldn't find the exact first bad commit. ba8918aebd2b9f030e0fd684accc9bf21bd1eac3 bad 0a45b102953a86ea3f26ffd5740f791b3f752f08 good I think these commits might be the clue to the solution. 34ff598994a52e8058e34074cb18a993e8c82157 d473a3699befc388d49bdba491a543d88bcf0778 513edaa41ddb4dfdf6e3ec1efd44f56ff959ef26