Spire.Office 4.12.6 is released

We're pleased to announce the release of Spire.Office 4.12.6. This version comes up with some fantastic new features, such as Spire.XLS supports retaining the filtered data when converting Excel to CSV, Spire.Presentation adds new methods to replace text and to highlight specified text, Spire.PDF supports setting tab order, getting the font information of searched text and printing to booklet, Spire.Doc supports changing the checkbox state symbol and inserting gutter, Spire.Spreadsheet adds a new method to clear records. Additionally, this update also fixes a series of bugs that occurred when loading, converting and manipulating Excel, PowerPoint, PDF and Word documents. 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.12.23
• Spire.Pdf.dll v5.12.16
• Spire.XLS.dll v9.12.20
• Spire.Presentation.dll v4.12.13
• Spire.Email.dll v2.11.11
• Spire.DocViewer.Forms.dll v4.5.29
• Spire.PdfViewer.Forms.dll v4.12.9
• Spire.PdfViewer.Asp.dll v4.12.9
• Spire.Spreadsheet.dll v3.12.1
• Spire.OfficeViewer.Forms.dll v4.12.6
• Spire.Barcode.dll v3.12.0
• Spire.DataExport.dll v4.1.9
• Spire.DataExport.ResourceMgr.dll v2.1.0
• Spire.Common.dll v2.12.13
• Spire.License.dll v1.3.8

Spire.XLS

New Features:

• Supports retaining the filtered data when converting Excel to CSV.

worksheet.SaveToStream (Stream stream, string separator, bool retainHiddenData);
workbook.SaveToFile(string fileName,FileFormat fileFormat , bool retainHiddenData);
worksheet.SaveToFile(string fileName, string separator , bool retainHiddenData);

Bug Fixes:

• Fixes the issue that setting the row height using the values that are stored in a dynamic list didn't take effect in Excel file.
• Fixes the issue that the formula "=COUNTIF(Q2:Q1839,\"New South Wales\") " could not be calculated successfully.
• Fixes the issue that the application threw the exception "An item with the same key has been added" when loading an Excel.
• Fixes the issue that getting the AlternativeTextTitle of picture returned null.
• Fixes the issue that incorrect chart format was caused after converting Excel to PDF.
• Fixes the issue that the application threw the exception "ArgumentOutOfRangeException" when getting the ChartSheet.
• Fixes the issue that messy content was caused after converting Excel to PDF.
• Fixes the issue that using the method pivotTable.DataFields.Clear() to clear the data fields of pivot table didn't take effect.
• Fixes the issue that the drop-down box was missed.
• Fixes the issue that the worksheet.IsEmpty returned incorrect results.
• Fixes the issue that it threw the exception "the object reference was not set to the object instance" when loading an Xlsx file.
• Fixes the issue that the worksheet.IsPasswordProtected returned incorrect results.
• Fixes the issue that the content was incorrect when converting from Excel to PDF.
• Fixes the issue that the speed was slow when using Filter() method to filter.
• Fixes the issue that it threw the exception “ArgumentOutOfRangeException” when loading an Xlsm file.
• Fixes the issue that it threw the exception “The specified parameter has exceeded the range of valid value “when copying a sheet by using the workbook.Worksheets. AddCopy (sheet) method.
• Fixes the issue that the image was shrunk when converting Excel to PDF.
• Fixes the issue that it threw “XmlException” when loading an Xlsx file.
• Fixes the issue that the content was missed when converting from an Xlsm file to PDF.
• Fixes the issue that the additional content appeared when converting an Xlsx file to PDF.

Spire.Presentation

New Features:

• Adds ReplaceFirstText and ReplaceAllText methods to replace text.

ReplaceFirstText(string matchedString, string newValue, bool caseSensitive);
ReplaceAllText(string matchedString, string newValue, bool caseSensitive);

• Supports setting the rotation angle of the chart title.

chart.ChartTitle.TextProperties.RotationAngle=-30;

• Supports highlighting the specified text.

IAutoShape shape=ppt.Slides[0].Shapes[0] as IAutoShape
TextHighLightingOptions options=new TextHighLightingOptions();
options.CaseSensitive =true;
options.WholeWordsOnly=true;
shape.TextFrame.HightLightText("text",Color.Red,options);

• Supports setting the type of the coordinate axis.

chart.PrimaryCategoryAxis.AxisType = Spire.Presentation.Charts.AxisType.DateAxis;
chart.PrimaryCategoryAxis.MajorUnitScale = ChartBaseUnitType.Months;

• Supports setting "until end of slide" for animation timing.

effect.Timing.AnimationRepeatType = AnimationRepeatType.UtilEndOfSlide;

Bug Fixes:

• Fixes an issue that loading an encrypted pptx document failed.
• Fixes an issue that converting PPT containing video to Html failed.
• Fixes an issue that using the method AddNodeByPosition to insert a new node at the specified SmartArt node location failed.
• Fixes an issue that copying chart in the same PPT file failed.
• Fixes an issue that setting additional information in PPT to show or hide failed.
• Fixes an issue that IsVaryColor property was invalid.
• Fixes an issue that the size of the table included in the slide also became larger after increasing the size of the slide.
• Fixes the issue that the date format was incorrect after the setting chart category axis.
• Fixes the issue that the content format was incorrect after converting PPT(X) to PDF.
• Fixes the issue that the color series were incorrect after converting PPT(X) to PDF.
• Fixes the issue that the exception appeared when adding Html to shapes.
• Fixes the issue that the rotation of DataLabels didn’t remain after converting PPT(X) to PDF.
• Fixes the issue that there was the exception "NullReferenceException" when reading the table height.
• Fixes the issue that there was the exception "IndexOutOfRangeException" when adding Html.
• Fixes the issue that the content was lost after converting PPT(X) to PDF.

