Spire.Office 6.4.4

Spire.Office 6.4.4 is released

We are excited to announce the release of Spire.Office 6.4.4. This version brings some new features, for instance, Spire.PDF supports setting lines to determine cells when converting PDF to Excel, as well as adds a new property to determine whether the printer is valid; Spire.XLS supports getting printer customized paper size and setting it to worksheets; Spire.Presentation supports adding Video media from stream as well as adding customized path animation. Moreover, a lot of bugs have been fixed. More details are listed as follows.

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 v9.4.18
  • Spire.Pdf.dll v7.4.13
  • Spire.XLS.dll v11.4.6
  • Spire.Email.dll v4.1.2
  • Spire.DocViewer.Forms.dll v6.1.0
  • Spire.PdfViewer.Forms.dll v6.4.4
  • Spire.PdfViewer.Asp.dll v6.4.4
  • Spire.Presentation.dll v6.4.5
  • Spire.Spreadsheet v5.4.1
  • Spire.OfficeViewer.Forms.dll v6.4.4
  • Spire.Barcode.dll v5.4.0
  • Spire.DataExport.dll v4.1.9
  • Spire.DataExport.ResourceMgr.dll v2.1.0
  • Spire.License.dll v1.3.8
Click the link to get the version Spire.Office 6.4.4:
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-4127 Supports setting lines to determine cells when converting PDF to Excel.
PdfDocument pdf = new PdfDocument();
pdf.LoadFromFile(PDFFile);
pdf.ConvertOptions.SetPdfToXlsxOptions(PdfToXlsxLayout.Line);
pdf.SaveToFile(ExcelFile, FileFormat.XLSX);
New feature SPIREPDF-4196 Adds a new property "PrintSettings.IsValid" to determine whether the printer is valid.
PdfDocument pdf = new PdfDocument();
pdf.LoadFromFile(inputFile);
pdf.PrintSettings.PrinterName = @"Microsoft XPS Document Writer";
bool value = pdf.PrintSettings.IsValid;
Bug SPIREPDF-726 Optimizes the speed of converting PDF to images.
Bug SPIREPDF-770 Fixes the issue that the content was incorrect after converting PDF to images.
Bug SPIREPDF-772 Fixes the issue that setting the number of copies to print failed to take effect.
Bug SPIREPDF-793 Fixes the issue that the application threw the error "Index was outside the bounds of the array" when converting PDF to XPS.
Bug SPIREPDF-3212 Fixes the issue that the signatures of the result PDF were invalid after adding multiple digital signatures to the PDF.
Bug SPIREPDF-3919
SPIREPDF-3942
Fixes the issue that the application threw the error "Object reference not set to an instance of an object" when printing PDF.
Bug SPIREPDF-3934
SPIREPDF-4148
Fixes the issue that the printout was incorrect after printing the PDF.
Bug SPIREPDF-4099 Fixes the issue that the content was incorrect after converting PDF to Excel.
Bug SPIREPDF-4176 Fixes the issue that the application threw the error "Object reference not set to an instance of an object" when drawing web links on PDF page template elements.
Bug SPIREPDF-4186 Fixes the issue that the application threw the error "cannot draw table, because there is no enough space for it" when drawing the table.
Bug SPIREPDF-4210 Fixes the issue that the cell was not split correctly after converting PDF to Excel.

Spire.Doc

Category ID Description
Bug SPIREDOC-4099 Fixes the issue that there was extra blank line after converting Word to PDF.
Bug SPIREDOC-4629 Fixes the issue that the content was incorrect after converting Word to XPS.
Bug SPIREDOC-5540
SPIREDOC-5672
Fixes the issue that the content was incorrect after converting Word to PDF.
Bug SPIREDOC-5687 Fixes the issue that the content overlapped after converting Word to PDF.
Bug SPIREDOC-5769 Fixes the issue that the TOC content was incorrect after updating the TOC.
Bug SPIREDOC-5776 Fixes the issue that it failed to get the page count.
Bug SPIREDOC-5826 Fixes the issue that the bookmark was duplicated after converting Word to PDF.
Bug SPIREDOC-5827 Fixes the issue that the bookmark content was incorrect after converting Word to PDF.
Bug SPIREDOC-5832 Fixes the issue that the added math equation was incorrect.
Bug SPIREDOC-5833 Fixes the issue that the application threw the error "Input string was not in a correct format" when loading HTML files.
Bug SPIREDOC-5844 Fixes the issue that the application threw the error "Input string was not in a correct format" when adding HTML text.
Bug SPIREDOC-5853 Fixes the issue that the picture color was changed after converting Docx to Doc.

