Spire.Office

Spire.Office 3.7.0 is released

With the great effort of our Dev team, Spire.Office version 3.7.0 is released today. This version includes some wonderful new features, such as Spire.PDF supports to remove rows or columns from PdfGrid, Spire.XLS supports to delete filter from pivot table, Spire.Presentation supports to group shapes, Spire.Spreadsheet supports to undo the action of deleting a row etc. Meanwhile, this update also contains numerous bug fixes to improve the stability and performance.

In this version, the most recent version of Spire.Doc, Spire.PDF, Spire.XLS, Spire.Presentation, Spire.Email, Spire.DataExport, Spire.Barcode, Spire.DocViewer, Spire.PDFViewer and Spire.OfficeViewer are included.

Versions:

  • Spire.Doc.dll v6.7.5
  • Spire.Pdf.dll v4.7.6
  • Spire.XLS.dll v8.7.2
  • Spire.Email.dll v1.3.2
  • Spire.DocViewer.Forms.dll v3.7.0
  • Spire.PdfViewer.Forms.dll v3.6.3
  • Spire.PdfViewer.Asp.dll v3.6.3
  • Spire.Presentation.dll v3.6.9
  • Spire.Spreadsheet v2.6.0
  • Spire.OfficeViewer.Forms.dll v3.7.0
  • Spire.DataExport.dll v3.5.131
  • Spire.DataExport.ResourceMgr.dll v1.6.71
  • Spire.Common.dll v1.2.792
  • Spire.License.dll v1.3.6
  • Spire.Barcode.dll v2.3.0
Get Spire.Office version 3.7.0 from here:

Details about the new features and bug fixes:

Spire.Doc

Bug Fixes:

  • Fixes the issue that the header formatting was incorrect after opening and saving a document.
  • Fixes the issue that the application threw an "ArgumentException" exception when converting .doc file to .docx.
  • Fixes the issue that the application threw a "FormatException" exception when loading a .docx file.
  • Fixes the issue that the application threw a "System.FormatException” exception when loading a .docx file in a Dutch regional environment.
  • Fixes the issue that the custom font size did not apply to paragraph in table cell.
  • Fixes the issue that the numbers in TOC were changed after updating TOC field.
  • Fixes the issue that the .doc documents with password protected failed to load.
  • Fixes the issue that the default value of "doNotExpandShiftReturn” property is incorrect.
  • Fixes the issue that the application threw a "System.FormatException” exception when loading a .docx document that contains grid in points.
  • Fixes the issue that the application got stuck when loading a .docx document that contains hebrew characters.
  • Fixes the issue that the application threw a "System.OutOfMemoryException” exception when converting a .doc file to PDF.
  • Fixes the issue that the picture was stretched when converting Rtf document to PDF.
  • Fixes the issue that the format of table became incorrect when converting Word to PDF.
  • Fixes the issue that some problems like wrong bullet number and inconsistent corss-page-break setting for tables occurring when converting Word to PDF.
  • Fixes the issue that the application threw a "NullReferenceException" exception when converting Word to PDF.
  • Fixes the issue that the application threw an "ArgumentOutOfRangeException" exception when converting Word to PDF.
  • Fixes the issue that the format of bullets became incorrect when converting Word to PDF.
  • Fixes the issue that there was an extra "/*" symbol after the hyperlink when converting Word to HTML.
  • Fixes the issue that the "created date" information was wrong when creating .doc and .docx file.
  • Fixes the issue that the application hung when calculating the page count for a Word.

Spire.XLS

New features:

  • Adds a new property "XlsPivotTable.Options.IsAutoFormat" for setting whether the autoformat is applied for pivot table or not. Default value is true.
  • bool IsAutoFormat { get; set; }
    
  • Adds following three new methods to delete filters in pivot table.
  • public void ClearColumnFieldFilter(string fieldName);
    public void ClearFilter(string fieldName);
    public void ClearRowFieldFilter(string fieldName);
    
  • Adds a new property "IChart.ChartArea.Shadow.SoftEdge”to support the setting for chart soft edge.
  • public int SoftEdge { get; set; } 
    

Bug Fixes:

  • Fixes the issue that caused ArgumentException when loading the file.
  • Fixes the issue that caused NullReferenceException when using the code trendLine.DisplayEquation.
  • Fixes the issue that setting number format didn't work in Spain's environment.
  • Fixes the issue that the number format was wrong after converting Excel to PDF in Spain's environment.
  • Fixes the issue that the content was incorrect after converting Excel to PDF.
  • Fixes the issue that setting default value for the filter of pivot table didn't work.
  • Fixes the issue that the process hang when converting Excel to HTML.
  • Fixes the issue that caused NullReferenceException when loading a file.
  • Fixes the issue that the content of R1C1-Formula would change when inserting a row.
  • Fixes the issue that the "CellRange.FormulaValue" returned the wrong value.
  • Fixes the issue that the "ValueFromCell" setting would result in an invalid color effect for the negative column.
  • Fixes the issue that the original images in Excel1 had all been replaced when copying one of the sheets in Excel2 to Excel1.
  • Fixes the issue that some structural references were not supported.
  • Fixes the issue that the property "IsAutoMajor" must be set to false when setting the label unit.
  • Fixes the issue that the "pageInfoList[0].Count” returned wrong value for the page count.
  • Fixes the issue that the application threw an "ArgumentOutOfRangeException" when loading an EXCEL document.
  • Fixes the issue that the color settings for columns with negative values in Column Chart did not work.
  • Fixes the issue that the name ranges got lost after copying a worksheet.
  • Fixes the issue that the application threw "ArgumentException" exception when loading an .xlsx file.

