Spire.Office 5.9.2

Spire.Office 5.9.2 is released

We're pleased to announce the release of Spire. Office 5.9.2. This version brings some new features, for examaple, Spire.Presentation supports adding or removing slides in a section, Spire.Presentation supports remving sections from a PowerPoint document, and Spire.XLS supports hiding the view of XLSX file. Meanwhile, a large number of bugs have been fixed by this release. More details are given 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.

  • Spire.Doc.dll v8.9.6
  • Spire.Pdf.dll v6.9.6
  • Spire.XLS.dll v10.9.5
  • Spire.Email.dll v3.6.7
  • Spire.DocViewer.Forms.dll v5.1.1
  • Spire.PdfViewer.Forms.dll v5.9.0
  • Spire.PdfViewer.Asp.dll v5.9.0
  • Spire.Presentation.dll v5.9.2
  • Spire.Spreadsheet v4.5.0
  • Spire.OfficeViewer.Forms.dll v5.9.2
  • Spire.Barcode.dll v4.7.0
  • Spire.DataExport.dll v4.1.9
  • Spire.DataExport.ResourceMgr.dll v2.1.0
  • Spire.Common.dll v10.9.5
  • Spire.License.dll v1.3.8
Click the link to get the version Spire.Office 5.9.2:
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-1617 Fixes the issue that the application threw "System.ArgumentOutOfRangeException" when extracting pictures.
Bug SPIREPDF-3373 Fixes the issue that the spaces were missing when extracting Arabic text.
Bug SPIREPDF-3489 Fixes the issue that content was duplicated when printing PDF.
Bug SPIREPDF-3526 Fixes the issue that for the nested grid, the format was incorrect after setting rowspan (such as grid2.Rows[0].Cells[0].RowSpan = 2).
Bug SPIREPDF-3532 Fixes the issue that Arabic characters could not be found in PDF documents with mixed Arabic and English characters.

Spire.Presentation

Category ID Description
New Feature SPIREPPT-1253 Adds "Insert" and "Append" new methods to add section.
Section sect01 = ppt.SectionList.Insert(0, "section1");
Section sect02 = ppt.SectionList.Append("section2");
New Feature SPIREPPT-1253 Supports adding slides to the section, moving and removing slides in the section.
ISlide slide01 = ppt.Slides.Append();
ISlide slide02 = ppt.Slides.Append();

Section section01 = ppt.SectionList.Add("section1", slide01);
Section section02 = ppt.SectionList.Insert(1, "section2");
Section section03 = ppt.SectionList.Append("section3");

//Add slides
ISlide slide03 = ppt.SectionList.InsertSlide(section02, 0, slide01);
ISlide slide04 = section02.Insert(1, slide02);
section02.AddRange(new ISlide[] { slide03, slide04 });

//Move slides 
ppt.SectionList.MoveSlide(section03, 0, slide03); 
section03.Move(1, slide04);

//Remove slides
ppt.SectionList.RemoveSlide(section03, 0);
section01.RemoveAt(0);
section02.RemoveRange(0, 3);
section03.Remove(slide04);
New Feature SPIREPPT-1254 Supports getting the index of the section.
int index1 = ppt.SectionList.IndexOf(section01);
int index2 = section02.Index;
New Feature SPIREPPT-1288 Supports removing sections from PPT files.
ppt.SectionList.RemoveAt(1);
ppt.SectionList.RemoveAll();
Bug SPIREPPT-1251 Fixes the issue that the application threw "NullReferenceException" when loading the file.
Bug SPIREPPT-1256
SPIREPPT-1271
Fixes the issue that add sections to PPT file failed.
Bug SPIREPPT-1267 Fixes the issue that the content was missing after converting PPT to PDF.
Bug SPIREPPT-1272 Fixes the issue that an error prompted when opening the result file after setting the properties for the .potm file.
Bug SPIREPPT-1274 Fixes the issue that the application threw "NullReferenceException" when setting the style of outline lines for newly added SmartArt nodes.
Bug SPIREPPT-1276 Fixes the issue that an error prompted when opening the result file after modifying the chart data of the PPT file.

Spire.XLS

Category ID Description
New Feature SPIREXLS-2605 Supports hiding the view of xlsx file. (xls file doesn't support it.)
workbook.IsHideWindow = true; 
Optimization SPIREXLS-2631 Optimizes the time to insert/delete rows
Bug SPIREXLS-2337 Fixes the issue that there was extra borders when converting .xlsx to pdf.
Bug SPIREXLS-2405 Fixes the issue that the PivotTable's order was wrong when converting .xlsx to pdf.
Bug SPIREXLS-2405 Fixes the issue that the content was incorrect when converting .xltx to pdf
Bug SPIREXLS-2564 Fixes the issue that the application threw System.ArgumentOutOfRangeException when removing password protection.
Bug SPIREXLS-2576 Fixes the issue that setting the percentage format of data field in the PivotTable was invalid.
Bug SPIREXLS-2586
SPIREXLS-2606
Fixes the issue that the content was incorrect when converting .xlsx to pdf.
Bug SPIREXLS-2598 Fixes the issue that the application threw "Invalid sectionId of Header Footer image" when converting .xlsx to pdf.
Bug SPIREXLS-2604 Fixes the issue that the application threw "Data format error. NameRecord" when loading file.
Bug SPIREXLS-2604 Fixes the issue that the application threw System.ApplicationException"Mso Record identification code is wrong(zero)" when loading file
Bug SPIREXLS-2659 Fixes the issue that MS Excel failed to open .xltm file and .xltx file after setting document properties.
Bug SPIREXLS-2684 Fixes the issue that the application threw "the input string's format is incorrect" when converting sheet to pdf.
Bug SPIREXLS-2687 Fixes the issue that there was extra content when converting .xls to pdf.
Bug SPIREXLS-2694 Fixes the issue that the application threw "System.FormatException" when loading file.

Spire.Doc

Category ID Description
Bug SPIREDOC-4030 Fixes the issue that the content was missing after converting Word to PDF.
Bug SPIREDOC-4777 Fixes the issue that it caused incorrect page numbers after converting Word to PDF.
Bug SPIREDOC-4822 Fixes the issue that the application threw "ArgumentException" when loading the file.
Bug SPIREDOC-4836 Fixes the issue that it caused incorrect chart content after converting Word to PDF.
Bug SPIREDOC-4867 Fixes the issue that the color set when adding watermark did not take effect.
Bug SPIREDOC-4889 Fixes the issue that it caused incorrect table border after converting Word to PDF.
Bug SPIREDOC-4891 Fixes the issue that the application was hung when converting Word to PDF.
Bug SPIREDOC-4909 Fixes the issue that the content was incorrect after updating the TOC of Word Document and then converting it to PDF.
Bug SPIREDOC-4914 Fixes the issue that the application threw "NullReferenceException" when converting Word to images.