Spire.Spreadsheet

Category ID Description
Bug SPREADSHEET-180 Fixes the issue that the formula value was displayed incorrectly when viewing excel file.
Bug SPREADSHEET-184 Fixes the issue that the application threw the error "System.NullReferenceException" when loading Excel documents.

Spire.XLS

Category ID Description
New feature SPIREXLS-2603 Supports getting printer customized paper size and setting it to worksheets.
PageSetup.CustomPaperSizeName
Bug SPIREXLS-3118 Fixes the issue that the program threw an exception "Unhandled Exception" when converting Excel to PDF in xamarin android applications.
Bug SPIREXLS-3179 Fixes the issue that the program threw an exception "Invalid pivot table data source" when converting Excel to PDF
Bug SPIREXLS-3181 Fixes the issue that there were multiple lines of spaces in the data after calling Filter().
Bug SPIREXLS-3193 Fixes the issue that copying formula to cell range failed to take effect.
Bug SPIREXLS-3198 Fixes the issue that the converted PDF content was not displayed correctly after embeding the IDAutomationHC39M font
Bug SPIREXLS-3202 Fixes the issue that the program threw an exception "System.NullReferenceException" when calling "chart.PrimaryCategoryAxis.IsAutoMin = false".
Bug SPIREXLS-3204 Fixes the issue that the x-axis coordinate arrangement wasn't correct in the created Chart.
Bug SPIREXLS-3230 Fixes the issue that the formula changed after loading and saving an Excel document.

Spire.Presentation

Category ID Description
New feature SPIREPPT-1469 Supports adding Video media from stream.
AppendVideoMedia(Stream stream, RectangleF rectangle);
New feature SPIREPPT-1519 Supports adding customized path animation.
Presentation ppt = new Presentation();
IAutoShape shape = ppt.Slides[0].Shapes.AppendShape(ShapeType.Rectangle, new RectangleF(0, 0, 200, 200)); 
AnimationEffect effect = ppt.Slides[0].Timeline.MainSequence.
AddEffect(shape, AnimationEffectType.PathUser);
CommonBehaviorCollection common = effect.CommonBehaviorCollection;
AnimationMotion motion = (AnimationMotion)common[0];
motion.Origin = AnimationMotionOrigin.Layout;
motion.PathEditMode = AnimationMotionPathEditMode.Relative;
MotionPath moinPath = new MotionPath();
moinPath.Add(MotionCommandPathType.MoveTo, new PointF[] { new PointF(0, 0) }, MotionPathPointsType.CurveAuto, true);
moinPath.Add(MotionCommandPathType.LineTo, new PointF[] { new PointF(0.1f, 0.1f) }, MotionPathPointsType.CurveAuto, true);
moinPath.Add(MotionCommandPathType.LineTo, new PointF[] { new PointF(-0.1f, 0.2f) }, MotionPathPointsType.CurveAuto, true);
moinPath.Add(MotionCommandPathType.End, new PointF[] { }, MotionPathPointsType.CurveStraight, true);
motion.Path = moinPath;
ppt.SaveToFile(outputFile, FileFormat.Pptx2010);
ppt.Dispose();
Bug SPIREPPT-1471 Fixes the issue that the shadow effect was incorrect after converting PPTX to images.
Bug SPIREPPT-1501 Fixes the issue that it failed to set the correct duration of the animation.
Bug SPIREPPT-1517 Fixes the issue that the content was incorrect after converting PPTX to images.
Bug SPIREPPT-1532 Fixes the issue that the application threw the error "System.NullReferenceException" when loading PPTX files.
Bug SPIREPPT-1537 Fixes the issue that the application threw the error "System.IndexOutOfRangeException" when loading PPT files