Spire.PDF

New features:

  • Adds new methods to remove rows or columns of PdfGrid.
  • Grid.Rows.Remove(row);
    Grid.Rows.RemoveAt(index);
    Grid.Columns.Remove(col);
    Grid.Columns.RemoveAt(index);
    

Bug Fixes:

  • Fixes the issue that the format became incorrect when extracting text from a PDF.
  • Fixes the issue that a memory leak occurred when extracting images from a PDF.
  • Fixes the issue that the images got removed when parsing an EMF to PDF.
  • Fixes the issue that the "FindText()" method could not find the related content.
  • Fixes the issue that the encryption of PDF got failed when setting the password to be special characters.
  • Fixes the issue that the application threw an exception when invoking the "AppendPage()" method.
  • Fixes the issue that the application threw a "System.FormatException” exception when converting extracting images and text.
  • Fixes the issue that the text was a little bit clipped when converting rtf content with justified style to PDF document.
  • Fixes the issue that the application threw a "System.FormatException” exception when printing PDF document.
  • Fixes the issue that the dotted/dashed lines were displayed as solid lines when converting PDF document to XPS file or printing PDF document on the WPF platform.
  • Fixes the issue that the application threw a "System.NullReferenceException” exception when converting PDF document to Image.
  • Fixes the issue that half page content got removed when printing PDF document.
  • Fixes the issue of misplaced content when parsing an EMF to PDF.
  • Fixes the issue that the background became black when printing PDF document.
  • Fixes the issue that all content got removed when converting PDF document to Image.
  • Fixes the issue that the text cannot be found using the method FindText.
  • Fixes the issue that the vertical text wasn't displayed correctly when converting EMF to PDF.
  • Fixes the issue that the background of image changed to black when converting PDF to Word.
  • Fixes the issue that the text was cut off when printing PDF.
  • Fixes the issue that the content was wrong when printing.
  • Fixes the issue that the formats of graphics in PDF document were printed incorrectly.
  • Fixes the issue that the data were misplaced when extracting text.
  • Fixes the issue that the Chinese characters were messy code when extracting text.
  • Fixes the issue that the QR Code in a Pdf document were printed incorrectly.
  • Fixes the issue that the content were cut off when merging PDF files.
  • Fixes the issue that the data got lost when converting PDF to Image.
  • Fixes the issue that the Xps file converted from PDF was opened unsuccessfully.
  • Fixes the issue that some content was blacked out when converting PDF to PDF/A.

Spire.Presentation

New features:

  • Adds a property IsHidden to hide the series of a chart.
  • series.IsHidden = true;
    
  • Adds a new method GroupShapes to group shapes.
  • ppt.Slides[0].GroupShapes(shapeList);
    
  • Adds a new property "DataLabelShapeType" for setting the shape of the chart datalabel in PPT.
  • public DataLabelShapeType DataLabelShapeType { get; set; }
    
  • Adds a new property "MarkerFill” for setting the fill color and border color of the separate markers in PPT.
  • ChartDataPoint dp = new ChartDataPoint(chart.Series[0]);
    //set the fill color
    dp.MarkerFill.Fill.FillType = FillFormatType.Solid;
    dp.MarkerFill.Fill.SolidColor.Color = Color.Red;
    //set the border color
    dp.MarkerFill.Line.FillType = FillFormatType.Solid;
    dp.MarkerFill.Line.SolidFillColor.Color = Color.Black;
    

Bug Fixes:

  • Fixes the issue that there was extra character "-" when converting PPT to PDF.
  • Fixes the issue that the chart was missing and the position of yellow punctuation was wrong when converting PPT to PDF.
  • Fixes the issue that there was a blue border after saving PPT.
  • Fixes the issue that the default font of chart legend cannot be got if the legend didn't set any font.
  • Fixes the issue that caused DocumentUnkownFormatException when loading a file.
  • Fixes the issue that the conversion from the PPT file which has the same background image for each slide to PDF would result in a time-consuming process with large size output file.
  • Fixes the issue that the application threw an "Index was out of range" exception when loading a PPT.
  • Fixes the issue that printing in landscape mode did not make any sense.
  • Fixes the issue that the output file was not correct when converting PPT to PDF.
  • Fixes the issue that the chart was in bad format when converting PPT to PDF.

Spire.SpreadSheet

New features:

  • Supports to undo the action of deleting a row.

Bug Fixes:

  • Fixes the issue that Chinese characters were truncated when viewing xls file in spreadsheet.

Spire.PdfViewer

Bug Fixes:

  • Fixes the issue the application threw an exception when reading a PDF.
  • Fixes the issue that some contents got removed when reading a PDF.