We’re pleased to announce the release of Spire.Office 10.11.0. In this version, Spire.Doc optimize the OfficeMath processing capabilities; Spire.XLS supports converting Excel to JSON; Spire.Presentation enhances the conversion form PPTX to PDF; Spire.PDF supports printing logging in NETStandard environment. Meanwhile, a series of known issues have been fixed in this update. More details are as follows.
In this version, the most recent versions of Spire.Doc, Spire.PDF, Spire.XLS, Spire.Presentation, Spire.Barcode, Spire.DocViewer, and Spire.PDFViewer are included.
DLL Versions:
- • Spire.Doc.dll v13.11.5,
- • Spire.Pdf.dll v11.11.5,
- • Spire.XLS.dll v15.11.3,
- • Spire.Presentation.dll v10.11.4,
- • Spire.Barcode.dll v7.4.1,
- • Spire.Email.dll v6.6.3,
- • Spire.DocViewer.Forms.dll v8.9.4,
- • Spire.PdfViewer.Asp.dll v8.2.6,
- • Spire.PdfViewer.Forms.dll v8.2.16
- • Spire.Spreadsheet.dll v7.5.2,
- • Spire.OfficeViewer.Forms.dll v8.8.0,
- • Spire.DataExport.dll 4.9.0,
- • Spire.DataExport.ResourceMgr.dll v2.1.0
Click the link to get the version Spire.Office 10.11.0:
More information of Spire.Office new release or hotfix:
Here is a list of changes made in this release
Spire.Doc
| Category | ID | Description |
| Optimization | - | Optimized OfficeMath processing capabilities and enhanced the display effects of formula line wrapping and revisions. |
Spre.XLS
| 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. |
Spire.Presentation
| Category | ID | Description |
| Bug | SPIREPPT-2873, SPIREPPT-2888 | Fixed the issue where image effects were displayed incorrectly when converting PowerPoint to PDF. |
| Bug | SPIREPPT-2951 | Fixed the issue where layout became inconsistent when converting PowerPoint to PDF. |
| Bug | SPIREPPT-3012 | Fixed the issue where footer content was missing when converting ODP to PDF. |
Spire.PDF
| Category | ID | Description |
| Adjustment | — | Removed dependencies on System.Security.Cryptography.Pkcs, System.Security.Permissions, and System.Security.Cryptography.Xml in NetCore and NetStandard platforms. |
| New feature | — | Added support for enabling print logging in NETStandard DLL. PdfDocument doc = new PdfDocument(); doc.LoadFromFile("in.pdf"); doc.PrintSettings.PrintLogger= new DefaultPrintLogger("log.txt"); doc.PrintSettings.PaperSize =PdfPaperSize.A4; doc.Print(); |
| Bug | SPIREPDF-3758 | Fixed the issue where background color was lost when converting PDF to images. |
| Bug | SPIREPDF-4271 | Fixed the issue where Arabic text content displayed incorrectly when converting PDF to PDF/A-3A. |
| Bug | SPIREPDF-5542 | Optimized the performance of text extraction and search in NETStandard DLL. |
| Bug | SPIREPDF-7753 | Fixed the issue where font effects were incorrect after text replacement. |
| Bug | SPIREPDF-7771 | Fixed the issue where validation failed when converting PDF to PDF/A-1B. |
| Bug | SPIREPDF-7779 | Fixed the issue where errors occurred when printing PDF documents using the NETStandard DLL on UOS x86 systems. |
| Bug | SPIREPDF-3749 | Fixed the issue where incorrect effects were applied to added image watermarks. |
| Bug | SPIREPDF-5688 | Fixed the issue with incorrect output when converting PDF to PDF/A. |
| Bug | SPIREPDF-5889 | Fixed the issue with incorrect output when converting PDF to images. |
| Bug | SPIREPDF-6457 | Fixed the issue where background images were lost when converting a PDF to images. |
| Bug | SPIREPDF-7063 | Fixed the issue with incorrect output when printing PDF documents. |
| Bug | SPIREPDF-7102 | Optimized time consumption and memory usage when converting images using the NetStandard DLL. |
| Bug | SPIREPDF-7105, SPIREPDF-7572 | Fixed the issue where bookmarks were lost when converting PDF to OFD. |
| Bug | SPIREPDF-7562 | Fixed the issue where converting PDF to images threw “System.NotImplementedException”. |
| Bug | SPIREPDF-7749 | Fixed the issue where custom properties added via SetCustomProperty were lost when converting PDF to OFD. |
| Bug | SPIREPDF-7767 | Fixed the issue where converting PDF to OFD threw “System.ArgumentOutOfRangeException”. |
| Bug | SPIREPDF-7807 | Fixed the issue where loading PDF files threw “System.NullReferenceException”. |
| Bug | SPIREPDF-7808 | Fixed the issue where "pdfbuttonfield.IconLayout.IsFitBounds = true" did not take effect. |
