We're pleased to announce the release of Spire.XLS 15.8.3. This version adds support for the FORMULATEXT and PDURATION functions. Meanwhile, several issues that occurred when converting Excel to PDF or images, saving workbooks, handling PivotTables, and preserving cell styles have also been successfully fixed. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-5800 | Supports the FORMULATEXT function.
sheet.Range["D2"].Formula = "=FORMULATEXT(B2)"; |
| New feature | SPIREXLS-5895 | Supports the PDURATION function.
sheet.Range["B2"].Formula = "=PDURATION(2.5%,2000,2200)"; |
| Bug | SPIREXLS-5878 | Fixed an issue where text line breaks were incorrect when converting Excel to PDF. |
| Bug | SPIREXLS-5884 | Fixed an issue where deleting strikethrough formatting was affected by selected cells with conditional formatting after saving Excel. |
| Bug | SPIREXLS-5889 | Fixed an issue where content was lost when saving Excel to SVG. |
| Bug | SPIREXLS-5892 | Fixed an issue where saving a workbook after creating a group in a PivotTable resulted in a corrupted file or content errors upon opening. |
| Bug | SPIREXLS-5898 | Fixed an issue where formulas became incorrect after moving cells. |
| Bug | SPIREXLS-5899 | Fixed an issue where charts were missing when converting Excel to images. |
| Bug | SPIREXLS-5900 | Fixed an issue where cell styles were not preserved when inserting data using InsertDataTable. |
Click the link to download Spire.XLS 15.8.3:
More information of Spire.XLS new release or hotfix:
