Spire.Office Hotfix Version 2.16.18 Released

Spire.Office

With the great effort of our Dev team, the hotfix version of Spire.Office 2.16.18 is released today. This release comes up with several fantastic features, such as adding shapes to worksheet, extracting the text segments in PDF by SimpyTextExtractionStrategy, and supporting to search and highlight text using Spire.PDFViewer control. Also, the latest version has done some adjustments to the existing classes and properties, and fixed numerous bugs to improve the stability and performance.

In this version, the most recent version of Spire.Doc, Spire.PDF, Spire.XLS, Spire.Presentation, Spire.Email, Spire.DataExport, Spire.Barcode, Spire.DocViewer, Spire.PDFViewer and Spire.OfficeViewer have been included.

Versions:

Spire.Doc.dll v6.0.23
Spire.Pdf.dll v3.9.375
Spire.XLS.dll v7.12.92
Spire.Email.dll V1.1.9
Spire.DocViewer.Forms.dll v2.4.24
Spire.PdfViewer.Forms.dll v2.12.36
Spire.PdfViewer.Asp.dll v2.12.36
Spire.Presentation.dll v2.8.61
Spire.Spreadsheet.dll v2.2.42
Spire.OfficeViewer.Forms.dll v2.16.18
Spire.DataExport.dll v3.5.133
Spire.DataExport.ResourceMgr.dll 1.6.71
Spire.Common.dll 1.2.730
Spire.License.dll v1.3.6
Spire.Barcode.dll v1.4.8

Get Spire.Office v2.16.18 from here:

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

Details of new features and bug fixes:

Spire.XLS

New Features:

Supports to add shapes to worksheet.

sheet.PrstGeomShapes.AddPrstGeomShape(int row,int column,int width,int height,PrstGeomShapeType shapeType);

Supports to select the cell range to be visible when displayed as an OLE object.

Workbook.SetOleSize(firstRow,firstColumn,lastRow,lastColumn);

Bug Fixes:

Fixes the issue that the result document changed to Protected View after saving .xlsx to .xls.
Fixes the issue that caused ArgumentOutOfRangeException when converting Excel to HTML.
Fixes the issue that caused the style of the chart missing when using SaveChartAsImage method.
Fixes the issue that caused the font changed when converting Excel to PDF.
Fixes the issue that caused the data format incorrect when converting Excel to pdf.
Fixes the issue that caused the formula result wrong in French environment.
Fixes the issue that caused result incorrect when getting the validation formula value.
Resolves the issue that caused Euro (€) sign lost when using DisplayedText property.
Fixes the issue that the value in the original cell range changed along with value which was set by range.Text property in the copied range.
Fixes the issue that caused IndexOutOfRangeException when loading file.
Fixes the issue that caused the process hanging when converting Excel to PDF.
Fixes the issue that caused the value type changed from text to number when importing data from datatable to Excel.
Fixes the issue that the method AutoFitColumns didn't work.

Spire.PDF

New Features:

Supports to print specific page.

PdfDocument doc = new PdfDocument();
doc.LoadFromFile(filename);
doc.PrintSettings.SelectSomePages(new int[]{2,4});
doc.Print();

Exposes the name property of the layer.

string name = doc.Layers[0].Name;

Supports to set the alignment for the signature content.

signature.SignTextAlignment=SignTextAlignment.Right;

Supports to get the text by document structure.

PdfDocument doc = new PdfDocument();
doc.LoadFromFile("Alcontrol - EDF.pdf");
PdfPageBase page = doc.Pages[0];
SimpleTextExtractionStrategy strategy = new SimpleTextExtractionStrategy();
string text = page.ExtractText(strategy);
FileStream fs = new FileStream("Alcontrol - EDF.txt", FileMode.Create);
StreamWriter sw = new StreamWriter(fs);
sw.Write(text);
sw.Flush();

Adjustments:

The PrintDocument object has been marked as obsolete, it only needs to set the PrintSettings when print. Example:

PdfDocument doc = new PdfDocument("sample.pdf");
doc.PrintSettings.Landscape = true;
doc.Print();

