Spire.XLS 9.9.5 supports applying style to whole worksheet and sorting PivotTable data

We're pleased to announce the release of Spire.XLS 9.9.5. This version adds two new methods to apply style to the whole worksheet and sort PivotTable data. Besides, some issues that occurred when converting Xlt to Xls, excel to PDF/image, creating PivotTable and copying cells range are fixed successfully. See the content below for details.

New Features:

• Adds a method to apply the style for a whole worksheet.

CellStyle style = book.Styles.add("newStyle");
style.Color = Color.Pink;
style.Font.Size = 15;
book.Worksheets[0].ApplyStyle(style);

• Adds a method to sort PivotTable data.

PivotTable pt = sheet.PivotTables[0] as PivotTable;
(pt.RowFields[0] as PivotField).Sort(true,pt.DataFields[0]);
//(pt.ColumnFields[0] as PivotField).Sort(false, pt.DataFields[1]);
pt.CalculateData();

Bug Fixes:

• Fixes the issue that the cell color was incorrect after converting Xlt to Xls.
• Fixes the issue that the chart line displayed incorrectly after converting Excel to PDF and image.
• Fixes the issue that the application threw the "NotImplementedException" when using the Time function to create PivotTable.
• Fixes the issue that the formula value was acquired incorrectly.
• Fixes the issue that the application threw an exception when loading an excel file.
• Fixes the issue that the application threw the "StackOverFlowException" when executing CalculateAllValue.
• Fixes the issue that the range of conditional expressions was wrong when copying a range.