We are pleased to announce the release of Spire.XLS 13.3.2. This version supports the ISOWEEKNUM formula, CEILING.PRECISE formula, ENCODEURL formula and supports replacing one font with another in a worksheet. Besides, it enhances the conversion from Excel to PDF, HTML and image. In addition, many known issues are fixed in this version, such as the issue that the location of the added TextBox was incorrect. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-4396 | Supports the ISOWEEKNUM formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "ISOWEEKNUM(DATE(2012,1,1))";
workbook.CalculateAllValue();
workbook.SaveToFile("result.xlsx");
|
| New feature | SPIREXLS-4404 | Supports the CEILING.PRECISE formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "CEILING.PRECISE(-4.6,3)";
workbook.CalculateAllValue();
workbook.SaveToFile("result.xlsx");
|
| New feature | SPIREXLS-4455 | Supports the ENCODEURL formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "ENCODEURL(\"https://www.e-iceblue.com\")";
workbook.CalculateAllValue();
workbook.SaveToFile("result.xlsx");
|
| New feature | SPIREXLS-4460 | Supports replacing one font with another in a worksheet.
sheet.ReplaceAll(oldValue, oldStyle, newValue, newStyle) |
| Bug | SPIREXLS-686 SPIREXLS-4431 |
Fixes the issue that the content was incorrect after converting Excel file to image. |
| Bug | SPIREXLS-3804 | Fixes the issue that the background color was lost after converting Excel file to image. |
| Bug | SPIREXLS-4259 | Fixes the issue that it obtained null value when using DisplayedText() to get text from the hidden cell range. |
| Bug | SPIREXLS-4406 | Fixes the issue that the cell values did not refresh after opening the saved file in MS Excel. |
| Bug | SPIREXLS-4414 | Fixes the issue that the location of the added TextBox was incorrect. |
| Bug | SPIREXLS-4428 | Fixes the issue that the result was incorrect after deleting cell range with the DeleteOption.MoveLeft parameter. |
| Bug | SPIREXLS-4446 | Fixes the issue that the application threw "Parameter is not valid" when deploying the application on Azure to replace Excel file image. |
| Bug | SPIREXLS-4466 | Fixes the issue that the content format was incorrect after inserting rows. |
| Bug | SPIREXLS-4468 | Fixes the issue that the cell value had extra space after converting a .txt file to Excel file. |
| Bug | SPIREXLS-4476 | Fixes the issue that the content was incorrect after converting Excel file to PDF. |
| Bug | SPIREXLS-4484 | Fixes the issue that the link was invalid after converting Excel file to HTML. |
| Bug | SPIREXLS-4504 | Fixes the issue that only one setting was valid when setting LastColumn and LastRow at the same time. |
Click the link to download Spire.XLS 13.3.2:
More information of Spire.XLS new release or hotfix:
