We are excited to announce the release of Spire.XLS 12.7.1. This version supports setting whether to keep the number format of the data when exporting to DataTable and supports calculating "UNICODE" formulas. Moreover, it also enhances the conversion from Excel to PDF and fixes some known issues such as formulas were not calculated after inserting formulas. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-3944 | Supports setting whether to keep the number format of the data when exporting to DataTable.
ExportTableOptions options = new ExportTableOptions(); options.KeepDataFormat = false; DataTable table = sheet.ExportDataTable(1, 1, sheet.LastDataRow, sheet.LastDataColumn, options); |
| New feature | - | Supports calculating "UNICODE" formulas. |
| Bug | SPIREXLS-3902 | Fixes the issue that the column names of the pivot table were offset after converting Excel to PDF. |
| Bug | SPIREXLS-3957 | Fixes the issue that "System.FormatException: Input string was not in a correct format" was thrown when loading HTML files |
| Bug | SPIREXLS-3966 | Fixes the issue that formulas were not calculated after inserting formulas. |
| Bug | SPIREXLS-3967 | Fixes the issue that "CellRange.DisplayedText" property getting incorrect value. |
| Bug | SPIREXLS-3971 | Fixes the issue that "System.FormatException: The string is not recognized as a valid DateTime" exception was thrown when converting Excel to PDF. |
| Bug | SPIREXLS-3972 | Fixes an issue that the application threw a null pointer exception when getting the name manager for a non-contiguous range. |
Click the link to download Spire.XLS 12.7.1:
More information of Spire.XLS new release or hotfix:
