Spire.Office 5.8.5

Spire.Office 5.8.5 is released

We're pleased to announce the release of Spire.Office 5.8.5. This version supports some new features, such as Spire.Doc supports adds a comparison functionality, Spire.Presentation supports adding sections and setting the style of outline lines of the SmartArt node, Spire.PDF supports chart when converting PDF to Excel. Moreover, some issues that occurred when converting Word to PDF/ Epub, Excel to PDF, PPT to PDF, XPS to PDF, updating PivotTable, merging PDF documents and extracting text from PDF file are fixed successfully. See the content below for more details.

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.8.2
  • Spire.Pdf.dll v6.8.5
  • Spire.XLS.dll v10.8.3
  • Spire.Email.dll v3.6.7
  • Spire.DocViewer.Forms.dll v5.1.1
  • Spire.PdfViewer.Forms.dll v5.8.2
  • Spire.PdfViewer.Asp.dll v5.8.2
  • Spire.Presentation.dll v5.8.1
  • Spire.Spreadsheet v4.5.0
  • Spire.OfficeViewer.Forms.dll v5.8.5
  • Spire.Barcode.dll v4.7.0
  • Spire.DataExport.dll v4.1.9
  • Spire.DataExport.ResourceMgr.dll v2.1.0
  • Spire.Common.dll v10.8.5
  • Spire.License.dll v1.3.8
Click the link to get the version Spire.Office 5.8.5:
More information of Spire.Office new release or hotfix:

Here is a list of changes made in this release

Spire.Doc

Category ID Description
New Feature - Adds a comparison functionality.
Document doc1 = new Document();
doc1.LoadFromFile(inputFile2);
Document doc2 = new Document();
doc2.LoadFromFile(inputFile1);
doc1.Compare(doc2, "summer");
doc1.SaveToFile(outputFile);
doc1.Dispose();
Adjustment - Adds the interface ICompositeObject under the class ShapeGroup.
Adjustment - Deletes the interface ICompositeObject from the class ShapeBase.
Bug SPIREDOC-4455 Fixes the issue that caused incorrect linefeed after converting Word to PDF.
Bug SPIREDOC-4564 Fixes the issue that the applied heading style was missing in Style tools when displaying.
Bug SPIREDOC-4667 Fixes the issue that the result document prompted errors when opening after saving the file.
Bug SPIREDOC-4670 Fixes the issue that the application threw "ExternalException" when converting Word to Epub.
Bug SPIREDOC-4811 Fixes the issue that the application threw "NullReferenceException" when converting Word to PDF.
Bug SPIREDOC-4820 Fixes the issue that the application threw "XmlException" when applying html string.
Bug SPIREDOC-4821 Fixes the issue that the picture field showed blank picture when merging values were null.
Bug SPIREDOC-4842 Fixes the issue that the table borders were deleted after using the code.
table.TableFormat.Positioning.ClearFormatting().

Spire.XLS

Category ID Description
Bug SPIREXLS-2404 Fixes the issue that a content error appeared when Excel opens the file after updating PivotTable.
Bug SPIREXLS-2485 Fixes the issue that a content error appeared when Excel opens the file after loading an .xlsx file and then saving to new file.
Bug SPIREXLS-2493 Fixes the issue that the application threw an error "Error in calculating cell B2 in Worksheet Sheet1" when converting Excel to PDF.
Bug SPIREXLS-2507 Fixes the issue that the application threw "InvalidCastException" when saving to an .xls file.
Bug SPIREXLS-2509 Fixes the issue that the number format was incorrect when converting Excel to PDF in German system.
Bug SPIREXLS-2535 Fixes the issue that the formula value was incorrect when converting Excel to PDF.

Sprie.Presentation

Category ID Description
Bug SPIREPPT-1107 Fixes the issue that the line position was incorrect when converting PPT to PDF.
Bug SPIREPPT-1214 Fixes the issue that the application threw System.NullReferenceException when loading a PPTX document.
Bug SPIREPPT-1219 Fixes the issue that setting the duration for animation didn't take effect.
New Feature SPIREPPT-1241 Supports adding sections.
Presentation presentation = new Presentation();
presentation.LoadFromFile(pptfile);
ISlide slide = presentation.Slides[0];
//Add section 
presentation.SectionList.Add("section1", slide);
//Get section
Section section;
String name;
  for (int i = 0; i < presentation.SectionList.Count; i++)
    {
      section  = presentation.SectionList[i];
      name = section.Name;
         foreach (long id in section.SlideIdList)
          {
           }
     }
