Spire.Office 4.6.1 is released

We're pleased to announce the release of Spire.Office 4.6.1. This version includes some fantastic new features, for instance, Spire.Presentation supports getting the font of the table applied with table style, Spire.Spreadsheet supports copying, pasting of multiple areas and inserting, deleting multiple rows/columns, Spire.PDF supports removing the author of annotation and specifying page ranges when saving to PDF, Spire.Doc supports adding Latex math code to Word. In addition, a series of conversion functions have been improved, such as the conversion from Excel to Image, Chart to Image, PDF to SVG, EMF to PDF, PDF to Word, HTML to PDF with Plugin, Word to PDF. The complete list of new features and bug fixes is given below.

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.6.7
• Spire.Pdf.dll v5.6.28
• Spire.XLS.dll v9.6.8
• Spire.Presentation.dll v4.6.2
• Spire.Email.dll v2.4.8
• Spire.DocViewer.Forms.dll v4.5.2
• Spire.PdfViewer.Forms.dll v4.6.2
• Spire.PdfViewer.Asp.dll v4.5.2
• Spire.Spreadsheet v3.6.5
• Spire.OfficeViewer.Forms.dll v4.6.1
• Spire.Barcode.dll v3.5.0
• Spire.DataExport.dll v4.1.9
• Spire.DataExport.ResourceMgr.dll v2.1.0
• Spire.Common.dll v2.6.8
• Spire.License.dll v1.3.7

Spire.Presentation

New Features:

• Adds the DefaultLatinFont property to get the font of the table applied with a table style.

var defaultLatinFont = table[2, 0].TextFrame.TextRange.DefaultLatinFont

Bug Fixes:

• Fixes the issue that the application threw NullReferenceException when converting POTX to PPTX.

Spire.XLS

Bug Fixes:

• Fixes the issue that caused incorrect format when converting Excel to image.
• Fixes the issue that the application threw the exception "the length can't be less than 0" when getting a specific range.
• Fixes the issue that caused incorrect format when converting chart to image.
• Fixes the issue that the application threw the exception "the specified parameter is out of range of valid values" when loading a CSV file.
• Fixes the issue that caused incorrect columns of Pivot Table after adding data.
• Fixes the issue that the formula of trendline could not be obtained correctly.

Spire.SpreadSheet

New Features:

• Implements copying and pasting of multiple areas (including the discontinuous cells with different rows or same rows)
• Implements inserting and deleting multiple rows or columns (can be discontinuous)
• Adds events to insert and delete rows or columns.

AfterInsertRow/AfterIndertColumn
AfterDeleteRow/AfterDeleteColumn

Bug Fixes:

• Fixes the issue that the data of the folded rows could be copied after grouping rows.

Spire.PDF

New Features:

• Supports removing the author of annotation. Note removing the author of caret annotation is not supported at present.

annotation.Author = "";

• Supports specifying page ranges when saving to PDF.

document.SaveToFile(filepath, 0, 3, FileFormat.PDF);

• Supports setting the width of signature name.

signature.SetSignNameWidth(float width);

Bug Fixes:

• Fixes the issue that the PDF document failed to be printed out by color printer.
• Fixes the issue that the invisible layer appeared in SVG after converting PDF to SVG.
• Fixes the issue that getting the page number of bookmark's destination failed.
• Fixes the issue that the content lost after converting EMF to PDF.
• Fixes the issue that the font was changed after converting PDF to Word.
• Fixes the issue that the application threw an exception when finding the character "$" and the positions of some characters were not be returned correctly.
• Fixes the issue that adding hyperlink to image failed.
• Fixes the issue that running the application to convert HTML to PDF with plugin, the second time was longer than the first time.
• Fixes the issue that messy content was caused after converting HTML to PDF with plugin.
• Fixes the issue that related to the timeout when converting HTML to PDF with plugin.
• Fixes the issue that the application threw an exception when converting HTML to PDF with plugin.
• Fixes the issue that incorrect spacing between words was caused after converting HTML to PDF with plugin.
• Fixes the issue that incorrect css style was caused after converting HTML to PDF with plugin.
• Fixes the issue that low quality of content was caused after converting HTML to PDF with plugin.
• Fixes the issue that incorrect table layout was caused after converting HTML to PDF with plugin.
• Fixes the issue that the hyperlink lost after converting HTML to PDF with plugin.
• Fixes the issue that shrunken content was caused after converting HTML to PDF with plugin.
• Fixes the issue that incorrect table header was caused after converting HTML to PDF with plugin.
• Fixes the issue that the application that converts HTML to PDF with plugin didn't work on Azure (64bit).

Spire.Doc

New Features:

• Supports adding Latex math code to Word.

Document doc = new Document();
Section section = doc.AddSection();
Paragraph paragraph = section.AddParagraph();
OfficeMath officeMath = new OfficeMath(doc);
paragraph.Items.Add(officeMath); 
officeMath.FromLatexMathCode("x^{2}+\\sqrt{x^{2}+1}=2");
doc.SaveToFile("latexToDoc", FileFormat.Docx);

• Supports setting MailMergeMainDocumentType as NotAMergeDocument to make the Word as non-mailmerge document when doing MailMerge.

document.MailMerge.MailMergeMainDocumentType = MailMergeMainDocumentType.NotAMergeDocument;

Bug Fixes:

• Fixes the issue that the text overlapped after converting Word to PDF.
• Fixes the issue that using PS method to do conversion from Word to PDF in multi-thread took more time than single thread.
• Fixes the issue that incorrect format was caused after merging Word files.
• Fixes the issue that the application hung when executing SaveToImages method.
• Fixes the issue that there was extra columns when opening the generated ODT by LibreOffice 6.2.3 after converting HTML to ODT.
• Fixes the issue that the application threw "Items with the same key have been added" when merging Word files.
• Fixes the issue that incorrect content format was caused after converting XML to Docx.
• Fixes the issue that overlapped table was caused after converting Word to PDF.
• Fixes the issue that getting FieldValue and ImageFileName of ImageMergeField had differences between old version and new version.
• Fixes the issue that the application threw NullReferenceException when converting Word to PDF.
• Fixes the issue that the application threw “The value is too large or too small for Int32” when loading Word.
• Fixes the issue that incorrect header was caused after modifying .doc file which was generated by Spire.Doc.