Spire.Office 5.7.3

Spire.Office 5.7.3 is released

We're pleased to announce the release of Spire. Office 5.7.3. This version has some fantastic new features, such as Spire.PDF supports converting PDF to Excel, Spire.XLS supports the effect of retaining field name labels when converting chart generated from PivotTable data to PDF, Spire.Spreadsheet supports getting the text of number formatted cell, Spire.Barcode includes the dlls that can support .Net Standard 2.0, MonoAndroid and Xamarin.iOS platforms, Spire.Email supports netcoreapp2.0, netcoreapp3.0, netstandard2.0, MonoAndroid and Xamarin.iOS platforms. At the same time, a series of issues that occurred when loading, converting and manipulating PDF, Word, Excel and Presentation files have been successfully fixed. 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.

Dll Versions:

  • Spire.Doc.dll v8.7.5.
  • Spire.Pdf.dll v6.7.6
  • Spire.XLS.dll v10.7.2
  • Spire.Email.dll v3.6.7
  • Spire.DocViewer.Forms.dll v5.1.1
  • Spire.PdfViewer.Forms.dll v5.7.2
  • Spire.PdfViewer.Asp.dll v5.7.2
  • Spire.Presentation.dll v5.6.1
  • Spire.Spreadsheet v4.5.0
  • Spire.OfficeViewer.Forms.dll v5.7.3
  • Spire.Barcode.dll v4.5.1
  • Spire.DataExport.dll v4.1.9
  • Spire.DataExport.ResourceMgr.dll v2.1.0
  • Spire.Common.dll v10.7.2
  • Spire.License.dll v1.3.8
Click the link to get the version Spire.Office 5.7.3:
More information of Spire.Office new release or hotfix:

Here is a list of changes made in this release

Spire.PDF

Category ID Description
New Feature SPIREPDF-2320 Supports converting PDF to Excel.
PdfDocument pdfDocument = new PdfDocument();
pdfDocument.LoadFromFile(inputPdfFilePath);
pdfDocument.SaveToFile(outputExcelFilePath,FileFormat.XLSX);
Bug SPIREPDF-3252 Fixes the issue that the application threw System.NullReferenceException when extracting text from an PDFA/1 file.
Bug SPIREPDF-3271 Fixes the issue that some fonts were incorrect when converting PDF to HTML.
Bug SPIREPDF-3276 Fixes the issue that the background color changed from white to black when printing PDF.
Bug SPIREPDF-3285 Fixes the issue that the application hung when saving to file after adding image.
Bug SPIREPDF-3254 Fixes the issue that font spacing was incorrect after filling form fields.
Bug SPIREPDF-735 Fixes the issue that the application threw System.Xml.XmlException when invoking SetCustomerDefined method.
Bug SPIREPDF-1022 Fixes the issue that the application threw NullReferenceException when finding text.
Bug SPIREPDF-1069 Fixes the issue that the application threw System.OutOfMemoryException when loading XPS file.
Bug SPIREPDF-2490 Fixes the issue that the application threw System.NullReferenceException when extracting attachments.
Bug SPIREPDF-2910 Fixes the issue that the application threw IOException when converting PDF to image.
Bug SPIREPDF-2959 Fixes the issue that some characters lost when converting XPS to PDF.
Bug SPIREPDF-3082 Fixes the issue that the content was not correct when printing PDF.
Bug SPIREPDF-3185 Fixes the issue that the application threw Spire.Pdf.Exception.PdfDocumentException when loading PDF file.
Bug SPIREPDF-3204 Fixes the issue that the filled content was not displayed correctly after filling the fields.
Bug SPIREPDF-3234 Fixes the issue that the application threw System.FormatException when extracting attachments.
Bug SPIREPDF-3246 Fixes the issue that the extracted image index and the replacement image index were inconsistent.
Bug SPIREPDF-3268 Fixes the issue that the specified text weren't found.
Bug SPIREPDF-3287 Fixes the issue that the obtained font name of the found text was incorrect.
Bug SPIREPDF-3290
SPIREPDF-3377
Fixes the issue that the searched result was incorrect when setting TextFindParameter.WholeWord.
Bug SPIREPDF-3300 Fixes the issue that the content lost when adding text watermark.
Bug SPIREPDF-3301 Fixes the issue that the text was not be found when using TextFindParameter.Regex.
Bug SPIREPDF-3312 Fixes the issue that there was an error when opening the file that using SaveToStream to save it after using SaveToFile to save the document.
Bug SPIREPDF-3314 Fixes the issue that the application threw PdfException when loading PDF file.
Bug SPIREPDF-3322
SPIREPDF-3376
Fixes the issue that the location information and size of obtained image were incorrect.
Bug SPIREPDF-3343 Fixes the issue that drawing text failed.
Bug SPIREPDF-3347 Fixes the issue that the text were overlapped when printing.
Bug SPIREPDF-3353 Fixes the issue that the application threw System.IndexOutOfRangeException when merging PDF files.
Bug SPIREPDF-3357 Fixes the issue that the application threw System.NullReferenceException when converting PDF to image.
Bug SPIREPDF-3365 Fixes the issue that the result was incorrect after filling ComboBoxField.
Bug SPIREPDF-3374 Fixes the issue that the text was not be found when using regular expressions.

Spire.XLS

Category ID Description
New Feature SPIREXLS-2391 Supports the effect of retaining field name labels when converting chart generated from PivotTable data to PDF.
Bug SPIREXLS-2319 Fixes the issue that the Adobe failed to open the PDF Ole which was extracted from Excel.
Bug SPIREXLS-2323 Fixes the issue that the application threw the "Cannot find record with specified index\r\nParameter name: iColumnIndex." when loading XLSM file.
Bug SPIREXLS-2335 Fixes the issue that the "Print Object" option didn't make sense after converting Excel to PDF.
Bug SPIREXLS-2338
SPIREXLS-2403
Fixes the issue that the application threw the "ArgumentOutOfRangeException" when loading Excel file.
Bug SPIREXLS-2358 Fixes the issue that the application threw an error "ArgumentNullException" when loading Excel file.
Bug SPIREXLS-2359 Fixes the issue that the content format was inconsistent after converting Excel to PDF.
Bug SPIREXLS-2360
SPIREXLS-2378
Fixes the issue that the application hung when loading Excel file.
Bug SPIREXLS-2363 Fixes the issue that the chart data was incorrect after converting Excel to PDF.
Bug SPIREXLS-2369
SPIREXLS-2418
Fixes the issue that the chart lost after converting Excel to Image.
Bug SPIREXLS-2379 Fixes the issue that the text of comment created in Office365 version cannot be obtained.
Bug SPIREXLS-2380 Fixes the issue that the application threw an error "ArgumentOutOfRangeException" when setting MajorUnit of PrimaryCategoryAxis.
Bug SPIREXLS-2389 Fixes the issue that DATEDIF function cannot be calculated correctly.
Bug SPIREXLS-2394 Fixes the issue that the bar color of chart lost after converting Excel to PDF.
Bug SPIREXLS-2417 Fixes the issue that changing Preview mode to Normal mode didn't take effect.
Bug SPIREXLS-2481 Fixes the issue that the chart was incorrect after converting Excel to PDF.

Spire.Doc

Category ID Description
Bug SPIREDOC-3571 Fixes the issue that the application threw ArgumentOutOfRangeException when converting RTF to Doc.
Bug SPIREDOC-3666 Fixes the issue that the typesetting was incorrect when opening the converted Doc from RTF in Word Online.
Bug SPIREDOC-4140 Fixes the issue that the application threw IllegalStateException when loading file.
Bug SPIREDOC-4211 Fixes the issue that the application threw NullPointerException when loading file.
Bug SPIREDOC-4265 Fixes the issue that the application hung when converting Docx to PDF.
Bug SPIREDOC-4370 Fixes the issue that the application threw NullPointerException when saving to file after removing section breaks.
Bug SPIREDOC-4019
SPIREDOC-4237
Fixes the issue that the font was changed after converting Word to PDF or saving to Word.
Bug SPIREDOC-4040 Fixes the issue that the field was not updated correctly.
Bug SPIREDOC-4144 Fixes the issue that caused incorrect table border after converting Word to PDF.
Bug SPIREDOC-4214 Fixes the issue that caused incorrect content after updating the TOC.
Bug SPIREDOC-4220 Fixes the issue that the application threw the exception "An object reference is not set to an instance of the object" when adding content in bookmark.
Bug SPIREDOC-4271 Fixes the issue that application threw the exception "Input string was not in the correct format" when updating the TOC.
Bug SPIREDOC-4375 Fixes the issue that setting margins for the last section and saving to docm, the margins of all sections were changed.
Bug SPIREDOC-4378 Fixes the issue that application threw the exception "Index was out of range" when converting Word to HTML.
Bug SPIREDOC-4382 Fixes the issue that caused incorrect paging after converting Word to PDF.
Bug SPIREDOC-4383 Fixes the issue that the page number didn't display completely after converting Word to PDF.
Bug SPIREDOC-4417 Fixes the issue that application threw the "ArgumentOutOfRangeException" when converting Word to HTML.
Bug SPIREDOC-4439 Fixes the issue that application threw the "NullReferenceException" when converting Word to HTML.
Bug SPIREDOC-4442 Fixes the issue that application threw the exception "The value cannot be null" when replacing document.
Bug SPIREDOC-4490 Fixes the issue that application threw the "NullReferenceException" when converting Word to PDF.
Bug SPIREDOC-4491 Fixes the issue that application threw the "ArgumentOutOfRangeException" when replacing document.
Bug SPIREDOC-4511 Fixes the issue that the border lost after converting Word to PDF.
Bug SPIREDOC-4513 Fixes the issue that some images were incorrect after converting Word to PDF us PS method.
Bug SPIREDOC-3499
SPIREDOC-4572
SPIREDOC-4606
Fixes the issue that caused incorrect content after converting Word to PDF.
Bug SPIREDOC-3837 Fixes the issue that caused incorrect paging after converting Word to PDF.
Bug SPIREDOC-4381
SPIREDOC-4379
Fixes the issue that the page number didn't display correctly after converting Word to PDF.
Bug SPIREDOC-4148 Fixes the issue that the application threw "EndOfStreamException" when loading the Word document.
Bug SPIREDOC-4577 Fixes the issue that using the PS conversion method to convert Word to PDF/A didn't work.
Bug SPIREDOC-4581 Fixes the issue that the application threw "XmlException" when loading the Word document.
Bug SPIREDOC-4623 Fixes the issue that the application threw "InvalidOperationException" when loading the HTML document.
Bug SPIREDOC-4624 Fixes the issue that the application threw "ArgumentException" when loading the HTML document.
Bug SPIREDOC-4626 Fixes the issue that the Chinese characters were missing after converting Word to PDF.
Bug SPIREDOC-4632 Fixes the issue that the chart was missing after converting Word to PDF/A.
Bug SPIREDOC-4653 Fixes the issue that the application threw "ArgumentOutOfRangeException" when updating the TOC.
Bug SPIREDOC-4656 Fixes the issue that the application threw an exception when converting HTML to PDF.
Bug SPIREDOC-4671 Fixes the issue that the image title obtained was incorrect.
Bug SPIREDOC-4700 Fixes the issue that the generated mail merge report was incorrect.

Spire.Presentation

Category ID Description
Bug SPIREPPT-1131 Fixes the issue that the content was incorrect when converting PPT to PDF.
Bug SPIREPPT-1145 Fixes the issue that the application threw an error "Microsoft PowerPoint 2007 file is corrpt" when loading a PPTX document.
Bug SPIREPPT-1162 Fixes the issue that the chart data of the output document could not be accessed after changing the chart data.
Bug SPIREPPT-1166 Fixes the issue that it failed to set the underline of text range.
Bug SPIREPPT-1167 Fixes the issue that the created scatter chart with straight lines had needless markers.
Bug SPIREPPT-1183 Fixes the issue that the application threw System.NullReferenceException when saving to a PPTX document.

Spire.Spreadsheet

Category ID Description
New Feature SPREADSHEET-162 Supports getting the text of number formatted cell.
string text = spreadsheet1.ActiveWorksheet[0,0].Text;
Bug SPREADSHEET-161 Fixes the issue that setting the format of sheet didn't take effect.

Spire.Barcode

Category Description
New Feature Supports .Net Standard 2.0, MonoAndroid, Xamarin.iOS platforms.

Spire.Email

Category Description
New Feature Supports netcoreapp2.0, netcoreapp3.0, netstandard2.0, MonoAndroid and Xamarin.iOS.

Spire.PDFViewer

Category ID Description
Bug SPIREPDFVIEWER-431
SPIREPDFVIEWER-447
Fixes the issue that the content was not displayed correctly when viewing the PDF document.
Bug SPIREPDFVIEWER-449 Fixes the issue that the content of the exported image was incorrect.