Spire.Office 5.3.7

Spire.Office 5.3.7 is released

We're pleased to announce the release of Spire.Office 5.3.7. This version includes some fantastic features, for instance, Spire.PDF supports setting subjects for newly-created PdfFreeTextAnnotation, and Spire.XLS supports setting chart marker's border weight as well as calculating SUBTOTAL formula. At the same time, some issues that occurred when loading, manipulating and converting Word, PDF, Excel and PowerPoint files are successfully fixed. More details are listed in the following content.

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 v8.3.15
  • Spire.Pdf.dll v6.3.11
  • Spire.XLS.dll v10.3.8
  • Spire.Email.dll v3.3.0
  • Spire.DocViewer.Forms.dll v5.1.1
  • Spire.PdfViewer.Forms.dll v5.1.4
  • Spire.PdfViewer.Asp.dll v5.1.4
  • Spire.Presentation.dll v5.3.6
  • Spire.Spreadsheet v4.3.1
  • Spire.OfficeViewer.Forms.dll v5.3.7
  • Spire.Barcode.dll v4.1.1
  • Spire.DataExport.dll v4.1.9
  • Spire.DataExport.ResourceMgr.dll v2.1.0
  • Spire.Common.dll v10.3.8
  • Spire.License.dll v1.3.8
Click the link to get the version Spire.Office 5.3.7:
More information of Spire.Office new release or hotfix:

Here is a list of changes made in this release

Spire.Doc

Category ID Description
Bug SPIREDOC-3866 Fixes the issue that the content format was incorrect when converting Word to PDF.
Bug SPIREDOC-3793
SPIREDOC-3959
Fixes the issue that the application threw an error "This is not a structured storage file".
Bug SPIREDOC-3807 Fixes the issue that the application threw an error "Object reference not set to an instance of an object" when saving to stream.
Bug SPIREDOC-3879 Fixes the issue that the application threw System.ArgumentOutOfRangeException when converting doc to xps.
Bug SPIREDOC-3886 Fixes the issue that the application threw System.FormatException when loading an HTML file.
Bug SPIREDOC-3917 Fixes the issue that the split cells lost the original style.
Bug SPIREDOC-3975
SPIREDOC-4028
Fixes the issue that the content was incorrect when converting Word to PDF.
Bug SPIREDOC-4002 Fixes the issue that the application threw FormatException when updating TOC.
Bug SPIREDOC-4003 Fixes the issue that the TOC content was incorrect after updating TOC.
Bug SPIREDOC-4004 Fixes the issue that the application hung when updating the merged field including "=SUM(a1,a2)" formula.
Bug SPIREDOC-4015 Fixes the issue that the hyperlink to the image inside it was changed after cloning paragraph.
Bug SPIREDOC-4020 Fixes the issue that the application threw System.ArgumentException when converting Word to PDF.
Bug SPIREDOC-4037 Fixes the issue that extra text was extracted when extracting text.
Bug SPIREDOC-4045 Fixes the issue that the application threw System.ArgumentOutOfRangeException when loading a doc file.

Spire.PDF

Category ID Description
New Feature SPIREPDF-3107 Supports setting subjects for newly-created PdfFreeTextAnnotation.
RectangleF rectangle = new RectangleF(0, 150, 100, 30);
PdfFreeTextAnnotation textAnnotation = new PdfFreeTextAnnotation(rectangle);
textAnnotation.Text = "Spire.PDF";
textAnnotation.Subject = "test";
Bug SPIREPDF-3016 Fixes the issue that the bookmark containing "-" was not displayed correctly.
Bug SPIREPDF-3069 Fixes the issue that text couldn't be matched using regular expressions.
Bug SPIREPDF-3091 Fixes the issue that application threw ArgumentException when converting pdf to image.
Bug SPIREPDF-3094 Fixes the issue that the count of form fields read was incorrect.
Bug SPIREPDF-3096 Fixes the issue that the bookmark containing "" was not displayed correctly.
Bug SPIREPDF-3119 Fixes the issue that it failed to save document after setting custom information.

Spire.Presentation

Category ID Description
Bug SPIREPPT-1064 Fixes the issue that the application threw NullReferenceException when loading a PPTX file.
Bug SPIREPPT-1067 Fixes the issue that the application threw NullReferenceException when adding hyperlink to SmartArt node.
Bug SPIREPPT-1075 Fixes the issue that after copying the slides to the new PPSX document, a dialog box showing "Whether the contents are saved or not" popped up when opening document.
Bug SPIREPPT-1083 Fixes the issue that the images were missing when converting PPT to PDF.
Bug SPIREPPT-1091 Fixes the issue that the application threw ArgumentException when loading a PPTX file.
Bug SPIREPPT-1097 Fixes the issue that the [br] tag was not parsed correctly.

Spire.XLS

Category ID Description
New Feature SPIREXLS-1998 Supports setting chart marker's border weight.
chart.Series[0].DataFormat.MarkerBorderWeight = 2.5; //the unit is pt
New Feature SPIREXLS-2163 Supports calculating SUBTOTAL formula.
Bug SPIREXLS-2008 Fixes the issue that it failed to open output excel after setting time data validity.
Bug SPIREXLS-2015 Fixes the issue that the value of the chart pointer was lost when creating a meter chart.
Bug SPIREXLS-2020 Fixes the issue that it failed to set conditional format of the date.
Bug SPIREXLS-2023 Fixes the issue that it failed to remove hyperlinks of text.
Bug SPIREXLS-2026 Fixes the issue that it failed to set page order type.
Bug SPIREXLS-2029 Fixes the issue that it failed to unlock the protected worksheet.
Bug SPIREXLS-2031 Fixes the issue that it failed to hide/show sheet tab.
Bug SPIREXLS-2032 Fixes the issue that the incorrect version of the excel document was detected.
Bug SPIREXLS-2076 Fixes the issue that the coordinate axis value was incorrect when converting PivotChart to images.
Bug SPIREXLS-2121 Fixes the issue that the alignment of text was incorrect when converting excel to pdf.
Bug SPIREXLS-2162 Fixes the issue that the data source of chart was incorrect after using CopyFrom() method to copy sheet including a chart.
Bug SPIREXLS-2175 Fixes the issue that formula value was incorrect after calculating formula.
Bug SPIREXLS-2027 Fixes the issue that it failed to set the order of PivotTable fields.