News Category

Spire.Office 7.5.4 is released

2022-05-27 10:21:29

We are glad to announce the release of Spire.Office 7.5.4. In this version, Spire.Doc enhances the conversion from Word to PDF and HTML to Word; Spire.XLS supports centering text via IPrstGeomShape class and provides an overload of InsertArray method, which supports setting whether to automatically convert date string to datetime format when inserting arrays into Excel document; Spire.Presentation adds a method, slide.GetAllTextFrame(), to get text content of a slide; Spire.PDF supports converting OFD to PDF stream and enhances the conversion from PDF to Excel; Spire.OfficeViewer fixes the issue that the page count increases when viewing Word documents. In addition, a lot of known bug have been fixed successfully. More details are listed as follow.

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 v10.5.9
  • Spire.Pdf.dll v8.5.0
  • Spire.XLS.dll v12.5.3
  • Spire.Email.dll v5.5.0
  • Spire.DocViewer.Forms.dll v7.5.0
  • Spire.PdfViewer.Forms.dll v7.5.0
  • Spire.PdfViewer.Asp.dll v7.5.0
  • Spire.Presentation.dll v7.5.3
  • Spire.Spreadsheet.dll v6.4.1
  • Spire.OfficeViewer.Forms.dll v7.5.4
  • Spire.Barcode.dll v6.5.0
  • Spire.DataExport.dll v4.4.0
  • Spire.DataExport.ResourceMgr.dll v2.1.0
Click the link to get the version Spire.Office 7.5.4:
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-6917 Fixes the issue that the color of table borders lost after converting html to docx.
Bug SPIREDOC-7600 Fixes the issue that there were extra blank lines before the title after converting word to pdf.
Bug SPIREDOC-7659 Fixes the issue that the table pagination was wrong after converting word to pdf.
Bug SPIREDOC-7678 Fixes the issue that the application threw "System.FormatException" when converting word to pdf under French locale settings.
Bug SPIREDOC-7766 Fixes the issue that image links would not work after saving a docx file.
Bug SPIREDOC-7771 Fixes the issue that waterfall charts would be empty after replacing some paragraph text.
Bug SPIREDOC-7773 Fixes the issue that the application threw "System.ArgumentOutOfRangeException" when loading a docx file.
Bug SPIREDOC-7789
SPIREDOC-7790
Fixes the issue that the content format was inconsistent after converting word to pdf.
Bug SPIREDOC-7824 Fixes the issue that waterfall charts changed to pictures after saving a docx file.
Bug SPIREDOC-7792 Fixes the issue that the application threw "System.Collections.Generic.KeyNotFoundException" when saving a docx file.

Spire.XLS

Category ID Description
New feature SPIREXLS-3852 Provides an overload of InsertArray method, which supports setting whether to automatically convert date string to datetime format when inserting arrays into Excel document.
InsertArray(object[,] objectArray, int firstRow, int firstColumn, bool needConvert); 
New feature SPIREXLS-3806 IPrstGeomShape Implements the style of centered text.
IPrstGeomShape shape = book.Worksheets[0].PrstGeomShapes[0];
shape.TextVerticalAlignment = ExcelVerticalAlignment.MiddleCentered;
Bug SPIREXLS-3758 Optimizes the time and amount of memory used to format cell numbers.
Bug SPIREXLS-3320 Fixed an issue that the chart content was incorrect when converting Excel to PDF.
Bug SPIREXLS-3762 Fixed an issue that the grid lines' style changed from solid to dotted when converting Excel to PDF.
Bug SPIREXLS-3784 Fixed an issue that the application threw System.ArgumentException when converting Excel to HTML.
Bug SPIREXLS-3785 Fixed an issue that the formatting of content was incorrect when converting Excel to PDF.
Bug SPIREXLS-3793 Fixed an issue that the double quotes were added to text when converting Excel to CSV.
Bug SPIREXLS-3794 Fixed an issue that the data was not correct when transferring Excel data to a data table.
Bug SPIREXLS-3802 Fixed an issue that the data was incorrect when adding data using sheet.insertarrayList method.
Bug SPIREXLS-3808 Fixed an issue that the application threw InvalidOperationException when loading an xlsx file.
Bug SPIREXLS-3822 Fixed an issue that the application threw an error "object reference not set to an instance of object" when loading an xlsx file.
Bug SPIREXLS-3823 Fixed an issue that the application threw an error "different formulas in the copied rows" when calling workbook.ActiveSheet.ReparseFormula().
Bug SPIREXLS-3834 Fixed an issue that the value obtained was incorrect.
Bug SPIREXLS-3821 Fixes an issue that the application threw "Invalid file format" when loading XML.
Bug SPIREXLS-3838 Fixes an issue that after inserting a picture with remote address into Excel and converting to PDF, the picture was lost.
Bug SPIREXLS-3861 Fixes an issue that caused incorrect scaling ratio after inserting a picture into Excel.
Bug SPIREXLS-3889 Fixes an issue that the obtained number value of cell in new version was incorrect.
Bug SPIREXLS-3905 Fixes an issue that the application threw "Value was either too large or too small for a Double" when converting Excel to PDF.

