Spire.XLS 11.2.6

Spire.XLS 11.2.6 supports changing data source in Pivot Table

We are happy to announce the release of Spire.XLS 11.2.6. This version supports changing data source in Pivot Table, enhances the conversion from Excel to PDF and also fixes the issues in the process of loading XLSM files. More details are listed below.

Here is a list of changes made in this release

Category ID Description
New Feature SPIREXLS-813
SPIREXLS-2714
Supports changing data source in Pivot Table.
var pivotTable = sheet.PivotTables[0];
((Spire.Xls.PivotTable)pivotTable).ChangeDataSource(sheet.Range["A1:C9"]);
Bug SPIREXLS-2419 Fixes the issue that getting series data in discontinuous areas failed.
Bug SPIREXLS-2808 Fixes the issue that the corresponding data was incorrect when setting PlotArea to create a chart.
Bug SPIREXLS-2916 Fixes the issue that the date formula conversion failed when converting Excel to PDF.
Bug SPIREXLS-3006 Fixes the issue that the application threw "Exception Unhandled" when converting Excel to PDF.
Bug SPIREXLS-3085 Fixes the issue that setting HasMajorGridLines as "true" did not work when creating a new chart.
Bug SPIREXLS-3087 Fixes the issue that the application threw "System.NullReferenceException" when loading an XLSM file and threw "System.ArgumentOutOfRangeException" when converting an XLSM file to HTML.
Bug SPIREXLS-3104 Fixes the issue that the recognition of date format data was incorrect.
Bug SPIREXLS-3115 Fixes the issue that the barcode of output PDF was displayed incorrectly when converting XLSX to PDF.
Bug SPIREXLS-3116 Fixes the issue of the chart being updated incorrectly.
Click the link to download Spire.XLS 11.2.6:
More information of Spire.XLS new release or hotfix: