Spire.XLS 13.4.0 supports BITXOR and ISFUNCTION functions

2023-04-10 06:16:20

We are excited to announce the release of Spire.XLS 13.4.0. This version supports BITXOR and ISFUNCTION functions. Besides, it enhances the conversion from Excel to HTML, images, as well as PDF and the conversion from HTML to Excel. What's more, some known issues are fixed in this version, such as the issue that the application threw 'missing root element' when loading a .xlsm file. More details are listed below.

Here is a list of changes made in this release

Category ID Description
New feature SPIREXLS-4485 Supports BITXOR function.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "BITXOR(12,58)";
workbook.CalculateAllValue();
workbook.SaveToFile("result.xlsx");
New feature SPIREXLS-4544 Supports ISFUNCTION function.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "ISFORMULA(A1)";
workbook.CalculateAllValue();
workbook.SaveToFile("result.xlsx");
Bug SPIREXLS-265 Fixed the issue that the image was lost after converting an Excel file to an HTML file.
Bug SPIREXLS-2059 Fixed the issue that the content layout was incorrect after converting an Excel file to images.
Bug SPIREXLS-4507 Fixed the issue that the image was lost after converting an Excel file to a PDF file.
Bug SPIREXLS-4536 Fixed the issue that the content layout was incorrect after converting an Excel file to an HTML file and then converting the HTML file to an Excel file.
Bug SPIREXLS-4542 Fixed the issue that the application threw "System.ArgumentException: Invalid row index" when copying cells from Excel file.
Bug SPIREXLS-4569 Fixed the issue that the setting "chartSerieDataFormat.IsSmoothedLine" didn't taking effect.
Bug SPIREXLS-4570 Fixed the issue that the application threw "missing root element" when loading an .xlsm file.
Bug SPIREXLS-4583 Fixed the issue that there was an error when opening the result file after modifying a .xlsb file.
Click the link to download Spire.XLS 13.4.0:
More information of Spire.XLS new release or hotfix: