Spire.Office 4.9.0 is released

We're pleased to announce the release of Spire.Office 4.9.0. This version adds netstandard2.0 folder to place dlls which could work with Azure Function and some new features are supported, such as Spire.PDF supports converting HTML to PDF on .net core platform and getting the callout line of PdfFreeTextAnnotationWidget, Spire.Doc supports adding digital signatures, Spire.Presentation supports inserting image and video to placeholders and setting radius of round rectangle, Spire.XLS supports creating chart based on PivotTable and adding arrow line. Besides, a series of issues that occurred when converting the PDF to SVG/ image, XPS to PDF, Word to PDF, Html to Docx, PPT to SVG/image, Excel to PDF/HTML, copying cells range and printing PDF are fixed successfully. See the content below for more details.

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.8.17
• Spire.Pdf.dll v5.8.17
• Spire.XLS.dll v9.9.1
• Spire.Presentation.dll v4.8.16
• Spire.Email.dll v2.4.19
• Spire.DocViewer.Forms.dll v4.5.12
• Spire.PdfViewer.Forms.dll v4.8.2
• Spire.PdfViewer.Asp.dll v4.8.2
• Spire.Spreadsheet v3.8.2
• Spire.OfficeViewer.Forms.dll v4.9.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.1
• Spire.License.dll v1.3.7

Spire.PDF

New Features:

• Supports converting HTML to PDF on .Net Core platform.
• Adds a new property to get the callout line of PdfFreeTextAnnotationWidget.

public PointF[] CalloutLines { get; }

• Adds a new property to get the line ending style of PdfFreeTextAnnotationWidget.

public PdfLineEndingStyle LineEndingStyle { get; }

• Adds a new property to get or set the rectangular diffecences array of PdfFreeTextAnnotationWidget and PdfFreeTextAnnotation.

public float[] RectangleDifferences { get; set; }

Bug Fixes:

• Fixes the issue that extra border of textbox field was caused after filling text.
• Fixes the issue that the content lost after printing.
• Fixes the issue that the invisible layer of PDF was rendered after converting the PDF to SVG.
• Fixes the issue that the PDF field whose border had color became black after converting the PDF to SVG.
• Fixes the issue that the checkbox style was incorrect after selecting an existing checkbox field.
• Fixes the issue that the application threw an exception "Array dimensions are out of support" when loading PDF.
• Fixes the issue that many lines text of textbox fields had problems after filling textbox fields.
• Fixes the issue that caused black content after converting PDF to image.
• Fixes the issue that the application threw the "NullReferenceException" when loading XPS file.
• Fixes the issue that the application threw the "IndexOutOfRangeException" when converting PDF to image.
• Fixes the issue that the application hung when converting PDF to HTML.
• Fixes the issue that the application threw the "NullReferenceException" when merging PDF documents.
• Fixes the issue that the transparency of watermark lost after converting XPS to PDF.
• Fixes the issue that the added image stamp was missing after rotating in adobe reader.
• Fixes the issue that the size of stamp changed after creating template.
• Fixes the issue that getting PDF forms returns correct value first second time while returns null in second time.
• Fixes the issue that the text was stretched after filling text box.
• Fixes the issue that the content was lost after printing a PDF file.
• Fixes the issue that the text in rotated page cannot be extracted.
• Fixes the issue that the application threw the exception when dlls in netstandard2.0 folder used in the project with .NET framework.

Spire.Doc

New Features:

• NETStandard and NETCore support digital signatures.

Bug Fixes:

• Fixes the issue that incomplete images was caused after converting Word to PDF.
• Fixes the issue that blank page was caused and the image in header lost after converting Word to PDF.
• Fixes the issue that incorrect page number was caused after converting Word to PDF.
• Fixes the issue that errors in the characters in Thai were caused after converting Word to PDF.
• Fixes the issue that caused incorrect content and paging after converting Word to PDF.
• Fixes the issue that after setting KeepSameFormat to true, the application threw an exception when converting Word to PDF.
• Fixes the issue that incorrect data was caused after doing mail merging.
• Fixes the issue that the application threw an exception "An object reference is not set to an object instance " when converting Word to PDF.
• Fixes the issue that the application threw an exception "The format of input string is incorrect" when executing AppenHTML() method.
• Fixes the issue that the incorrect content format was caused after converting Word to PDF.
• Fixes the issue that the content lost and pagination error was caused after converting Word to PDF.
• Fixes the issue that the application threw the "InvalidOperationException" when loading file.
• Fixes the issue that exception was thrown when converting Word to PDF.
• Fixes the issue that incorrect layout was caused after converting Word to PDF.
• Fixes the issue that displaying error of WordArt was caused after converting Word to PDF.
• Fixes the issue that the table header error was caused after converting Word to PDF.
• Fixes the issue that the page number updating was incorrect after converting Word to PDF.
• Fixes the issue that image format was incorrect after converting Html to Docx.

Spire.Presentation

New Features:

• Supports inserting images and video to placeholders.

Presentation ppt = new Presentation();
 ppt.LoadFromFile("test.pptx");
 for (int j=0;j < ppt.Slides.Count;j++)
 {
     ISlide slide = (ISlide)ppt.Slides[j];
     for (int i=0;i < slide.Shapes.Count;i++)
     {
         Shape shape = (Shape)slide.Shapes[i];
         switch(shape.Placeholder.Type)
         {
             case PlaceholderType.Media:
                 shape.InsertVideo("Video.mp4");
                 break;
             case PlaceholderType.Picture:
                 shape.InsertPicture("Logo.png");
                 break;
             case PlaceholderType.Chart:
                 shape.InsertChart(ChartType.ColumnClustered);
                 break;
             case PlaceholderType.Table:
                 shape.InsertTable(3,2);
                 break;
             case PlaceholderType.Diagram:
                 shape.InsertSmartArt(SmartArtLayoutType.BasicBlockList);
                 break;
         }
     }
 }

• Supports setting radius of round rectangle.

Presentation presentation = new Presentation();
presentation.Slides[0].Shapes.InsertRoundRectangle(0, 60, 90, 100, 200, 36);
presentation.Slides[0].Shapes.AppendRoundRectangle(60, 290, 100, 200, 50);
presentation.SaveToFile("result.pdf", FileFormat.PDF);
presentation.SaveToFile("result.pptx", FileFormat.Pptx2013);

• Supports getting a template name in the themes.

Presentation presentation = new Presentation();
presentation.LoadFromFile(file);
 for (int i = 0; i < presentation.Slides.Count;i++ )
 {
     string name = presentation.Slides[i].Layout.Name;
 }

Bug Fixes:

• Fixes the gradient color position issue for converting PPT to SVG.
• Fixes the exception issue when loading PPT file.
• Fixes the exception issue when saving PPT file.
• Fixes the content format issue for converting PPT to image.
• Fixes the content lost issue for converting PPT to image.
• Fixes the slow issue when saving PPT file on Windows 10.

Spire.XLS

New Features:

• Supports creating chart based on PivotTable.

worksheet.Charts.Add(ExcelChartType.BarClustered, pivotTable);

• Supports adding arrow line.

var arrowline = workbook.Worksheets[0].TypedLines.AddLine();
line.Top = 50; 
line.Left = 30; 
line.Width = 300;
line.Height = 500;
line.BeginArrowHeadStyle = ShapeArrowStyleType.LineArrowDiamond;
line.EndArrowHeadStyle = ShapeArrowStyleType.LineArrow;

• Adds the method AddCopy() after TypedLines/TypedCheckBoxes/TypedTextBoxes/TypedRadioButtons/TypedComboBoxes to copy shapes.

wb.Worksheets[0].TypedLines.AddCopy(line);

Bug Fixes:

• Fixes the issue that incorrect line height was caused after setting AutoFitRow.
• Fixes the issue that there were errors in the PivotTable after converting Excel to PDF or HTML.
• Fixes the issue that messy content was caused after converting CSV to XLSX in .NET Core.
• Fixes the issue that incorrect line was caused after converting Excel to PDF.
• Fixes the issue that the conditional format lost after copying range.
• Fixes the issue that if the page number had blank space, there was a problem with the page number after adding.
• Fixes the issue that incorrect Thai characters were caused after converting Excel to PDF.
• Fixes the issue that incorrect chart data was caused after converting Excel to PDF.
• Fixes the issue that the formula of trend line could not be returned correctly.
• Fixes the issue that the color of range could not be cloned successfully.
• Fixes the issue that the application failed to load a correct document if the first document had failed to be loaded.
• Fixes the issue that Excel prompted a message to update link after removing a sheet which contains NamedRange.
• Fixes the issue that the application caught an exception in try catch statement, but another exception was thrown after using GC to collect garbage.
• Fixes the issue that the page break was wrong after converting Excel to PDF.
• Fixes the issue that the data displayed wrongly after saving Chart to image.
• Fixes the issue that loading a file failed.
• Fixes the issue that the application threw the exception StackOverflowException when saving to PDF.
• Fixes the issue that corrupted Excel was caused when using Conditional Formatting.
• Fixes the issue that the result file hinted an error when opening after deleting a row that contains formula.
• Fixes the issue that setting fill horizontally for text didn't work.
• Fixes the issue that the application threw the exception FormatException when loading a file.