diff options
| author | Knut Stenmark <[email protected]> | 2022-07-21 16:17:46 +0200 |
|---|---|---|
| committer | Knut Stenmark <[email protected]> | 2022-07-21 16:17:46 +0200 |
| commit | f2a4b5a4342226650ca0d8618b43ccbe7b267925 (patch) | |
| tree | 53acbf733934bf952f33abc20ae94fa89513e1f6 /CHANGELOG.md | |
| parent | e975a2451ae3c5f6eb62bfbfea33be3bb9f2cb14 (diff) | |
| download | caxlsx-f2a4b5a4342226650ca0d8618b43ccbe7b267925.tar.gz caxlsx-f2a4b5a4342226650ca0d8618b43ccbe7b267925.zip | |
Prevent Excel from crashing when multiple data columns are added to PivotTable
Excel will crash unless both `colFields` and `colItems` are declared in the PivotTable xml.
First `field` of `colFields` needs to be set to -2 to tell Excel that the value columns comes from individual columns and not groups.
I do not know why `colItems` are needed, but when set, the Excel document opens without crashing.
Diffstat (limited to 'CHANGELOG.md')
0 files changed, 0 insertions, 0 deletions