Spire.Office Hotfix Version 2.16.12 Released

Spire.Office

With the great effort of our development team, the hotfix version of Spire.Office 2.16.12 is released today. In this version, the most recent version of Spire.Doc, Spire.PDF, Spire.XLS, Spire.Presentation, Spire.Email (new product), Spire.DataExport, Spire.Barcode, Spire.DocViewer, Spire.PDFViewer and Spire.OfficeViewer are included.

Versions:

Spire.Doc.dll v5.9.69
Spire.Pdf.dll v3.9.290
Spire.Xls.dll v7.12.72
Spire.Email.dll v1.1.4
Spire.DocViewer.Forms.dll v2.4.16
Spire.PdfViewer.Forms.dll v2.12.24
Spire.PdfViewer.Asp.dll v2.12.24
Spire.Presentation.dll v2.8.41
Spire.Spreadsheet v2.2.34
Spire.OfficeViewer.Forms.dll v2.16.12
Spire.DataExport.dll v3.5.133
Spire.Barcode v1.4.6

Get Spire.Office v2.16.12 from here:

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

Details of new features and bug fixes:

Spire.XLS

New Feature:

Supports to add custom document properties.

Workbook workbook = new Workbook();
workbook.CustomDocumentProperties.Add("_MarkAsFinal", true);
workbook.CustomDocumentProperties.Add("The Editor", "E-iceblue");
workbook.CustomDocumentProperties.Add("Phone number1",81705109);
workbook.CustomDocumentProperties.Add("Revision number", 7.12);
workbook.CustomDocumentProperties.Add("Revision date", DateTime.Now);
workbook.SaveToFile(outputFile, FileFormat.Version2010);

Bug Fixes:

Fixes the issue that caused XmlException when using SaveAsImage method.
Fixes the issue that the data in the shape isn't updated after editing data.
Fixes the issue that the result PDF converted from Excel prompts message "Cannot extract the embedded font. 'FAACFG+ArialMT'. Some characters may not display or print correctly." when fast flip.
Fixes the issue that caused ArgumentOutOfRangeException when loading file.
Fixes the issue that caused wrong content when converting to PDF.
Fixes the issue that the value in tag was incorrect after protecting cell.
Fixes the issue that the displaying way for the value of the datalabels in chart changed from two lines to one line after converting Excel to PDF.
Fixes the issue that caused content missing when adding watermark.
Fixes the issue that the image in Group cannot be extracted.
Fixes the issue that the hidden row was visible on HTML when converting to HTML.
Fixes the issue that caused wrong value "#NAME" after using the InsertDataTable method.
Fixes the issue that caused exception "Workbook is protected and password wasn't specified.", yet the document doesn't have opening password.
Fixes the issue that caused GDI+ exception after adding picture.
Fixes the issue that caused wrong paging when converting to PDF.
Fixes the issue that caused XmlException when loading file.
Fixes the issue that caused graph missing when converting to PDF.
Fixes the issue that the images are rotated when converting to PDF.
Fixes the issue where the position of the shapes are wrong when converting to PDF.
Fixes the issue that caused stretched image when converting to PDF with the Region(Spain) and Language(Chile) setting.
Fixes the issue that caused ArgumentException when loading .xlsm file.
Fixes the issue that the code "comment.AutoSize = true" doesn't work.
Fixes the issue that caused black background when saving sheet to pdf.
Fixes the issue that caused graph missing when converting Excel to PDF.
Fixes the issue that caused slicer missing when saving .xlsm file.

Spire.PDF

New Features:

Supports to convert single page to svg.

public void SaveToFile(string filename, int startIndex, int endIndex, FileFormat fileFormat);

Supports to find the whole words only.

public PdfTextFindCollection FindText(String searchPatternText, bool isSearchWholeWord);

Supports to use another way to fill image object into the signature field.

signature.ConfiguerGraphicImage = PdfImage;

Supports to convert PDF to SVG stream.

PdfDocument.SaveToStream(FileFormat.SVG);

Supports to convert PDF to HTML.
Adjustment of the properties of PdfSignature class.

Bug Fixes:

Fixes the issue that caused the image profile lost when converting image to PDF.
Fixes the issue where some readers showed certain checkboxes to be unchecked except chrome.
Fixes the issue where all the radio buttons were in selected state when converting to PDF/A.
Resolves the issue where the Combobox field values were not displayed.
Fixes the issue where the images on the pdf file was improperly getting placed when printing.
Fixes the issue where the icon on the ButtonField was improperly getting placed.
Resolves the issue that caused the exception that page index is out of the range of the pages in the document.
Fixes the issue that caused the logo image incorrect when printing.
Fixes the issue that caused the Stamp lost when printing.
Fixes the issue that the content missing when converting PDF to XPS.
Fixes the issue that cuased ArgumentException when using FindText method.
Fixes the issue that the method DrawTemplate doesn't work.
Fixes the issue that caused incorrect content when converting PDF to XPS.
Fixes the issue that cannot delete layers.
Fixes the issue where the image is wrong when converting XPS to PDF.
Fixes the issue that the the currency symbol and the amount are broken when there is line feed.
Fixes the issue that the content copied from PDF is incorrect when converting XPS to PDF.
Fixes the issue that the postion of the text is wrong when printing.
Fixes the issue that caused exception when get the used font.
Fixes the issue that caused exception when load certificate to sign PDF on Azure.
Fixes the issue that Calculate action didn't work.
Fixes the issue that the extra signature field was added into document automatically after signing signature field.
Fixes the issue that the setting of orientation when printing didn't wrok.
Fixes the issue that the value of combox field was blank when clicking view this version in Adobe after filling the combox field and signing the signature field.
Fixes the issue that caused the NullReferenceException when loading PDF file.
Fixes the issue that caused the NullReferenceException when converting to image.
Fixes the issue that the SetButtonImage property doesn't work.
Fixes the issue that caused inaccuracy position of found text for when finding text.
Fixes the issue that caused incorrect content when converting xps to pdf.
Fixes the issue that cannot get font after finding text.
Fixes the issue that the position of text changed when converting pdf to xps.
Fixes the issue that the postion of the content is wrong when printing.
Fixes the issue that the line missing when printing.
Fixes the issue that the values of combox field are blank when clicking view this version in Adobe with Italy and Italian setting in computer after filling the combox field and signing the signature field.
Fixes the issue that caused messy code in text field after merging files.
Fixes the issue that caused FormatException when extracting text.
Resolves the issue where the color filled in graph is incorrect when saving to image.
Fixes the issue that caused NullReferenceException when converting to image.
Fixes the issue that caused checked status for other name checkboxes after checking one checkbox.
Fixes the issue that caused text missing when converting PDF to XPS.
Fixes the issue where the paragraph number and heading text were swapped round when extracting text.
Improve the print function to make the prined result be same as what Adobe prints.
Fixes the issue that caused char spacing in flattened field incorrect when saving to Image.
Fixes the issue that caused some Chinese characters cannot be printed when printing.

Spire.Doc

Bug Fixes:

Fixes the issue that caused the language of spelling check change when appending rtf text.
Fixes the issue that caused the border of table thicker when appending rtf text.
Resolves the issue that caused the format incorrect when converting to PDF.
Fixes the issue where the bulleted list had extra line space between each other while converting from HTML to word.
Improve the function of converting Word document to PDF.
Fixes the issue that caused the NullReferenceException when saving Word to HTML.
Fixes the issue that caused the ArgumentOutOfRangeException when geting the page count.
Fixes the issue that caused the exception "Object reference not set to an instance of an object" when loading RTF file.
Fixes the issue where the hyperlink in table was missing after merging files.
Fixes the issue that cuased StackOverflowException when converting Word to PDF.
Fixes the issue that caused the process hanging when converting to PDF.
Fixes the issue that caused wrong TOC after merging files.
Fixes the issue that the style and font of the text in header changed after merging files.
Fixes the issue where the layout of paragraphs is wrong when converting to PDF.
Fixes the issue that caused text missing when converting Word to PDF.
Fixes the issue that caused the exception "Parameter is not valid" when converting Word to PDF on Azure.
Fixes the issue that cuased the table border lost when converting to PDF.
Fixes the issue that caused additional blank pages when converting to PDF.
Fixes the issue where the image is truncated when converting to PDF.
Fixes the issue that caused additional border when converting to PDF.
Fixes the issue that caused IndexOutOfRangeException when using InsertTextFromFile method.
Fixes the issue that caused ArgumentOutOfRangeException when using the html that includes list tag to mail merge.
Fixes the issue that caused incorrect values in IF field after mail merge.
Fixes the issue that caused extra header and footer in pdf when converting rtf to PDF.
Fixes the issue that caused the exception "ShapePr 391 keys no implementation" after setting background picture.
Fixes the issue where only word ole object can be opened when appending various ole objects.
Fixes the issue where the distance between text in cell and near cell was incorrect when saving to pdf.

Spire.Presentation

New Features:

Supports to access the layout slide of master.

IMasterSlide master = ppt.Masters[0];

Supports to get or set the layout.

IMasterLayouts masterLayouts = master.Layouts;
ActiveSlide layoutSlide = masterLayouts[0] as ActiveSlide;

Supports to add a new slide with specific layout from master.

ppt.Slides.Append(ppt.Slides[0],ppt.Masters[0].Layouts[1]);

ppt.Slides.Insert(0, ppt.Slides[0],ppt.Masters[0].Layouts[1]);

Supports to set the width/height of table.

table.TableRows[0].Height = value;
table.ColumnsList[0].Width = value;

Bug Fixes:

Fixes the issue that caused wrong composing when converting PPT to Image.
Fixes the issue that caused exception "spr⁹ was unhandled" when appending slide.
Fixes the issue that caused chart missing when converting PPT to image on Azure.
Fixes the issue that caused exception "The format of the input string is incorrect" when loading file.
Fixes the issue that caused wrong format when converting PPT to image.
Fixes the issue that caused the shadow missing when converting PPT to image.
Fixes the issue that the background of shape changed from transparency to white.

Spire.PDFViewer

New Features:

Supports to set the background color of the viewer.

Bug Fixes:

Fixes the issue that caused image missing when viewing PDF document.
Fixes the issue caused the color of background changed from gray to white when view ing PDF document.
Fixes the issue that caused content fuzzy.
Fixes the issue that caused gradient color when viewing PDF document.