We're pleased to announce the release of Spire.XLS 15.11.3. This version adds support for exporting equation content to MathML and LaTeX, the XMATCH function, converting Excel to JSON, setting EMF background images, and inserting checkbox effects similar to Office 365. Meanwhile, several issues related to loading Excel documents, converting Excel to PDF, and formula calculations 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-5977, SPIREXLS-5978 | Added support for exporting equation content to MathML and LaTeX.
Workbook workbook = new Workbook();
workbook.LoadFromFile(inputFile);
Worksheet sheet = workbook.Worksheets[0];
string mathML = sheet.Equations[0].ExportMathML();
sheet.Range["B9"].Value = "mathML:";
sheet.Range["B10"].Value = mathML;
string LaTex = sheet.Equations[0].ExportLaTex();
sheet.Range["B12"].Value = "LaTeX:";
sheet.Range["B13"].Value = LaTex;
workbook.SaveToFile(outputFile);
File.WriteAllText(outputFile_TXT, "LaTeX:\t" + LaTex + "\r\nmathML:\t" + mathML);
|
| New feature | SPIREXLS-5982 | Added support for the XMATCH function.
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"test.xlsx");
Worksheet sheet = workbook.Worksheets[0];
sheet.Range["C4"].Formula = "=XMATCH(\"王五\", A2:A5)";
workbook.CalculateAllValue();
|
| New feature | SPIREXLS-5990, SPIREXLS-5991 | Added support for checkbox effects similar to Office 365.
XlsRange range = sheet.Range["A1"]； range.InsertEmbedCheckBox(); rang.SetEmbedCheckBoxCheckState(true); |
| New feature | SPIREXLS-6021 | Added support for converting Excel to JSON.
Workbook workbook = new Workbook(); workbook.LoadFromFile(inputFile); workbook.SaveToFile(outputFile, FileFormat.Json); workbook.Dispose(); |
| New feature | SPIREXLS-6022 | Added support for setting EMF background images.
Workbook workbook = new Workbook(); workbook.LoadFromFile(inputFile); Worksheet sheet = workbook.Worksheets[0]; Stream image = File.OpenRead(inputFile_Img); sheet.PageSetup.BackgoundImageStream = image; workbook.SaveToFile(outputFile, ExcelVersion.Version2013); |
| Bug | SPIREXLS-5958 | Fixed the issue with incorrect rendering when converting Excel to PDF. |
| Bug | SPIREXLS-5998 | Fixed the issue where loading Excel documents caused an “Invalid string in the file” error. |
| Bug | SPIREXLS-6008 | Fixed the issue where loading Excel documents caused the application to hang. |
| Bug | SPIREXLS-6009 | Fixed the incorrect behavior of the AutoFitColumns() method. |
| Bug | SPIREXLS-6016 | Fixed the issue with incorrect formulas after loading and saving Excel files. |
Click the link to download Spire.XLS 15.11.3:
More information of Spire.XLS new release or hotfix:
