New hotfix version for Spire.Office Version 2.13.4

Spire.Office

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

Versions:

Spire.Doc v5.6.75
Spire.PDF v3.6.269
Spire.XLS v7.9.45
Spire.DocViewer.Forms v2.1.65
Spire.PDFViewer.Forms v2.8.52
Spire.Presentation v2.5.22
Spire.DataExport v3.5.69
Spire.Barcode v1.2.9

Free Trial to evaluate Spire.Office v2.13.4 here:

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

Details of New features and Bug solutions:

Spire.Doc

Bug solutions:

Fixes the issue that caused OverflowException when load.
Fixes the issue that caused loss of formats and image when save to PDF.
Fixes the issue that caused exception when convert RTF to PDF.
Resolves the issue that caused blank field when mail merge.
Fixes the issue where INCLUDEPICTURE items wasn't updated when mail merge.
Fixes the issue that caused the exception that password is incorrect when load Word2013 protected document.
Fixes the issue where the position of the bookmark was incorrect when load and save Word 97-2003 file.
Resolves the issue that caused the exception that length cannot be less than zero when load the document.
Fixes the issue that caused IndexOutOfRange exception when save.
Fixes the issue that caused StackOverflowException when load html.
Fixes the issue where the background color of paragraph couldn't be modified when save to doc format.
Resolves the issue that caused ArgumentOutOfRangeException when convert RTF to PDF.
Fixes the issue that caused loss of fonts when convert word to Html.
Fixes the issue that caused messy formatting when print.
Fixes the issue where the indent on cells in table was incorrect when convert doc to rtf.
Fixes the issue that caused Exception in text replacement.
Resolves the issue that caused the result was incorrect when replacing text that contains a hyperlink or a mailto-link.
Fixes the issue that caused the footer lost when convert word to word.
Fixes the issue where the wordcount didn't get the correct value.
Fixes the issue that caused incorrect formatting when convert html to word.
Fixes the issue that caused incorrect formatting when convert html to PDF.
Resolves the issue that caused exception when mailmerge the MergeFields within mathematical functions.
Fixes the issue where Document.GetPageCount method and Document.PageCount property caused the print output incorrect.

Spire.PDF

New feature:

Add the new feature to change the font size of a labeled digital sign.

signature.SignInfoFont.Add(SignInfoType.SignInformation, new PdfFont(PdfFontFamily.Helvetica, 8f, PdfFontStyle.Bold));

Add new feature to edit the Xmpmetadata.

PdfDocument pdfdoc = new PdfDocument();
pdfdoc.LoadFromFile(fileName);
XmpMetadata meta = pdfdoc.XmpMetaData;
//Read
meta.GetAllCustomProperties();
string author = meta.GetAuthor();
//set
meta.SetAuthor("New Value");
//load
XmpMetaData.Load(XmlDocument xmp);

Add the new feature to delete the layer in the PDF.

PdfPageBase.PageLayers.DeleteOldLayer(string layerName);
PdfPageBase.PageLayers.DeleteOldLayer(string layerName, bool isDelAllContent, bool delLayerDocProperties);

Bug Solutions:

Fixes the issue where the Pdf with barcode generated from font was not printed correctly.
Fixes the issue that caused the exception when load a file in a directory with read only permissions.
Resolves the issue that caused exception when load.
Fixes the issue that blank space was deleted when printing.
Fixes the issue that caused exception when print.
Fixes the issue that caused content lost when print a PDF document.
Fixes the issue that caused PDF failed to convert to image.
Fixes the issue that caused InvalidOperationException when load OXPS documents.
Fixes the issue where the XPS wasn't searchable and was much bigger in file size than the corresponding PDF when convert PDF to XPS.
Fixes the issue where Persian and Arabic Text can't be searched.
Resolves the issue that caused the exception when save to Image.
Fixes the issue where a small percentage of text fragments within a document was unable to be found.
Fixes the issue that caused the error when save after applying digital sign to the existing pdf file.
Fixes the issue that caused exception when delete the page that contains bookmark.
Fixes the issue where the output pdf document appeared reversed if the xps contains text with right-to-left flow direction.
Fixes the issue where the PDF version was detected incorrectly.
Fixes the issue that caused Persian word can't be searched using FindText method.
Optimizes the memory leaks when working with PdfFont Object.
Addes UseInvariantCulture property for PdfDocument class to support variant Culture. Improve time consumption in converting PDF to image.
Fixes the issue where PdfDocument.Form was null whereas the pdf has form fields.
Fixes the issue that caused the ArgumentException when replace image in PDF.
Fixes the issue that caused the exception when convert PDF to Image.
Fixes the issue that caused the color incorrect when convert PDF to Image.
Resolves the issue that caused the Argumentexception when replace the image in PDF document.
Fixes the issue that caused NullReferenceException when use InsertPageRange method.
Resolves the issue that caused InvalidOperationException when saving merged PDF.
Fixes the issue where pdf version can't be changed.
Fixes the issue where text was extracted incorrectly with ExtractText method.

Spire.XLS

New Features:

Add new property to remove the macros or not when convert .xlsm to .xlsx.

workbook.HasMacro=true/false;

Add new method to custom text for line chart series data points, which is only for Excel2013.

chart.Series[0].DataPoints.DefaultDataPoint.DataLabels.ValueFromCell = sheet.Range["B5:k5"];

Add new feature to set the IconSetType of conditional formatting.

ConditionalFormatWrapper format = sheet.AllocatedRange.ConditionalFormats.AddCondition();
format.FormatType = ConditionalFormatType.IconSet;
format.IconSet.IconSetType = IconSetType.ThreeTrafficLights1;

Bug solutions:

Fixes the issue where the extra chart sheet was included when convert to PDF.
Fixes the issue where the hidden sheet was included when convert to PDF.
Fixes the issue that caused different colors and styles when convert Chart to image.
Fixes the issue that caused incorrect cell indents when convert sheet to image.
Fixes the issue where checkboxes had been duplicated.
Fixes the issue where the formula of conditional format displayed incorrectly when save to ExcelVersion2003.
Fixes the issue where GetFont() method identified the style incorrectly.
Resolves the issue where the Formulas were not calculating properly while exporting the PDF.
Fixes the issue where set print area as null didn't work.
Fixes the issue that caused KeyNotFoundException when use Spire.Xls.CellStyle functionality.
Fixes the issue that caused sheet to image conversion failed.
Fixes the issue where chart was converted incorrectly when convert to PDF.

Spire.Presentation

New Feature:

Add new method to get all images from a specific slide.

foreach(IShape s in ppt.Slides[0].Shapes)
 {
 if(s is SlidePicture)
 {
 SlidePicture ps = s as SlidePicture;
 ps.PictureFill.Picture.EmbedImage.Image.Save(string.Format("{0}.png",i));
 i++;
 }
 if(s is PictureShape)
 {
 PictureShape ps = s as PictureShape;
 ps.EmbedImage.Image.Save(string.Format("{0}.png",i));
 i++;
 }
 }

Bug solutions:

Fixes the issue where the underlying data can't be opened when insert 25 columns of data into chart.
Improves the quality of images generated.
Fixes the issue that caused error when trying to copy a Slide and insert on the same presentation.

Spire.DocViewer

Fixes the issue that caused Win32Exception.