We're pleased to announce the release of Spire.XLS for Java 16.1.3. This version supports inserting/ retrieving/ updating equations, and also supports the F.INV and T.INV.2T functions. Furthermore, several issues that occurred when processing and converting Excel files (e.g., HTML to Excel, Excel to PDF) have been successfully fixed. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-5237 | Added support for inserting, retrieving, and updating equations.
// Insert an equation
sheet.getEquations().addEquation(11, 0, 100, 100, "x_{1}^{2}");
// Retrieve an equation
String mathML = sheet.getEquations().get(0).exportMathML();
String latex = sheet.getEquations().get(0).exportLaTeX();
// Update an equation
IXlsEquation equation1 = sheet.getEquations().get(0);
equation1.updateByLaTeXText("\\begin{pmatrix} \r\n 1 & 0 \\\\ \r\n 0 & 1 \r\n \\end{pmatrix} \r\n \\left(x-1\\right)\\left(x+3\\right)");
|
| New feature | SPIREXLS-6047 | Added support for the F.INV function.
worksheet.getCellRange("A2").setFormula("=F.INV(0.99, 100, 200)");
|
| New feature | SPIREXLS-6048 | Added support for the T.INV.2T function.
worksheet.getCellRange("A2").setFormula("=T.INV.2T(0.05, 10)");
|
| Bug | SPIREXLS-6045 | Fixed an issue where an “ArrayIndexOutOfBoundsException” was thrown when converting HTML to Excel. |
| Bug | SPIREXLS-6053 | Fixed an issue where formula calculation took an excessively long time. |
| Bug | SPIREXLS-6056 | Fixed an issue where formulas displayed an unexpected blue background when converting XLSX to XLS. |
| Bug | SPIREXLS-6058 | Fixed an issue where extra borders appeared in the output when converting Excel to PDF. |
| Bug | SPIREXLS-6062 | Fixed an issue where a “NullPointerException” occurred when saving XLS files to XLSX format. |
| Bug | SPIREXLS-6064 | Fixed an issue where copying cell content containing embedded images to another Excel workbook failed. |
| Bug | SPIREXLS-6066 | Fixed an issue where a “NullPointerException” was thrown during Excel-to-PDF conversion. |
| Bug | SPIREXLS-6067 | Fixed an issue where local image files could not be deleted after inserting pictures into Excel due to unreleased file handles. |
Click the link to download Spire.XLS for Java 16.1.3:
