Spire.Office 5.1 is released

We're pleased to announce the release of Spire.Office 5.1. This update has some new features, such as Spire.XLS supports converting entire workbook to Html and setting copy options when copying, Spire.PDF supports getting the value of PrinterResolutionKind and the button style of RadioButton, Spire.Presentation supports getting and setting the name of the slide. Meanwhile, some bugs that occurred when loading, converting and manipulating Excel, PDF,Word and Presentation documents are fixed successfully. See the content below for the complete lists of new features and bug fixes.

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.Barcode.dll 4.1.0
• Spire.Common.dll 3.1.3
• Spire.DataExport.dll 4.1.9
• Spire.Email.dll 3.1.0
• Spire.Doc.dll 8.1.3
• Spire.DocViewer.Forms.dll 5.1.1
• Spire.Pdf.dll 6.1.4
• Spire.PdfViewer.Asp.dll 5.1.1
• Spire.PdfViewer.Forms.dll 5.1.1
• Spire.XLS.dll 10.1.1
• Spire.Presentation.dll 5.1.3
• Spire.Spreadsheet.dll 4.1.0
• Spire.OfficeViewer.Forms.dll 5.1.1
• Spire.License.dll 1.3.8

Spire.Spreadsheet

Bug Fixes:

• Fixes the issue that the content displayed incorrectly when viewing a document.
• Fixes the issue that the bold text was cut when viewing a document.
• Fixes the issue that some text was missing when the text in the cell is too long.
• Fixes the issue that the columns were missing after minimizing and then restoring the form.

Spire.XLS

New Features:

• Supports converting entire workbook to Html.

Workbook.SaveToHtml(string fileName);

• Supports setting copy options when copying.

CopyRangeOptions copyOptions = CopyRangeOptions.OnlyCopyFormulaValue;
CellRange.Copy(destRange, copyOptions);
WorkSheet.Copy(sourceRange, destRange, copyOptions);

Bug Fixes:

• Fixes the issue that the Bubble chart cannot be created.
• Fixes the issue that the application threw KeyNotFoundException when removing styles.
• Fixes the issue that the content was incorrect after converting Excel to PDF.
• Fixes the issue that the application threw OverflowException when loading a file.
• Fixes the issue that the content was missing after converting Excel to PDF.
• Fixes the issue that the leading 0 of the text was missing when using Marker Designer function.

Spire.PDF

New Features:

• Supports getting and setting author and creation date of stamp.

stamp.Author = "E-iceblue";
stamp.CreationDate = DateTime.Now;

• Supports getting the value of PrinterResolutionKind.

PdfPrinterResolutionKind value = doc.PrintSettings.PrinterResolutionKind;

• Supports getting the button style of RadioButton.

PdfDocument doc = new PdfDocument(@"..\toPDF.pdf");
            PdfFormWidget formWidget = doc.Form as PdfFormWidget;
            for (int i = 0; i < formWidget.FieldsWidget.List.Count; i++)
            {
                PdfField field = formWidget.FieldsWidget.List[i] as PdfField;
                if (field is PdfRadioButtonListFieldWidget)
                {
                    PdfRadioButtonListFieldWidget radio = field as PdfRadioButtonListFieldWidget;
                    PdfCheckBoxStyle buttonStyle = radio.ButtonStyle;
                }
            }

Bug Fixes:

• Fixes the issue that the text extracted from PDF was incorrect.
• Fixes the issue that caused large memory consumption when finding text.
• Fixes the issue that after signing PDF in .NET Core application, the application threw the "lost private key" exception when saving the signed PDF.
• Fixes the issue that the speed of conversion from PDF to Word was slow.
• Fixes the issue that caused incorrect content after converting PDF to Word.
• Fixes the issue that caused incorrect content after converting XPS to Word.
• Fixes the issue that the application threw the "An object reference is not set to an object instance" when extracting text from PDF.
• Fixes the issue that the application threw the "Index was outside the bounds of the array" when saving PDF pages to images.
• Fixes the issue that the content filled in form field didn't display in browser.
• Fixes the issue that the annotation can't be added in the location of image.
• Fixes the issue that caused incorrect format of centered text in textbox after flattening form fields.
• Fixes the issue that after filling textbox field, the generated PDF prompted "This document enabled extended features in Adobe Acrobat." when opening in Adobe.
• Fixes the issue that the height property of bounds of text was negative value.
• Fixes the issue that the application threw the "ArguementException" when printing PDF.

Spire.Doc

Bug Fixes:

• Fixes the issue that the right margin of the page increased after converting Word to PDF.
• Fixes the issue that the format was incorrect after converting Word to PDF.
• Fixes the issue that the result file cannot be opened after cleaning the section breaks in Word file.
• Fixes the issue that the text overlapped after converting Word to PDF.
• Fixes the issue that the application threw ArgumentException when converting Word to PDF.
• Fixes the issue that the result file cannot be opened after merging files.
• Fixes the issue that the shape was missing after adding a shape in created file and converting to image.
• Fixes the issue that the bullets were wrong after converting Word to PDF.
• Fixes the issue that the application threw NullReferenceException when converting Word to PDF.
• Fixes the issue that the format of content was incorrect after converting Word to image.
• Fixes the issue that the fields updated incorrectly after converting Word to PDF.
• Fixes the issue that the result file cannot be opened after merging files.
• Fixes the issue that the application threw NullReferenceException when converting Word to image.

Spire.Presentation

New Features:

• Supports getting and setting the name of the slide

String title = ppt.Slides [0] .Title;

Bug Fixes:

• Fixes the issue that the format was incorrect when converting PPT documents to PDF documents.
• Fixes the issue that the content position was inconsistent when converting PPT documents to PDF documents.
• Fixes the issue that the coordinate axis data lost when converting PPT documents to PDF documents.
• Fixes the issue that the data label position was incorrect when converting PPT documents to PDF documents.
• Fixes the issue that the rounded rectangle style of the data label was lost when converting PPT documents to PDF documents.

Spire.DocViewer

Bug Fixes:

• Fixes the issue that the program hanged when opening a Doc document.
• Fixes the issue that text moved up.
• Fixes the issue that it threw an error "value cannot null" when loading a Docx document.

Spire.PDFViewer

Bug Fixes:

• Fixes the issue that the numbers and punctuation in documents were replaced by small boxes.
• Fixes the issue that document content lost.