[Bug] Pivot Table column headers not updating & not editable

[arthurpankiewicz]

Before you submit this issue, have you checked the following

• Is this really a problem?
• I have searched the Github Issues for similar issues, but did not find anything.

Affected packages and versions

0.9.4

Reproduction link

This is recreatable on univer showcase (charts has pivot table enabled): https://docs.univer.ai/showcase/sheets/charts

The value column header does not update when no longer using total and cannot be edited.

Screen.Recording.2025-07-30.at.11.06.10.AM.mov

Expected behavior

• Create a pivot table from dataset
• Update values column to something other than total sum, ie. average
• Column header should change to "Average"
• Column header should be editable

Actual behavior

• Column header does not change on its own
• Column header can be erased (backspace), new text does not enter, value does not update when blurring cell

System information

System:
OS: macOS 15.5
CPU: (10) arm64 Apple M1 Max
Memory: 149.95 MB / 32.00 GB
Shell: 5.9 - /bin/zsh
Binaries:
Node: 22.1.0 - ~/.nvm/versions/node/v22.1.0/bin/node
npm: 10.7.0 - ~/.nvm/versions/node/v22.1.0/bin/npm
Browsers:
Brave Browser: 106.1.44.101
Chrome: 138.0.7204.169
Safari: 18.5

[VicKun4937]

hi， this part is create by the layout of pivot table , we will never support editing this part. and the Grand Total means this row/col is the grand total row /col it will not show the subtotal types , the subtotal type will show like below:

---

if you real want to change the words Grand Total, you may find it in resource files, here is some guide :
https://docs.univer.ai/guides/sheets/getting-started/i18n

const locale = {
    'sheets-pivot': {
        blankValue: '(Blank)',
        columnName: 'Column ',
        subTotalText: 'Total',
        grandTotalText: 'Grand Total',
        valueText: 'Value',
        averageName: 'Average of ',
        countName: 'Count of ',
        countNumsName: 'Count of ',
        maxName: 'Max of ',
        minName: 'Min of ',
        productName: 'Product of ',
        stdDevName: 'StdDev of ',
        stdDevpName: 'StdDevp of ',
        sumName: 'Sum of ',
        varName: 'Var of ',
        varpName: 'Varp of ',

        subTotal: 'Subtotal',
        grandTotal: 'Grand Total',
       

above is some useful resource key for you

[arthurpankiewicz]

hi @VicKun4937, i understand the header should not be editable in your case, but the text should change when the value column changes to average, no?

here is the behaviour in excel, changing the pivot colum from sum to average updates the header to indicate it is now average:

Screen.Recording.2025-07-31.at.10.33.15.AM.mov

and for reference, here is the exact same scenario in univer:

Screen.Recording.2025-07-31.at.10.34.36.AM.mov

univer is correctly updating the text in the pivot flyout, but the column is still "grand total" implying sum and not average

[VicKun4937]

yes, your are right. I will check the layout code in the case above, it should show as excel when there are no column or row fields

[wpxp123456]

Version 0.10.3 has been fixed.