News & Releases
|
|

Spire.XLS 10.4.9 supports showing or not showing subtotals of PivotTable
We're pleased to announce the release of Spire.XLS 10.4.9. This version supports showing or not showing subtotals of PivotTable. Besides, some issues that occurred when converting Excel to XML/PDF/Image, loading and manipulating files are also fixed successfully. See the following content for more details.
Here is a list of changes made in this release
| Category | ID | Description |
| New Feature | SPIREXLS-2057 | Supports showing or not showing subtotals of PivotTable.
pt.ShowSubtotals = true; pt.ShowSubtotals = false; |
| Bug | SPIREXLS-1810 | Fixes the issue that the DisplayedText returned the incorrect date format. |
| Bug | SPIREXLS-2006 | Fixes the issue that after converting .xls to .xlsm, the generated .xlsm prompted an error when opening it. |
| Bug | SPIREXLS-2018 | Fixes the issue that it failed to set chart title and the font of chart axis. |
| Bug | SPIREXLS-2044 | Fixes the issue that the application threw an exception when loading Excel on .NET Core 2.2 platform. |
| Bug | SPIREXLS-2051 | Fixes the issue that it caused incorrect content format after converting Excel to image. |
| Bug | SPIREXLS-2120 | Fixes the issue that after converting a sheet which contains a chart (whose data is from a pivot table) to PDF, the data of chart was incorrect. |
| Bug | SPIREXLS-2147 | Fixes the issue that the markerdesigner couldn't copy the correct style. |
| Bug | SPIREXLS-2164 | Fixes the issue that the application threw the exception "InvalidOperationException" when loading an Excel. |
| Bug | SPIREXLS-2187 | Fixes the issue that the formula value could not be calculated correctly. |
| Bug | SPIREXLS-2201 | Fixes the issue that the application threw the "NullReferenceException" when loading an Excel. |
| Bug | SPIREXLS-2203 | Fixes the issue that after merging Excel files, the generated file prompted an error when opening it. |
| Bug | SPIREXLS-2214 | Fixes the issue that after adding filter, the generated file prompted an error when opening it. |
| Bug | SPIREXLS-2224 SPIREXLS-2232 |
Fixes the issue that it caused incorrect content format after converting Excel to PDF. |
| Bug | SPIREXLS-2230 | Fixes the issue that the application threw the "NullReferenceException" when inserting a new row in a copied sheet. |
| Bug | SPIREXLS-2240 | Fixes the issue that it caused incorrect date format after converting Excel to XML. |
| Bug | SPIREXLS-2241 | Fixes the issue that after creating a pivot table, the generated file prompted an error when opening it. |
Click the link to download Spire.XLS 10.4.9:
More information of Spire.XLS new release or hotfix: