We're pleased to announce the release of Spire.XLS 14.11.3. This version supports passing values to group pivot tables, and also supports the new formulas including ACOT, ACOTH, COT, TOROW, TOCOL. Moreover, some issues that occurred when converting, loading, saving and printing Excel documents have been successfully resolved. More details are shown below.

Here is a list of changes made in this release

Workbook wb = new Workbook();
 wb.LoadFromFile(inputFile);
 Worksheet pivotSheet = wb.Worksheets[0]; 
 XlsPivotTable pivot = (XlsPivotTable)pivotSheet.PivotTables[0]; PivotField dateBaseField = pivot.PivotFields["number"] as PivotField;
 dateBaseField.CreateGroup(3000, 3800, 1);
 pivot.CalculateData();
 wb.SaveToFile(outputFile);
 wb.Dispose();