Spire.Office 4.9.2 is released

We're pleased to annouce the release of Spire.Office 4.9.2. This version brings some wonderful features, such as supporting to delete Macro in PowerPoint 2003 documents, supporting to apply a cell stype to the entire worksheet, and supporting to rotate chart data label in PowerPoint. Meanwhile, a large number of issues have been fixed by this update. More details are as follows.

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.9.10
• Spire.Pdf.dll v5.9.17
• Spire.XLS.dll v9.9.16
• Spire.Presentation.dll v4.9.6
• Spire.Email.dll v2.9.2
• Spire.DocViewer.Forms.dll v4.5.14
• Spire.PdfViewer.Forms.dll v4.9.6
• Spire.PdfViewer.Asp.dll v4.9.6
• Spire.Spreadsheet v3.9.4
• Spire.OfficeViewer.Forms.dll v4.9.2
• Spire.Barcode.dll v3.7.0
• Spire.DataExport.dll v4.1.9
• Spire.DataExport.ResourceMgr.dll v2.1.0
• Spire.Common.dll v2.9.11
• Spire.License.dll v1.3.7

Spire.PDF

Bug Fixes:

• Fixes the issue that the content lost after converting TEXT to PDF.
• Fixes the issue that converting PDF to Word cost a long time.

Spire.Doc

Bug Fixes:

• Fixes the issue that the code "doc.UpdateTableOfContents()" threw an exception when adding line break \n in the paragraph inside a table.
• Fixes the issue that the property HighlightColor returned wrong value when the color was Green or DarkYellow.
• Fixes the issue that the application hung when using the code SaveToImages to convert a file to images.
• Fixes the issue that the application threw ArgumentException when loading a Word file.
• Fixes the issue that the border of table lost after copying table of Word.

Spire.Presentation

New Features:

• Supports setting the size and style of chart marker datapoint.

Presentation ppt = new Presentation();
ppt.LoadFromFile(file);
IChart chart = ppt.Slides[0].Shapes[0] as IChart;
ChartDataPoint dp = new ChartDataPoint(Chart.Series[0]);
dp.Index =0;
//Set size of chart marker datapoint
dp.MarkerSize = 20;
//Set style of chart marker datapoint
dp.MakerStyle = ChartMarkerType.Star;
chart.Series[0].DataPoints.Add(dp);
ppt.SaveToFile(result,FileFormat.Pptx2013);

• Supports deleting macros in PowerPoint 2003 documents.

ppt.DeleteMacros();

• Supports setting rotation angle for chart data lable.

IChart chart = (IChart)ppt.Slides[0].Shapes[0];
ChartDataLabel datalabel = chart.Series[0].DataLabels.Add();
datalabel.ID = 0;
datalabel.RotationAngle = 45;

Bug Fixes:

• Fixes the issue that the bottom border of table lost after saving PPT file.

Spire.XLS

New Features:

• Adds a method to apply the style for a whole worksheet.

CellStyle style = book.Styles.add("newStyle");
style.Color = Color.Pink;
style.Font.Size = 15;
book.Worksheets[0].ApplyStyle(style);

• Add new property "IsWrapText" under the class XlsTextBoxShape to set wrap text.

XlsTextBoxShape.IsWrapText = true;

Bug Fixes:

• Fixes the issue that the application threw an exception when loading an excel file.
• Fixes the issue that the application threw the "StackOverFlowException" when executing CalculateAllValue.
• Fixes the issue that the extracted cell data was incomplete.
• Fixes the issue that the application threw NullReferenceException when loading an Excel file.

Spire.PDFViewer

Bug Fixes:

• Fixes the issue that the searched text was fully covered when it was highlighted with a color.