Spire.Presentation

Category ID Description
New feature SPIRE.PPT-1933 Adds a method of getting text content of a slide,slide.GetAllTextFrame()
Presentation ppt = new Presentation();
        ppt.LoadFromFile(inputFile);
foreach (ISlide slide in ppt.Slides)
{
    ArrayList arrayList = slide.GetAllTextFrame();
    foreach (String text in arrayList)
    {
        Console.Write(text);
     }
}
Note: don't include the text in chartor image.
New feature SPIRE.PPT-1948 Supports setting the ChartDataLabel with text ranges.
Bug SPIRE.PPT-1907 Fixes the issue that the position of the text in the text box is incorrect when converting PPT to PDF
Bug SPIRE.PPT-1932 Fixes the issue that the application threw System.NullReferenceException when getting the chart's hidden source data.
Bug SPIRE.PPT-1953 Fixes the issue that the font size of the original text is changed after the axis label is reset.

Spire.PDF

Category ID Description
New feature SPIREPDF-5098 Supports converting OFD to PDF stream.
OfdConverter converter = new OfdConverter(inputFile);
//Save to stream
MemoryStream tempStream = new MemoryStream();
converter.ToPdf(tempStream);
Bug SPIREPDF-2502 Fixes the issue that caused black images after converting PDF to images.
Bug SPIREPDF-3740
SPIREPDF-3891
Fixes the issue that the result of converting PDF to images was incorrect after setting the system DPI to 125%.
Bug SPIREPDF-4737 Fixes the issue that the content was not centered when printing PDF documents.
Bug SPIREPDF-4754 Fixes the issue that the cell division of the table was incorrect after converting PDF to Excel.
Bug SPIREPDF-4908 Fixes the issue that the content lost after converting PDF to image.
Bug SPIREPDF-4914 Fixes the issue that the content in layer lost after converting PDF to image.
Bug SPIREPDF-4916 Fixes the issue that the content was moved down after converting PDF to image under the NetStandard platform.
Bug SPIREPDF-4923 Fixes the issue that the content was incorrect after converting to Excel.
Bug SPIREPDF-4957 Fixes the issue that after drawing text in Pdf layer and copying the text from Adobe PDF to Notepad, the characters became garbled.
Bug SPIREPDF-4959
SPIREPDF-5081
Fixes the issue that the page content was incorrect after printing PDF.
Bug SPIREPDF-4976
SPIREPDF-5000
Fixes the issue that the image of the invoice stamp lost after converting OFD to PDF.
Bug SPIREPDF-4989 Fixes the issue that the verification of PDFA1A standard failed after converting merged PDF to PDFA1A.
Bug SPIREPDF-5011 Fixes the issue that the application threw "System.ArgumentOutOfRangeException" when deleting bookmarks based on bookmark title.
Bug SPIREPDF-5068 Fixes the issue that converting PDF to images exceeded the 10-page limitation without a license in the commercial version.
Bug SPIREPDF-5083 Fixes the issue that the application threw "System.StackOverflowException" when loading XPS documents.
Bug SPIREPDF-5090 Fixes the issue that the text format was wrong after converting OFD to PDF.
Bug SPIREPDF-5097 Fixes the issue that the application throws "ZipEntry::ReadDirEntry():Bad signature" when loading OFD file.
Bug SPIREPDF-5104 Fixes the issue that the application throws "System.IndexOutOfRangeException: Index was outside the bounds of the array" when PDF to images.
Bug SPIREPDF-4909 Fixes the issue that the barcode in the page was changed after converting PDF to image.
Bug SPIREPDF-4909 Fixes the issue that setting the text highlighting effect was not ideal.

Spire.Email

Category ID Description
Bug SPIREEMAIL-42
SPIREEMAIL-53
SPIREEMAIL-56
Fixes the issue that it failed to get the attachment from message.
Bug SPIREEMAIL-52 Fixes the issue that it failed to get the correct subject from message.

Spire.OfficeViewer

Category ID Description
Bug SPIREOFFICEVIEWER-17 Fixes the issue that the page count increases when viewing Word documents.

Spire.DocViewer

Category ID Description
Bug SPIREDOCVIEWER-88 Fixes the issue that the format of some content is inconsistent with that of the original Word document when being viewed.