We are excited to announce the release of Spire.XLS 15.6.6. The latest version supports the SHEETS function. Besides, some known bugs are fixed successfully in this version, such as the issue that the AutoFitColumns effect was not working correctly. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-5806 | Supports the SHEETS function.
sheet.Range["B2"].Formula = "=SHEETS()"; sheet.Range["B3"].Formula = "=SHEETS(Sheet2!C5)"; sheet.Range["B4"].Formula = "=SHEETS(Sheet3:Sheet5!A1)"; sheet.Range["B6"].Formula = "=SHEETS(Sheet4!C5); |
| Bug | SPIREXLS-5802 | Fixes the issue where the AutoFitColumns effect was not working correctly. |
| Bug | SPIREXLS-5804 | Fixes the issue where the style of shapes was incorrect when copying worksheets. |
| Bug | SPIREXLS-5814 SPIREXLS-5853 |
Fixes the issue where the data was incorrect when saving a sheet as an image. |
| Bug | SPIREXLS-5819 | Fixes the issue where the saved Excel file reported errors when opened. |
| Bug | SPIREXLS-5832 | Fixes the issue where saving an Excel file to PDF/A3B was incorrect. |
| Bug | SPIREXLS-5834 | Fixes the issue where the left and right margins were incorrect when converting Excel to PDF. |
| Bug | SPIREXLS-5841 | Fixes the issue where the content was incorrect when converting a CellRange to an image. |
Click the link to download Spire.XLS 15.6.6:
More information of Spire.XLS new release or hotfix:
