Spire.Office 5.4.2 is released

We're pleased to announce the release of Spire.Office 5.4.2. This version includes dlls that can support MonoAndroid and Xamarin.iOS platforms and some new features, such as Spire.XLS supports showing and not showing subtotals of PivotTable, Spire.Presentation supports Right-to-left columns and drawing line segments by the position of two points, Spire.Spreadsheet supports to custom sort. Moreover, some issues that occurred when printing PDF, converting PDF to XPS, Word to PDF, Excel to Image/PDF, PPT to PDF and calculating formula value are fixed successfully. See the content below for more details.

In this version, the most recent versions 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 Versions:

• Spire.Doc.dll v8.4.7
• Spire.Pdf.dll v6.4.11
• Spire.XLS.dll v10.4.9
• Spire.Email.dll v3.3.0
• Spire.DocViewer.Forms.dll v5.1.1
• Spire.PdfViewer.Forms.dll v5.1.4
• Spire.PdfViewer.Asp.dll v5.1.4
• Spire.Presentation.dll v5.4.2
• Spire.Spreadsheet v4.3.3
• Spire.OfficeViewer.Forms.dll v5.4.2
• Spire.Barcode.dll v4.4.0
• Spire.DataExport.dll v4.1.9
• Spire.DataExport.ResourceMgr.dll v2.1.0
• Spire.Common.dll v10.4.9
• Spire.License.dll v1.3.8

Here is a list of changes made in this release

Spire.PDF

Spire.Doc

Spire.XLS

pt.ShowSubtotals = true;
pt.ShowSubtotals = false;

Spire.Presentation

IAutoShape shape = ppt1.Slides[0].Shapes[0] as IAutoShape;
shape.TextFrame.RightToLeftColumns = true;

ppt.Slides[0].Shapes.AppendShape(ShapeType.Line, new PointF(10, 10), new PointF(20, 30));

Spire.OfficeViewer

Spire.Spreadsheet

var range = spreadsheet.Worksheets[0].GetSelectedRange();
//Start from 0, 1 means the second column in the range
int sortIndexs = new int[]{1,};
var sortOrders = new Forms.SortOrder[]{ Forms.SortOrder.Descending };
range.Sort(sortIndexs, sortOrders, SortOrientation.Vertical, false);