We are happy to announce the release of Spire.XLS 13.5.0. This version supports ISO.CEILING and WORKDAY.INTL functions as well as EVALUATE function in WPS. It also enhances the conversion from Excel to HTML and images. In addition, many known issues are fixed in this version, such as the issue that the function area of the menu bar was incorrect after saving the document. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-4561 | Supports ISO.CEILING function.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "ISO.CEILING(12.69,2)";
workbook.CalculateAllValue();
workbook.SaveToFile("result.xlsx",ExcelVersion.Version2016);
|
| New feature | SPIREXLS-4564 | Supports WORKDAY.INTL function.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "=WORKDAY.INTL(DATE(2023,3,17),25,1,DATE(2023,3,20))";
workbook.CalculateAllValue();
workbook.SaveToFile("result.xlsx",ExcelVersion.Version2016);
|
| New feature | SPIREXLS-4608 | Supports EVALUATE function in WPS. |
| Bug | SPIREXLS-4568 | Fixed the issue that System.ArgumentException exception was thrown in concurrent conversion of worksheets to HTML program. |
| Bug | SPIREXLS-4575 | Fixed the issue that when filling some cells with color, other cells are also filled. |
| Bug | SPIREXLS-4599 | Fixed the issue that it failed to copy some cells. |
| Bug | SPIREXLS-4600 | Fixed the issue that System.OutOfMemoryException exception was thrown when converting Excel to HTML. |
| Bug | SPIREXLS-4607 | Fixed the issue that System.IndexOutOfRangeException exception was thrown when loading Excel files. |
| Bug | SPIREXLS-4613 | Fixed the issue that function area of the menu bar was incorrect after saving the document. |
| Bug | SPIREXLS-4626 | Fixed the issue that many blank columns were generated after deleting hidden rows. |
| Bug | SPIREXLS-4627 | Fixed the issue that the content was incorrect when using .Net Standard package to convert sheets to images. |
Click the link to download Spire.XLS 13.5.0:
More information of Spire.XLS new release or hotfix:
