New Hotfix version for Spire.Office 2.16.27

Spire.Office

With the effort of our development team, today we have released the latest version for Spire.Office Platinum version 2.16.27. In this version, the recent releases of Spire.Doc, Spire.PDF, Spire.XLS, Spire.DocViewer, Spire.PDFViewer, Spire.Presentation, Spire.Email, Spire.DataExport, Spire.Barcode, Spire.Spreadsheet and Spire.OfficeViewer have been included.

Versions:

Spire.Barcode.dll 1.4.12
Spire.DataExport.dll 3.5.131
Spire.Doc.dll 6.2.2
Spire.DocViewer.Forms.dll 2.5.0
Spire.Email.dll 1.1.19
Spire.Pdf.dll 4.2.4
Spire.PdfViewer.Forms.dll 3.2.0
Spire.Presentation.dll 2.9.0
Spire.XLS.dll 8.0.0
Spire.Spreadsheet.dll 2.2.52
Spire.OfficeViewer.Forms.dll 2.16.27

Get the most recent version of Spire.Office v2.16.27 here:

https://www.e-iceblue.com/Download/download-office-for-net-now.html

Details of New features and Bug solutions:

Spire.Doc

New features:

Add Table.ApplyTableStyle method to apply the table style to table and cell.
Exposes the ParagraphBase.StyleName property.
Adds Document.CloneThemesTo method to clone the Themes to destination document when merging files.
Adds the Styles.ApplyDocDefaultsToNormalStyle method to apply the default paragraph format and character format to normal style.
Supports to manipulate OpenDocument Text (ODT) format document.

Bug solutions:

Fixes the issue that caused the content was lost when converting word to PDF.
Fixes the issue that caused the link on the text was lost when converting word to PDF.
Fixes the issue that caused image was shift when converting word to PDF.
Fixes the issue that caused list number was incorrect when converting word to PDF.
Fixes the issue that caused text to wrap was incorrect when converting word to PDF.
Fixes the issue that caused the ArgumentOutOfRangeException error when saving word to PDF.
Fixes the issue that caused content in table was out of table when converting word to PDF with PS conversion method.
Fixes the issue where the hr html tag wasn't recognized.
Resolves the issue that caused application was hang when getting page count.
Resolves the issue where the Section.PageSetup.PageBorderIncludeFooter property didn't work.
Fixes the issue that caused empty line missing when converting Word to PDF.
Fixes the issue that caused some text moved up when converting Word to PDF.
Fixes the issue that the added page number field displays wrong page number when converting Word to PDF.
Fixes the issue that the bullets doesn't convert correctly when saving to text.
Fixes the issue that caused NullReferenceException when converting Word to HTML.
Fixes the issue that the created hyperlink is incorrect.
Fixes the issue that caused the ArgumentOutOfRangeException when saving Word to PDF.
Fixes the issue that the column's content was incorrect when converting Word to PDF.
Fixes the issue that the content was lost when converting Word to PDF.
Fixes the issue that caused the application to hang when using LoadFromStream method.
Fixes the issue where AppendHTML method threw ArgumentOutOfRangeException.
Fixes the issue that the document protection lost.
Fixes the issue that numbered list couldn’t be obtained correctly.
Fixes the issue that the vector graphics lost when converting Word to Html.
Fixes the issue that the column width of table was incorrect when converting Word to PDF.
Fixes the issue that the document couldn’t be saved to .docx format after inserting a hyperlink.
Fixes the issue that caused StackOverflowException when converting Word to PDF.
Fixes the issue that caused NullReferenceException when Loading RTF file.
Fixes the issue where the list numbering is lost when saving Word to PDF.
Fixes the issue that the content added in footnote is missing when saving to .docx file.
Fixes the issue that the updated result in SUM field is incorrect after replacing data.
Fixes the issue that the absolute position of floating TextBox was incorrect after converting to PDF format.
Fixes the issue in which incorrect values were returned from CharacterFormat.HighlightColor and CharacterFormat.TextBackgroundColor properties.
Fixes the issue that the font of field was lost while copying bookmark's TextRange.
Fixes the issue that the text in HYPERLINK field code was lost.
Fixes the issue that the HYPERLINK effect was lost when converting to HTML.
Fixes the issue that the column width of table was incorrect when converting to PDF.
Fixes the issue that System.IndexOutOfRangeException was occured when loading doc document.
Fixes the issue that System.NullReferenceException was occured when using ImportContent method to merge document.
Fixes the issue that the header content was obtained incorrectly when using Document.GetText method.
Fixes the issue that the content in a Word table was not aligned correctly when converted to PDF.
Fixes the issue that the text bold style was lost when converting html to PDF.
Fixes the issue that the table border was lost when converting html to PDF.
Fixes the issue that the table style was incorrect when converting word to PDF.
Fixes the issue that the content was confused when converting word to PDF in UsePSCoversion way.
Fixes the issue that caused the NullReferenceException when using ApplyStyle method.
Fixes the issue that the watermark was lost when adding new watermark to a document with watermark.

Spire.PDF

New features:

Adds the new property PdfDocument.PrintSettings.DocumentName.
Adds a new property PdfLayer.IsShowOnUI to get whether the layer is shown on user interface or not.
Adds the print event doc.PrintSettings.EndPrint.
Supports to extract text from a certain rectangle.
Supports to set Collate when printing.
Adds new method for new plugin to save HTML to PDF stream.
Adds a new feature to return a collection of all text on the page with their bounds.

Bug solutions:

Fixes the issue that caused the text in PdfTextBoxField invisible after merging PDF files.
Fixes the issue that cannot read the KeyWords after loading encrypted document.
Fixes the issue that caused the text overlapping when converting to Image.
Fixes the issue that caused the position of inserted bookmark incorrect when inserting bookmark.
Fixes the issue that the margin is incorrect after printing.
Fixes the issue that caused "Fatal Error at 92916" exception when merging PDF files.
Fixes the issue that the position of signature image is incorrect after saving to image.
Fixes the issue that the position of words is inconsistent when getting coordinates of searched words.
Fixes the issue that the image changed to black after compressing PDF.
Fixes the issue that parts of content got messy when saving PDF to Word.
Fixes the issue that the state of checkbox changed to "checked" after setting the value for textbox.
Fixes the issue that the position of text in textbox changed after updating.
Fixes the issue that the result PDF couldn't be opened via Adobe after using pdf.Form.IsFlatten = true.
Fixes the issue that the space of character was incorrect when converting PDF to Word.
Fixes the issue that collapsing bookmarks didn't work.
Fixes the issue that the extracted image was whiter than the original image in PDF.
Fixes the issue that the line style changed from "solid" to "dotted" when printing PDF.
Fixes the issue that caused PdfException when loading file.
Fixes the issue that some extra blank characters were added when converting HTML to PDF with IE7.
Fixes the issue that the border was missing when printing PDF.
Fixes the issue that the VerifySignature method returns false for valid signature.
Fixes the issue that the ProPhotoRGB profile is lost after drawing image.
Fixes the issue that the timeout is kicking in in some cases when using the Spire.Pdf.HtmlConverter.Qt.HtmlConverter.Convert method to convert the same HTML to PDF many times.
Fixes the issue that the position of the signature image changed after saving PDF to image.
Fixes the issue that the time of getting bookmarks keeps increasing.
Fixes the issue that the border is missing when printing.
Fixes the issue that getting page index of a textbox which is placed on multiple pages is incorrect.
Fixes the issue that the result document cannot be opened successfully after converting .tiff image to PDF.
Fixes the issue that the text in the fields is being cut off at the top after converting the split PDF to image.
Fixes the issue that the result was incorrect when converting PDF to XPS.
Fixes the issue that the function SetButtonImage doesn't work.
Fixes the issue that caused ArgumentNullException when checking the property page.ImagesInfo.
Fixes the issue that caused the exception "can not convert to rectangle" when assigning some text value to form field.
Fixes the issue that the compression ratio for the method TryCompressImage was not high.
Fixes the issue that the whole document is printed empty.
Fixes the issue that the PdfLineAnnotation.Location property returned wrong value.
Fixes the issue that the gradient effect lost when converting PDF to SVG.
Fixes the issue that the PdfAttachmentAnnotation object was drawn at a wrong location.
Fixes the issue that the PageSettings.Orientation property didn't work properly.
Fixes the issue that caused the "Unexpected token Unknown before 8103" exception when loading a file.
Fixes the issue that caused the "Invalid/Unknown/Unsupported format" exception when loading a file.
Fixes the issue that the button field couldn't be added into an existing PDF document.
Fixes the issue that the text was not displayed in its proper position when converting PDF to image.
Fixes the issue that extra black spots were added when converting PDF to image.
Fixes the issue that some texts were garbled when printing a PDF.
Fixes the issue that the result document was blank when converting PDF to PDF/A.
Fixes the issue that the data replacement of attachment in PDF document didn't work.
Fixes the issue that the background color became black when converting to Image.
Fixes the issue that the value of PdfImageInfo bounds always returned 0.
Fixes the issue that the file size increased when inserting stamp.
Fixes the issue that caused the ArgumentException when using VerifySignature method.
Fixes the issue that the result was garbled when extracting text.
Fixes the issue that the BackgroundRegion property didn't work.

Spire.XLS

New features:

Adds Workbook.GetOleSize method to get the displayed size of an embedded Excel OLE object.

Bug solutions:

Fixes the issue that caused ArgumentOutOfRangeException error when loading workbook XML document.
Fixes the issue that the address of conditional formatting was gotten incorrectly.
Fixes the issue that the double quote was parsed incorrectly when converting CSV to Excel.
Fixes the issue that caused the docfile has been corrupted error when loading .xls document.
Fixes the issue that caused application to hang when loading document.
Fixes the issue that caused the error that extended format record fontindex field has wrong value when loading document.
Fixes the issue that caused application to hang when saving chart as image.
Fixes the issue that ConditionalFormatWrapper.DataBar.MinPoint didn't work.
Fixes the issue that caused HideItemDetail method to throw exception when there is a blank item.
Fixes the issue that caused NullReferenceException when launching a GarbageCollector.
Fixes the issue that the shadow property of shape didn't work.
Fixes the issue that the border of the rectangle was lost when converting Excel to PDF.
Fixes the issue that the position of shape was incorrect when converting Excel to PDF.
Fixes the issue that the sheet protecting password was removed when manipulating locked cell.
Fixes the issue that caused the exception that it is not supported for this Vertical Axis type when loading the Excel file.
Fixes the issue that caused the exception when saving empty worksheet.
Fixes the issue that there is extra border for chart title when converting Excel to PDF.
Fixes the issue that the alignment of chart title was changed after converting Excel worksheet to PDF.
Fixes the issue that additional leader line of data label for chart occurs after converting Excel worksheet to PDF.
Fixes the issue that caused InvalidCastException when loading the Excel.
Fixes the issue that the process was freezing when using LoadFromStream to load file.
Fixes the issue that caused exception when calling CalculateAllValue method.
Fixes the issue that the result file has extra data.
Fixes the issue that chart datalable was duplicated when converting Chart to Image.
Fixes the issue that CalculateAllValue method threw an exception.
Fixes the issue that the alignment of chart subtitle was incorrect when converting worksheet to PDF.
Fixes the issue that the font of chart subtitle was incorrect when converting worksheet to PDF.
Fixes the issue that the leader lines of chart was added when converting to PDF.
Fixes the issue that the conditional format was incorrect.
Fixes the issue that formula returned wrong value.
Fixes the issue that the returned value of the sheet counts was incorrect.
Fixes the issue that the retuned value of alternative text of shape was incorrect.
Fixes the issue that the application was hanging when loading a file.
Fixes the issue that the space between words was lost when converting to PDF.
Fixes the issue that the invisible comment can't be set as visible.
Fixes the issue that the horizontal axis position of bar chart was rendered incorrectly when converting to PDF.
Fixes the issue that caused spr2464 exception when converting sheet to Image.
Fixes the issue that caused NullReferenceException when saving to XML.
Fixes the issue that the formula was copied incorrectly when inserting new row.
Fixes the issue that the IgnoreErrorOptions property didn't work.
Fixes the issue that the value of ComboBox control was set incorrectly.
Fixes the issue that caused the exception that Value was either too large or too small for an Int32 when loading.
Fixes the issue that the digit in Chinese character was incorrect when saving to PDF.

Spire.Presentation

New features:

Adds Transparency property for PictureShape class to set or get the picture transparency when using picture fill.
Add SetTableBorder method to set the border of table.
Add BubbleScale property for Chart to scale bubble size of bubble chart.
Add IterateType property for AnimationEffect to set the type of animate text.
Add IterateTimeValue property for AnimationEffect to set the time of animate text.
Supports to manipulate error bars of chart.
Adds HasMultiLvlLbl property to get/set if Category Axis has Multi-level Category Lables.

Bug solutions:

Fixes the issue that caused the SlideNumberVisible property didn't work.
Fixes the issue that caused the NullReferenceException when loading file.
Fixes the issue that caused the embedded fonts lost when converting to Image.
Fixes the issue that caused chart non-editable after the chart was edited with Spire.Presentation.
Fixes the issue that caused the style of pie chart lost when converting to PDF.
Fixes the issue that font bold effect lost when converting to Image.
Fixes the issue that GIF in slide was changed to .PNG image when adding to new presentation.
Fixes the issue that the content of slide was incorrect when appending to new presentation.
Fixes the issue that animation was incorrect when copying slide to new presentation.
Fixes the issue that percentage format setting of chart datalabel had no effect.
Fixes the issue that getting comment was incorrectly.
Fixes the issue that the LeaderLinesVisible property setting didn't work.
Fixes the issue that only the first 10 series was displayed in legend area when series count is more than 10.

Spire.PDFViewer

Bug solutions:

Fixes the issue that caused text overlapping.
Fixes the issue where the alignment of text is incorrect when displaying the PDF file.
Fixes the issue that the warning information appears on generated thumbnail after applying license.
Fixes the issue where the VerticalScroll.Visible property didn't work.
Fixes the issue that the image in the document lost.
Fixes the issue that the background on text lost.
Fixes the issue that extra black marks were displayed.
Fixes the issue that the horizontal scroll bar displayed incorrectly.
Fixes the issue that the document couldn't be switched to other document when using Spire.PDFViewer for ASP.NET.
Fixes the issue that the textbox overlapped when zooming the document using Spire.PDFViewer for ASP. NET.
Fixes the issue that the document couldn't be opened.

Spire.DocViewer

Bug solutions:

Fixes the issue that the middle alignment of content in table was rendered incorrectly.