Spire.PDF

New Features:

• Supports setting Tab Order.

doc.FileInfo.IncrementalUpdate = false;
PdfPageBase page = doc.Pages[0];
page.SetTabOrder(TabOrder.Structure);

• Supports expanding or collapsing specific bookmark.

doc.Bookmarks[1].ExpandBookmark = true;
(doc.Bookmarks[0] as PdfBookmarkCollection)[0].ExpandBookmark = true;

• Supports getting the font information of the extracted text.

PdfTextFindCollection text = pdf.Pages[0].FindAllText();
foreach (var font in text.Finds)
{
string fontName = font.FontName ;
}

• Supports printing to booklet.

doc.PrintSettings.SelectBookletLayout();
doc.PrintSettings.SelectBookletLayout(PdfBookletSubsetMode bookletSubset);
doc.PrintSettings.SelectBookletLayout(PdfBookletBindingMode bookletBinding);
doc.PrintSettings.SelectBookletLayout(PdfBookletSubsetMode bookletSubset, PdfBookletBindingMode bookletBinding);

• Supports setting the image to fill the button field area.

pdfButtonField.IconLayout.ScaleMode = PdfButtonIconScaleMode.Anamorphic;

Bug Fixes:

• Fixes the issue that the application threw ArgumentException when extracting text from page.
• Fixes the issue that the format was wrong after converting PDF to Word.
• Fixes the issue that there were extra blank pages after merging PDF files.
• Fixes the issue that the position of the signature was incorrect after signing.
• Fixes the issue that the application threw NullReferenceException when encrypting PDF file.
• Fixes the issue that stamp size was incorrect after creating template.
• Fixes the issue that the layer content was still visible after removing the layer.
• Fixes the issue that the content was missing after converting PDF to TIFF.
• Fixes the issue that the print result was incorrect after selecting booklet layout.
• Fixes the issue that the order of extracting PDF text content is incorrect.
• Fixes the issue that it threw “KeyNotFoundException” when converting PDF to image.
• Fixes the issue that the words at the end of text were truncated when drawing long text.
• Fixes the issue that it threw “FormatException” when printing PDF.
• Fixes the issue that the content was lost when converting PDF to image.
• Fixes the issue that it threw the error "Object reference is not set to an object instance" when setting fonts.
• Fixes the issue that the file content could not be copied when converting XPS to PDF
• Fixes the issue that the printed document was garbled.
• Fixes the issue that the process threw KeyNotFoundException when converting PDF to image.
• Fixes the issue that getting pdf page failed.
• Fixes the issue that adding digital signature failed.
• Fixes the issue that the process threw IndexOutOfRangeException when extracting text.
• Fixes the issue that the printed PDF document content was disorder.
• Fixes the issue that the content was incorrect when converting XPS to PDF.

Spire.Doc

New Features:

• Supports changing the checkbox state symbol.

sdtCheckBox.CheckedStateFontName = "Calibri";
sdtCheckBox.CheckedStateCharacterCode = 8730;
sdtCheckBox.UnCheckedStateFontName = "Calibri";
sdtCheckBox.UnCheckedStateCharacterCode = 9675;

• Supports inserting gutter.

section.PageSetup.Gutter = 100f;

Bug Fixes:

• Improves the speed of Word to PDF conversion.
• Fixes the issue that the content was missing after converting Word to PDF/A-1a.
• Fixes the issue that the layout of result PDF was incorrect after converting Word to PDF.
• Fixes the issue that application threw the ArgumentOutOfRangeException when saving to PDF after replacing text.
• Fixes the issue that the font in result file was showed incorrectly in LibreOffice after converting to ODT file.
• Optimizes the Garbage disposal.
• Fixes the issue that the application threw KeyNotFoundException when saving file.
• Fixes the issue that the text was overlapped after converting Word to PDF.
• Fixes the issue that the direction of Arabic text changed after converting Word to PDF.
• Fixes the issue that the application threw the ArgumentOutOfRangeException when converting HTML to Word.
• Optimizes the speed of converting a Word file to PDF.
• Fixes the issue that the application threw NullReferenceException when loading a Word file.
• Fixes the issue that the tag was lost after converting Word to HTML.
• Fixes the issue that the application threw IndexOutOfRangeException when converting a Word file to PDF stream.
• Fixes the issue that the application threw NotSupportedException when replacing bookmark content.
• Fixes the issue that the content was lost after converting Word to PDF.
• Fixes the issue that the application threw NullReferenceException when converting Word to PDF.
• Fixes the issue that filling data could not be obtained after executing mail merge function.
• Fixes the issue that the text overlapped after adding header and footer.

Spire.SpreadSheet

New Features:

• Adds ClearStack () method to clear records.

private void button1_Click(object sender, EventArgs e)
{
 this.spreadsheet1.LoadFromFile(@"test.xlsx");
this.spreadsheet1.ClearStack();
}

Bug Fixes:

• Fixes the issue that some border lines were missing when viewing a document.
• Fixes the issue that the obtained value is incorrect after formatting the cell.
• Fixes the issue that content displayed repeatedly when the data content exceeds the cell length.