New Feature SPIREPPT-1236 Supports setting the style of outline lines of the SmartArt node.
ISmartArt smartArt = presentation.Slides[0].Shapes[0] as ISmartArt;
int count =smartArt.Nodes.Count;
ISmartArtNode node;
  for (int i = 0; i < count; i++)
    {
    node = smartArt.Nodes[i];
    node.Line.FillType = FillFormatType.Solid;
    node.Line.SolidFillColor.Color = Color.Gray;
    node.Line.Width = 2;
    }
New Feature SPIREPPT-1237 Supports setting the style of the lines between the SmartArt nodes.
ISmartArt smartArt = presentation.Slides[0].Shapes[0] as ISmartArt;
int count =smartArt.Nodes.Count;
ISmartArtNode node;
  for (int i = 0; i < count; i++)
    {
    node = smartArt.Nodes[i];
    node.LinkLine.FillType = FillFormatType.Solid;
    node.LinkLine.SolidFillColor.Color = Color.Gray;
    node.LinkLine.Width = 2;
    node.LinkLine.DashStyle = LineDashStyleType.SystemDash;
    }
Bug SPIREPPT-1230 Fixes the issue that some content was missing when converting PPT to PDF.

Spire.PDF

Category ID Description
Bug SPIREPDF-1243 Fixes the issue that the found text was not highlighted successfully.
Bug SPIREPDF-1262 Fixes the issue that the character lost after converting xps to pdf.
Bug SPIREPDF-3292 Fixes the issue that the obtained bookmark name was messy.
Bug SPIREPDF-3323 Fixes the issue that the application threw the "FormatException " when getting attachments of PDF document
Bug SPIREPDF-3355 Fixes the issue that when drawing grids, one row with many content were not drawn in sequence and jumped directly to the next page.
Bug SPIREPDF-3393 Fixes the issue that the application hung when load PDF document.
Bug SPIREPDF-3395 Fixes the issue that the application threw the "NullReferenceException" when merging PDF documents.
Bug SPIREPDF-3396 Fixes the issue that the application threw the "format error" when loading PDF document.
Bug SPIREPDF-3399 Fixes the issue that the page break lost after extracting text from PDF document.
Bug SPIREPDF-3405 Fixes the issue that the finding text with regex didn't return complete results.
New Feature - Supports chart when converting PDF to Excel
Bug SPIREPDF-3410 Fixes the issue that the text was not fully displayed when printing PDF.
Bug SPIREPDF-3415 Fixes the issue that the application threw an error "System.NullReferenceException" when drawing page content using page.CreateTemplate().Draw(PdfCanvas graphics, PointF location) method.
Bug SPIREPDF-3438 Fixes the issue that the number of images retrieved was incorrect.
Bug SPIREPDF-817 Fixes the issue that it failed to convert PDF to images after filling radiobutton field.
Bug SPIREPDF-1277 Fixes the issue that the location of content was incorrect when converting PDF to images.
Bug SPIREPDF-2797 Fixes the issue that the application threw Win32Exception when printing PDF.
Bug SPIREPDF-3426 Fixes the issue that the application threw an error "export private key failed" when using USB Certificate Token to add enabled LTV signature.
Bug SPIREPDF-3432 Fixes the issue that the position of borders of nested grid was incorrect when paging.
Bug SPIREPDF-3437 Fixes the issue that file size increased after splitting and merging files.
Bug SPIREPDF-3440 Fixes the issue that the application threw System.OutOfMemoryException when loading file.
Bug SPIREPDF-3463 Fixes the issue that the content was missing when printing PDF.
Bug SPIREPDF-472 Fixes the issue that the size of spool file was large after printing.
Bug SPIREPDF-590 Fixes the issue that Persian and Arabic text cannot be found.
Bug SPIREPDF-599 Fixes the issue that the result file prompted an error with extended features when opening in Adobe after filling fields.
Bug SPIREPDF-635 Fixes the issue that the text cannot be drawn on the PDF.
Bug SPIREPDF-992 Fixes the issue that the position of text was improper after filling fields.
Bug SPIREPDF-1288 Fixes the issue that the result file cannot be opened after replacing text.
Bug SPIREPDF-3249 Fixes the issue that the application threw "NullReferenceException" when setting the parameter CompressionQuality in the method DrawImage
Bug SPIREPDF-3296 Fixes the issue that the content was incorrect after converting XPS to PDF.
Bug SPIREPDF-3421 Fixes the issue that the result file was damaged after repeatedly filling fields.
Bug SPIREPDF-3458 Fixes the issue that the text cannot be found when using Regex.
Bug SPIREPDF-3464 Fixes the issue that the application threw "ArgumentException" when using the method ApplyRecoverString.
Bug SPIREPDF-3474 Fixes the issue that the application threw "NullReferenceException" when converting PDF to image.