Spire.Office 4.10.0

Spire.Office 4.10.0 is released

We're pleased to annouce the release of Spire.Office 4.10.0. This version brings some new features, for instance, Spire.PDF supports to extract the embedded U3D model from a PDF file, Spire.PDF supports to open cross-document in a new window, and Spire.Doc supports to get and set emphasize mark. Meanwhile, a large number of issues have been fixed by this update. More details are as follows.

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.10.7
  • Spire.Pdf.dll v5.10.11
  • Spire.XLS.dll v9.10.18
  • Spire.Presentation.dll v4.10.4
  • Spire.Email.dll v2.9.3
  • Spire.DocViewer.Forms.dll v4.5.15
  • Spire.PdfViewer.Forms.dll v4.10.3
  • Spire.PdfViewer.Asp.dll v4.10.3
  • Spire.Spreadsheet.dll v3.10.1
  • Spire.OfficeViewer.Forms.dll v4.10.0
  • Spire.Barcode.dll v3.7.0
  • Spire.DataExport.dll v4.1.9
  • Spire.DataExport.ResourceMgr.dll v2.1.0
  • Spire.Common.dll v2.9.20
  • Spire.License.dll v1.3.7

Click the link to get the version Spire.Office 4.10.0:
More information of Spire.Office new release or hotfix:

Spire.PDF

New Features:

  • Supports extracting embedded U3D model from .PDF to .U3D file.
  • PdfAnnotationCollection annot = doc.Pages[0].AnnotationsWidget;
    int count = 0;
    for (int i = 0; i < annot.Count; i++)
    {
        if (annot[i] is Pdf3DAnnotation)
        {
              Pdf3DAnnotation annot3D = annot[i] as Pdf3DAnnotation;
              byte[] bytes = annot3D._3DData;
              if (bytes != null)
                  {
                      File.WriteAllBytes(String.Format("result-{0}.u3d", count), bytes);
                      count++;
                  }    
         }
    }
    
  • Adds the IsNewWindow property to open cross-document in new window.
  • //Open file in new window
    launchAction.IsNewWindow = true;
    //Open file in current window
    launchAction.IsNewWindow = false;
    

Bug Fixes:

  • Fixes the issue that the gradient was incorrect after converting XPS to PDF.
  • Fixes the issue that the data was not showed after filling form fields.
  • Fixes the issue that the result was blank after printing.
  • Fixes the issue that the application threw the NullReferenceException when converting PDF to images.
  • Fixes the issue that the application threw the NullReferenceException when executing pdfDocument.InsertPage(pdf, 0) method.
  • Fixes the issue that the location of polygon annotation could not be obtained correctly.
  • Fixes the issue that caused incorrect content after encrypting PDF document.
  • Fixes the issue that caused incorrect location after inserting pages by index.
  • Fixes the issue that the text lost after converting XPS to PDF.
  • Fixes the issue that failed to find text.
  • Fixes the issue that the application threw the exception "No object reference was set to the object instance" when getting PDF form.
  • Fixes the issue that the application threw the exception "No object reference was set to the object instance" when extracting PDF attachment.

Spire.Presentation

Bug Fixes:

  • Some optimizations have been made for the time to save PPTX on the Windows10.
  • Fixes the issue that caused the exception "Index was out of range" when saving PPTX on .NET Core application.
  • Fixes the issue that caused incorrect content format after converting PPT to PDF.
  • Fixes the issue that caused the exception "Error reading tags" when loading PPT file.

Spire.XLS

New Features:

  • Adds two parameters"horizontal:right_to_left" and "vertical:bottom_to_top" for Marker Designer to set orientation when inserting data.
  • //add in original file, the data will be inserted from the bottom to the top in vertical orientation.
    &=Country.Capital(vertical:bottom_to_top,add:styles)
    // add in original file, the data will be inserted from the right to the left in horizontal orientation.
    &=Country.Capital(horizontal:right_to_left,add:styles)
    

Bug Fixes:

  • Fixes the issue that there were empty additional columns after saving .xls to .xlsx.
  • Fixes the issue that the content was cut off after converting Excel to PDF.
  • Fixes the issue that the application threw the NullReferenceException when loading a .xlsx file.
  • Fixes the issue that the application threw an exception when converting an Excel file which contains Pivot Table to PDF or HTML.
  • Fixes the issue that the number format and the rules of conditional formatting were wrong after converting an Excel file which contains Pivot Table to PDF or HTML.
  • Fixes the issue that the application threw XmlException when loading an Excel file.
  • Fixes the issue that the links placed in the pictures were missing after converting Excel to PDF.
  • Fixes the issue that there were extra blank columns after converting .xlt to .xlsx file.
  • Fixes the issue that the application threw OverflowException when loading a .xlsm file.

Spire.SpreadSheet

Adjustment:

  • Adjusts that the Locked property of the cell in which the initialized SpreadSheet is changed from false to true by default.

Bug Fixes:

  • Fixes the issue that only the last sheet tab is displayed when dragging horizontal bar.
  • Fixes the issue that all sheet tabs still are not displayed completely when the SpreadSheet window is wide enough.

Spire.Doc

New Features:

  • Supports to get and set emphasis mark.
  • TextRange.CharacterFormat.EmphasisMark
    

Bug Fixes:

  • Fixes the issue that format was incorrect after converting Word to PDF.
  • Fixes the issue that the content of TOC was missing after using the code doc.UpdateTableOfContents.
  • Fixes the issue that the height of table was reduced after converting Word to PDF.
  • Fixes the issue that the table border was incomplete after merging cells and converting to PDF.
  • Fixes the issue that the application threw the InvalidOperationException when converting Word to PDF.
  • Fixes the issue that the macros were not removed successfully.
  • Fixes the issue that the content was missing after converting Word to PDF.
  • Fixes the issue that the font color changed after converting Word to PDF.
  • Fixes the issue that the application threw the IndexOutOfRangeException when loading a Word file.
  • Fixes the issue that the application threw the OutOfMemoryException when loading a Word file.
  • Fixes the issue that the application threw the NullReferenceException when converting Word to image.
  • Fixes the issue that caused incorrect alignment after doing mail merge.