We are excited to announce the release of Spire.Office 9.2.0. In this version, Spire.XLS supports setting the clipping position of header and footer images and adds XLT, XLTX, and XLTM formats to the FileFormat enumeration; Spire.Presentation supports embedding fonts in PPTX; Spire.PDF enhances the conversion from PDF to PDF/A, images, and OFD; Spire.Doc enhances the conversion from Word to PDF and HTML. Besides, a lot of known issues are fixed successfully in this version. More details are listed below.
In this version, the most recent versions of Spire.Doc, Spire.PDF, Spire.XLS, Spire.Presentation, Spire.Email, Spire.DocViewer, Spire.PDFViewer, Spire.Spreadsheet, Spire.OfficeViewer, Spire.DataExport, Spire.Barcode are included.
DLL Versions:
- Spire.Doc.dll v12.2.1
- Spire.Pdf.dll v10.2.2
- Spire.XLS.dll v14.2.1
- Spire.Presentation.dll v9.2.0
- Spire.Barcode.dll v7.2.9
- Spire.Spreadsheet.dll v7.4.6
- Spire.Email.dll v6.5.10
- Spire.DocViewer.Forms.dll v8.7.3
- Spire.PdfViewer.Forms.dll v7.12.3
- Spire.PdfViewer.Asp.dll v7.12.3
- Spire.OfficeViewer.Forms.dll v8.7.6
- Spire.DataExport.dll v4.9.0
- Spire.DataExport.ResourceMgr.dll v2.1.0
Click the link to get the version Spire.Office 9.2.0:
More information of Spire.Office new release or hotfix:
Here is a list of changes made in this release
Spire.PDF
| Category | ID | Description |
| Bug | SPIREPDF-6328 | Fixes the issue that the content was not displayed clearly when printing PDF. |
| Bug | SPIREPDF-6414 | Fixes the issue that the signature was damaged after reading a PDF containing a signature and saving it to a new document. |
| Bug | SPIREPDF-6431 | Fixes the issue that the value was rotated 90 degrees after modifying the value of a PDF form field. |
| Bug | SPIREPDF-6443 | Fixes the issue that text was not displayed clearly when converting PDF to images on the .NET Standard platform. |
| Bug | SPIREPDF-6278 | Fixes the issue that the result of drawing HTML text using PdfHTMLTextElement interface was incorrect. |
| Bug | SPIREPDF-6400 | Fixes the issue that the program threw System.OutOfMemoryException when saving a document after adding a bookmark. |
| Bug | SPIREPDF-6426 | Fixes the issue that content overlapped after replacing text. |
| Bug | SPIREPDF-6430 | Fixes the issue that the program threw System.IndexOutOfRangeException when converting OFD documents to PDF documents. |
| Bug | SPIREPDF-6445 | Fixes the issue that the program threw System.Collections.Generic.KeyNotFoundException when extracting tables. |
| Bug | SPIREPDF-6471 | Fixes the issue that the program threw System.ArgumentException when saving a page as an image after rotating it. |
| Bug | SPIREPDF-6473 | Fixes the issue that colored emoticons became black and white when converting HTML to PDF. |
| Bug | SPIREPDF-6477 | Fixes the issue that the content was incorrect after converting a PDF document to an image. |
| Bug | SPIREPDF-6480 | Fixes the issue that the program threw a System.NullReferenceException when printing PDF documents. |
| Bug | SPIREPDF-6483 | Fixes the issue that some text lost its bold style after converting a PDF document to an OFD document. |
| Bug | SPIREPDF-6427 SPIREPDF-6489 |
Fixes the issue that Find and Highlight text didn't work. |
| Bug | SPIREPDF-6456 | Fixes the issue that Arabic fonts were lost after converting a PDF document to a PDFA document. |
| Bug | SPIREPDF-6493 | Fixes the issue that the stamp position was shifted when printing PDF documents. |
| Bug | SPIREPDF-6509 | Fixes the issue that it was invalid to print a PDF document with the opposite direction of the front and back when printing on both sides of the document. |
| Bug | SPIREPDF-6510 | Fixes the issue that the program threw a System.NullReferenceException when converting a PDF document to a picture. |
| Bug | SPIREPDF-6524 | Fixes the issue that the font was over-bolded when converting a PDF document to an OFD document and then back to a PDF document. |
Spire.Doc
| Category | ID | Description |
| New feature | SPIREDOC-9979 SPIREDOC-10058 |
The left and right indentation function of the paragraph supports the option of setting the number of characters.
// Set left indentation by character count paragraph.Format.LeftIndentChars = 10; // Set right indentation by character count paragraph.Format.RightIndentChars = 10; |
| Bug | SPIREDOC-3363 | Fixes the issue that the content format was incorrect when converting Word documents to PDF documents. |
| Bug | SPIREDOC-3363 SPIREDOC-10083 |
Fixes the issue that the font changed when converting Word documents to PDF documents. |
| Bug | SPIREDOC-9136 | Fixes the issue that the document structure tags were lost when converting Word documents to PDF documents. |
| Bug | SPIREDOC-9718 | Fixes the issue that the fonts of formula content in saved Docx documents had extra italic effects. |
| Bug | SPIREDOC-9756 | Fixes the issue that the program threw System.ArgumentException when converting Word documents to HTML documents. |
| Bug | SPIREDOC-10001 | Fixes the issue that table border changed when converting Word documents to PDF documents. |
| Bug | SPIREDOC-10016 | Fixes the issue that there was an extra blank paragraph after replacing bookmark content. |
| Bug | SPIREDOC-10084 | Fixes the issue that font bold style was lost when converting Word documents to PDF documents. |
| Bug | SPIREDOC-10110 | Fixes the issue that the program threw System.ArgumentOutOfRangeException when loading Doc documents. |
| Bug | SPIREDOC-10111 | Fixes the issue that content was indented when converting Word documents to PDF documents. |
| Bug | SPIREDOC-10119 | Fixes the issue that getting codes in cross-reference fields failed. |
| Bug | SPIREDOC-10132 | Fixes the issue that the program threw System.ArgumentOutOfRangeException when getting FixedLayoutDocument objects in blank documents. |
| Bug | SPIREDOC-10195 | Fixes the issue that the program threw System.NullReferenceException when deleting bookmark content after copying documents. |
Spire.XLS
| Category | ID | Description |
| New feature | SPIREXLS-5036 | Improves the memory usage of converting worksheets to images. |
| New feature | SPIREXLS-5006 | Adds XLT, XLTX, and XLTM formats to the FileFormat enumeration. |
| New feature | SPIREXLS-5038 | Supports setting the clipping position of header and footer images.
sheet.PageSetup.LeftHeaderPictureCropTop=6.15; sheet.PageSetup.LeftHeaderPictureCropBottom=7.15; sheet.PageSetup.LeftHeaderPictureCropLeft =7.15; sheet.PageSetup.LeftHeaderPictureCropRight = 6.15; sheet.PageSetup.LeftFooterPictureCropTop=0.15; sheet.PageSetup.LeftFooterPictureCropBottom=0.15; sheet.PageSetup.LeftFooterPictureCropLeft =0.15; sheet.PageSetup.LeftFooterPictureCropRight =0.15; sheet.PageSetup.CenterHeaderPictureCropTop=0.15; sheet,PageSetup.CenterHeaderPictureCropBottom=0.15; sheet.PageSetup.CenterHeaderPictureCropLeft=0.15; sheet.PageSetup.CenterHeaderPictureCropRight =0.15; sheet.PageSetup.CenterFooterPictureCropTop=0.15; sheet.PageSetup.CenterFooterPictureCropBottom=0.15; sheet.PageSetup.CenterFooterPictureCropLeft =0.15; sheet.PageSetup.CenterFooterPictureCropRight=0.15; sheet.PageSetup.RightHeaderPictureCropTop=0.15; sheet.PageSetup.RightHeaderPictureCropBottom=0.15; sheet.PageSetup.RightHeaderPictureCropLeft=0.15; sheet.PageSetup.RightHeaderPictureCropRight=0.15; sheet.PageSetup.RightFooterPictureCropTop=0.15; sheet.PageSetup.RightFooterPictureCropBottom=0.15; sheet.PageSetup.RightFooterPictureCropLeft=0.15; |
| Bug | SPIREXLS-5016 | Fixed the issue that the program threw System.ArgumentOutOfRangeException when executing sheet.AutoFilters.Clear(). |
| Bug | SPIREXLS-5018 | Fixed the issue that opening the saved XLSX document with MS Excel tool after loading an XLSX document without modifying it and saving it directly to a new XLSX document prompted an error in some of the contents. |
| Bug | SPIREXLS-5022 | Fixed the issue that some contents of the saved XLSX document prompted errors after inserting data into the worksheet and opening the saved XLSX document with MS Excel tool. |
| Bug | SPIREXLS-5023 | Fixed the issue that retrieving cells failed. |
| Bug | SPIREXLS-5025 | Fixed the issue that paging was incorrect after converting Excel to PDF. |
| Bug | SPIREXLS-5028 | Fixed the issue that the content was misplaced after converting Excel to CSV. |
| Bug | SPIREXLS-5032 | Fixed the issue that the text of legend was messy after converting Excel to HTML with .Net Standard package in Linux system. |
| Bug | SPIREXLS-5034 | Fixed the issue that the program threw "No printers are installed" error when loading files under Linux environment. |
| Bug | SPIREXLS-5039 | Fixed the issue that the pivot chart data was incorrect after converting worksheets to pictures. |
| Bug | SPIREXLS-5061 | Fixed the issue that the program threw "Shape failing to render!" error when converting Excel to PDF. |
| Bug | SPIREXLS-5066 | Fixes the issue that the comments in the resulting document were not displayed in Office365 after calling the cellRange.ClearContents() method. |
| Bug | SPIREXLS-5073 | Fixes the issue that when the sheet name contained the special character \t, the \t was read as x0009. |
| Bug | SPIREXLS-5080 | Fixes the issue that the content was incorrect when converting XLSX documents to PDF documents. |
| Bug | SPIREXLS-5083 | Fixes the issue that the application threw "System.ArgumentException" when converting XLSX documents to PDF documents |
| Bug | SPIREXLS-5084 | Fixes the issue that the text content was overlapped when converting XLSX documents to images. |
| Bug | SPIREXLS-5090 | Fixes the issue that the "Operation is not supported on this platform" exception occurred when deploying the .netstand2.0 dlls on the .NET7.0 platform. |
Spire.Presentation
| Category | ID | Description |
| New feature | - | Support embedding fonts in PPTX: only supports embedding fonts into PPTX format, and does not support embedding into PDF and PowerPoint 2003 formats; when embedding Chinese name fonts, the font names are not displayed in Chinese.
ppt.AddEmbeddedFont(string fontpath); |
| New feature | SPIREPPT-2424 | Provides the IsHidden property to determine whether the Ole object is hidden.
OleObjectCollection oles = ppt.Slides[0].OleObjects; OleObject ole= oles[0]; bool result=ole.IsHidden; |
| Adjustment | - | Upgrades the VS2019 project framework to version 4.6.2. |
| Adjustment | - | Removes MonoAndroid and Xamarin.iOS. |
| Adjustment | - | Removes the reference of Spire.Pdf.dll from the product. |
| Adjustment | - | "Spire.Pdf.PdfConformanceLevel" has been deprecated and replaced with the new interface "Spire.Presentation.External.pdf.PdfConformanceLevel".
presentation.SaveToPdfOption.PdfConformanceLevel = Spire.Presentation.External.Pdf.PdfConformanceLevel.Pdf_A1A; |
| Adjustment | - | "Spire.Pdf.Sercurity.PdfSecurity" has been deprecated and replaced with the new interface "Spire.Presentation.External.Pdf.PdfSecurity". |
| Bug | SPIREPPT-2418 | Fixes the issue that the program threw "Microsoft PowerPoint 2007 file is corrpt." exception when loading a PPTX file when the system regional language was set to Turkish. |
| Bug | SPIREPPT-2396 | Fixes the issue that the effect was incorrect after changing the chart label position. |
