Specify whether the PivotTable is compatible for Excel2003 while refreshing PivotTable with Golang via C++
Contents
[
Hide
]
Aspose.Cells provides the PivotTable.IsExcel2003Compatible property, which you can use to specify whether the PivotTable is compatible with Excel2003 while refreshing the PivotTable. If true, a string must be less than or equal to 255 characters, so if the string is greater than 255 characters, it will be truncated. If false, a string will not have the aforementioned restriction. The default value is true.
Specify whether the PivotTable is compatible for Excel2003 while refreshing PivotTable
The following sample code explains the usage of the PivotTable.IsExcel2003Compatible property. The original string is 383 characters long. However, when the PivotTable.IsExcel2003Compatible property is set to true and the pivot table is refreshed, the data in cell B5 of the pivot table is truncated to 255 characters. Conversely, when the property is set to false and the pivot table is refreshed again, the data in cell B5 is not truncated and remains 383 characters long. Please read the comments inside the code for a better understanding of this property.