Spire.Office 3.6.0 is released

With the great effort of our Dev team, Spire.Office version 3.6.0 is released today. This update brings a few subtle but useful features, such as Spire.Spreadsheet supports to load an encrypted Excel file, Spire.PDF supports to set font color for signature content. Also, this latest version has fixed numerous bugs to improve the stability and performance.

In this version, the most recent version of Spire.Doc, Spire.PDF, Spire.XLS, Spire.Presentation, Spire.Email, Spire.DataExport, Spire.Barcode, Spire.DocViewer, Spire.PDFViewer and Spire.OfficeViewer are included.

Versions:

• Spire.Doc.dll v6.6.1
• Spire.Pdf.dll v4.5.9
• Spire.XLS.dll v8.6.1
• Spire.Email.dll v1.3.2
• Spire.DocViewer.Forms.dll v3.4.2
• Spire.PdfViewer.Forms.dll v3.5.3
• Spire.PdfViewer.Asp.dll v3.5.3
• Spire.Presentation.dll v3.5.5
• Spire.Spreadsheet v2.5.2
• Spire.OfficeViewer.Forms.dll v3.6.0
• Spire.DataExport.dll v3.5.131
• Spire.DataExport.ResourceMgr.dll v1.6.71
• Spire.Common.dll v1.2.792
• Spire.License.dll v1.3.6
• Spire.Barcode v2.3.0

Details about the new features and bug fixes:

Spire.Doc

Bug fixes:

• Fixes the issue that the generated Epub did not meet a criterion when converting Word to Epub.
• Fixes the issue that the application hung when converting Word to PDF.
• Fixes the issue that the image field could not get updated in Word after replacing the picture of this field with Spire.Doc.
• Fixes the issue that the application threw "Index was out of range" exception when converting Word to PDF.
• Fixes the issue that the colspan and rowspan of the table became incorrect after saving to HTML.
• Fixes the issue that the image turned out to be in wrong position after printing the Word document.
• Fixes the issues that the application threw exception when using "UpdateTableOfContents" and the “HorizontalAlignment” setting gave an incorrect format.
• Fixes the issue that the application threw "ArgumentOutOfRangeException" exception when converting Word to XPS.

Spire.XLS

Bug Fixes:

• Fixes the issue that the content was cut, the checkbox disappeared and the resolution of logo on first page became lower when converting Excel to Pdf.
• Fixes the issue that setting ResizeBehave property had no effect.
• Fixes the issue that caused NullReferenceException after deleting column.
• Fixes the issue that the HideItem method of PivotTable didn't work.
• Fixes the issue that the image lost after adding filter.

Spire.PDF

New features:

• Adds a new property "SignFontColor" to support the font color setting for the signature content.

public Color SignFontColor { set; }

• Changes the class name of "PdfGridCellTextAndStyleList" to"PdfGridCellContentList" and updates the code annotation.
• Changes the class name of "PdfGridCellTextAndStyle" to"PdfGridCellContent" and updates the code annotation.

Bug Fixes:

• Fixes the issue that caused OutOfMemoryException when converting PDF to Image.
• Fixes the issue that the chart content was lost after printing PDF.
• Fixes the issue that caused OutOfMemoryException when removing layers.
• Fixes the issue that the signature panel wrongly displayed "signed by" after the signature was certificated.
• Fixes the issue that incorrect text was added when adding Code 128C barcode to PDF.
• Fixes the issue that the text was offset when converting XPS to PDF.
• Fixes the issue that the result was blurred when printing a PDF.
• Fixes the issue that the generated PDF could not be opened when converting EMF to PDF.
• Fixes the issue that the settign of italic and bold font style for the PdfFreeTextAnnotation content did not make any sense.
• Fixes the issue that half page became black when printing a PDF.
• Fixes the issue that the generated PDF could not be opened when merging this PDF with any other PDFs.
• Fixes the issue that the applictaion threw an "Index was out of range" exception when converting PDF to Word.
• Fixes the issue that the pictures got removed when converting PDF to XPS.
• Fixes the issue that the image background color wrongly became blue when merging PDF files.
• Fixes the issue that the generated PDF could not be opened when duplicating a PDF.

Spire.Spreadsheet

New features:

• Add a new property "Password" supporting the loading of an encrypted Excel, the statement should be before the loading step.

public string Password { get; set; }

Bug fixes:

• Fixes the issue that the margins of the output document turned out to be incorrect when loading and saving an Excel document.
• Fixes the issue that the group content could not completely display when loading an Excel which contains a group.
• Fixes the issue that the chart got lost after saving the document.
• Fixes the issue that the an pop-up would wrongly appear when clicking a cell which has a hyperlink.