Spire.Office

Spire.Office 4.5.1 is released

We are pleased to announce that Spire.Office 4.5.1 is released today. This version adds some new features, such as Spire.Presentation supports saving a PowerPoint file as PowerPoint 2003 format, Spire.Doc supports signing Word with digital signature, Spire.PdfViewer supports Move() method to move a new location from current location. Besides, some bugs that occurred when converting Word to PDF, merging Word/PDF files, filling Textbox field, converting Html to PDF, and converting Excel to image are fixed. Moreover, speed of loading a Excel file which contains EMF is optimized. See the content below for more details.

In this version, the most recent version 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 Version:

  • Spire.Doc.dll v7.5.5
  • Spire.Pdf.dll v5.5.10
  • Spire.XLS.dll v9.5.5
  • Spire.Presentation.dll v4.5.1
  • Spire.Email.dll v2.4.2
  • Spire.DocViewer.Forms.dll v4.4.3
  • Spire.PdfViewer.Forms.dll v4.5.4
  • Spire.PdfViewer.Asp.dll v4.5.4
  • Spire.Spreadsheet v3.5.1
  • Spire.OfficeViewer.Forms.dll v4.5.1
  • Spire.Barcode.dll v3.4.0
  • Spire.DataExport.dll v4.1.9
  • Spire.DataExport.ResourceMgr.dll v2.1.0
  • Spire.Common.dll v2.5.5
  • Spire.License.dll v1.3.7
Click the link to get the version Spire.Office 4.5.1:
More information of Spire.Office new release or hotfix:

Spire.Email

Bug Fixes:

  • Fixes the issue that the attachments could not be added in .msg after applying license.

Spire.Spreadsheet

Bug Fixes:

  • Fixes an issue that there were additional rows when displaying.

Spire.Presentation

New Features:

  • Supports saving a PowerPoint file as PowerPoint 2003 format.

Spire.Doc

New Features:

  • Supports signing .doc / .docx with digital signature, yet only the .pfx certificate is supported. And the feature is not supported in .Net Standard / .Net Core.
  • public void SaveToFile(string fileName, FileFormat fileFormat, byte[] certificateData, string securePassword);
    public void SaveToFile(string fileName, FileFormat fileFormat, string certificatePath, string securePassword);
    public void SaveToStream(Stream stream, FileFormat fileFormat, byte[] certificateData, string securePassword);
    public void SaveToStream(Stream stream, FileFormat fileFormat, string certificatePath, string securePassword);
    //Also supports signing by calling Document class.
    public static byte[] Sign(Stream sourceStream, byte[] certificateData, string securePassword);
    public static byte[] Sign(Stream sourceStream, string certificatePath, string securePassword);
    

Alteration:

  • document.Styles.ApplyDocDefaultsToNormalStyle() method has been marked as obsolete, using document.KeepSameFormat = true instead.

Bug Fixes:

  • Fixes the issue that the character spacing was changed when merging documents.
  • Fixes the issue that the numbering format was changed when converting a .docx document to PDF.
  • Fixes the issue that the image in the combined shape could not be obtained.
  • Fixes the issue that the application threw an error "index out of range" when loading a doc document.
  • Fixes the issue that the formula field "=SUM(ABOVE)" update failed.

Spire.PDF

Bug Fixes:

  • Fixes the issue that caused ArgumentException when printing.
  • Fixes the issue that PDF/X that was converted from Word could not be validated correctly in the Adobe Reader.
  • Fixes the issue that caused overlapped text after converting PDF to Word.
  • Fixes the issue that the checkbox and signature had problems after signing.
  • Fixes the issue that caused incorrect text after filling Textbox field.
  • Fixes the issue that the images became black after merging files.
  • Fixes the issue that the content were messy after converting HTML to PDF.
  • Fixes the issue that the read-only fields cannot be deleted.
  • Fixes the issue that caused "NullReferenceException" when obtaining UsedFonts.
  • Fixes the issue that caused "NullReferenceException" when saving PDF page as images.
  • Fixes the issue that the text could not be found.
  • Fixes the issue that when signing on an existing signature field, the properties of PdfSignature instance had problems.
  • Fixes the issue that the table format is incorrect once the merged rows of PDF gird exceed one page.
  • Fixes the issue that caused messy content after converting PDF to image.
  • Fixes the issue that the application threw the "NullReferenceException" when extracting text from PDF pages.

Spire.XLS

Optimizations:

  • Improves the speed of loading a file which contains EMF.

Bug Fixes:

  • Fixes the issue that the application threw an exception when saving a sheet which contains 3d pie chart to SVG.
  • Fixes the issue that MS excel hinted a problem when opening the result file after adding a pivot table.
  • Fixes the issue that the progress threw an exception "ArgumentOutOfException" when loading a file.
  • Fixes the issue that the progress threw an exception "ArgumentOutOfException" when saving sheet to image.
  • Fixes the issue that the content exceeded the cell after converting Excel to PDF.
  • Fixes the issue that the application threw an exception "OverflowException" when converting chart to image.
  • Fixes the issue that a cell was filled wrong color for a new file.
  • Fixes the issue that the content of some rows were lost after converting sheet to image.
  • Fixes the issue that getting the page number of worksheet returned incorrect data.
  • Fixes the issue that after adding background image and then saving to Version97to2003 format, the generated .xls had problems on content.
  • Fixes the issue that the application threw “OverflowException” when loading an Excel.
  • Fixes the issue that the superscript was incorrect after saving an Excel to image.
  • Fixes the issue that the application threw an error "XXX is not valid named range" when executing InsertArray method.
  • Fixes the issue that the application threw an error "Input string was not in a correct format" when loading an Excel.
  • Fixes the issue that the conditional format was lost after converting worksheet to HTML.

Spire.PdfViewer

New Features:

  • Adds Move(float offsetX, float offsetY) method to move a new location from current location.
  • Adds ScrollTo(float scrollLocationX, float scrollLocationY) method to scroll to the designated location.

Bug Fixes:

  • Fixes the issue that the application threw the exception "StackOverflowException" when loading a pdf file.
  • Fixes the issue that the content is garbled when viewing a pdf file.

Alteration:

  • LoadFromHtml(string url, string convertPdfName) method may be removed in the future.
  • Threshold property may be removed in the future.
  • MultiPagesThreshold property may be removed in the future.
  • VeryfyDocumentEncrypted(string filePath)method may be removed in the future,please use the method of IsEncryptedDocument()instead.
  • SetViewerMode(PdfViewerMode.PdfViewerMode mode) method may be removed in the future,please use the property of PdfDocumentViewer.ViewerMode instead.
  • SetPageLayoutMode(PageLayoutMode pageMode) method may be removed in the future,please use the property of PdfDocumentViewer.PageLayoutMode instead.
  • ZoomTo(int percentage) method and SetZoom(ZoomMode mode) method may be removed in the future,please use the property of PdfDocumentViewer.ZoomFactor instead.
  • PdfLoaded event may be removed in the future,please use DocumentOpened event instead.
  • ZoomChanged event may be removed in the future,please use ZoomFactorChanged instead.
  • ZoomFator property may be removed in the future,please use the property of PdfDocumentViewer.ZoomFactor instead.
  • Initialize(PdfDocumentViewer view) method may be removed in the future,please use the property of ActiveView instead.