The pageLayers object of Page has been marked as obsolete, use Layers object under PdfDocument instead. It must create the Graphics for the Layer with the CreateGraphics method when Add Layer. Example:

PdfLayer layer = doc.Layers.AddLayer("red line", PdfVisibility.On);
PdfCanvas pcA = layer.CreateGraphics(doc.Pages[0].Canvas);
pcA.DrawLine(new PdfPen(PdfBrushes.Red, 1), new PointF(0, 100), new PointF(100, 100));
layer = doc.Layers.AddLayer("blue line");
PdfCanvas pcB = layer.CreateGraphics(doc.Pages[0].Canvas);
pcB.DrawLine(new PdfPen(PdfBrushes.Blue, 1), new PointF(0, 150), new PointF(100, 150));

Bug Fixes:

Fixes the issue that cannot delete layer.
Fixes the issue that caused the character wrong after deleting image.
Fixes the issue that the image cannot be deleted.
Fixes the issue that caused NullReferenceException when flatten form field.
Fixes the issue that the checkboxField is not checked after setting checkboxField.Checked as true.
Fixes the issue that caused content missing after replacing image.
Fixes the issue that caused the content in invisible region shows after creating Booklet.
Fixes the issue that caused the original content changed when appending a new page.
Fixes the issue that the object cloned from PdfDocument returns null.
Fixes the issue that caused the size of document increased after compressing images.
Fixes the issue that caused the background changed to black when converting PDF to XPS.
Fixes the issue that the size of document grows too much when converting image to pdf.
Fixes the issue that caused spot colors setting in image missing when drawing image to PDF.
Fixes the issue that custom properties don't work.
Fixes the issue that cannot delete custom properties.
Fixes the issue that caused small drilling holes missing when printing the PDF.
Fixes the issue that custom properties missing after setting own password.

Spire.Doc

Bug Fixes:

Fixes the issue that the path in INCLUDEPICTURE filed was incorrect after Mail Merge.
Fixes the issue that caused ArgumentOutOfRangeException when converting Word to PDF.
Fixes the issue that replace OLE data doesn't work.
Fixes the issue that caused extra lines when converting Word to HTML.
Fixes the issue that caused EndOfStreamException when loading a document.
Fixes the issue that caused the process hanging when using document.PageCount.
Fixes the issue that caused the text format changed to bold when converting Word to HTML.
Fixes the issue that caused extra black shade in table cell when converting Word to HTML.
Fixes the issue that caused the "The format of input string was incorrect" exception while loading HTML.
Fixes the issue that the list was incorrect after converting HTML to Word.
Fixes the issue that caused the style missing when converting HTML to Word.
Fixes the issue that caused one line changed to two lines after saving Word to PDF.

Spire.Presentation

New features:

Adds ShowMasterShape property for Slide to hide background graphics.
Adds new overloaded Print method to support to use the printdocument object.

public void Print(PresentationPrintDocument presentationPrintDocument);

Exposes the TriggerShape property of InteractiveSequences.

Bug Fixes:

Fixes the issue where list items returned with no bullets or any kind of list formatting when inserting a HTML list.
Fixes the issue where the Animation/Transition time can't be set.
Fixes the issue that caused the table formatting of chart data lost.
Fixes the issue that caused the major units of Chart Axis incorrect when converting PPT with chart to Image.

Spire.PDFViewer

New features:

Add SearchText method in pdfDocumentViewer class to search and highlight text.

Spire.Spreadsheet

Bug Fixes:

Fixes the issue that caused NullReferenceException when opening a document.
Fixes the issue that caused image lost when displaying.
Fixes the issue that caused the border missing when displaying.
Fixes the issue that the sort&filter button displayed improperly.

Spire.Barcode

Bug Fixes:

Fixes the issue that when viewing the barcode from web page, it caused InvalidCastException after editing Barcode DpiX or DpiXY directly via BarCodeControl on Web Forms.
Fixes the issue that the generated barcode was blank when the barcode contains more than ten Arabic letters.

Spire.DocViewer

Bug Fixes:

Fixes the issue where the document displayed incompletely.