The order of the pivot table supports custom fields

[liuwangchao]

Description

Steps to reproduce the issue:

1. I created a pivot table by this simple data and generated a simple pivot table
   
   

2. But after I use Excel's Analyze - Fields, Items, and Sets - Calculated Fields function to add a field, and call func (f *File) getPivotTable(sheet, pivotTableXML, pivotCacheRels string)
   
   
   

Describe the results you received:

I get panic: "msg":"runtime error: index out of range [3] with length 3"

Describe the results you expected:

The error was reported at line 955 of the func (f *File) extractPivotTableFields(order []string, pt *xlsxPivotTableDefinition, opts *PivotTableOptions), the pivot table has four fields, but the length of the ORDER is still 3.

Output of go version:

1.22

Excelize version or commit ID:

v2.9.1-0.20241221071117-9934bf5c8634

[xuri]

Thanks for your feedback. This issue duplicated with #1954, I fixed this, please upgrade to the master branch code by following command, this patch will be released on the next version.

go get -u github.com/xuri/excelize/v2@master

[liuwangchao]

Thanks for your feedback. This issue duplicated with #1954, I fixed this, please upgrade to the master branch code by following command, this patch will be released on the next version.

go get -u github.com/xuri/excelize/v2@master

It works, thanks!