Public API Changes in Aspose.Cells 8.3.0

Added APIs

Added WorkbookSettings.AutoRecover Property

The new property AutoRecover has been added to the WorkbookSettings class in order to allow developers to set the option of Auto‑Recovery for the spreadsheets in their applications.

C#

 var book = new Workbook("sample.xlsx");

var settings = book.Settings;

settings.AutoRecover = true;

Added WorkbookSettings.CrashSave Property

A Boolean type property CrashSave has been added to the WorkbookSettings class that indicates whether the application saved the workbook file after a crash.

C#

 var book = new Workbook("sample.xlsx");

var settings = book.Settings;

Console.WriteLine(settings.CrashSave);

Added WorkbookSettings.DataExtractLoad Property

The property DataExtractLoad has been added to the WorkbookSettings class in order to allow developers to get the information regarding the last recovery. If the property DataExtractLoad returns true, that indicates that data recovery has been performed on the spreadsheet.

C#

 var book = new Workbook("sample.xlsx");

var settings = book.Settings;

Console.WriteLine(settings.DataExtractLoad);

Added WorkbookSettings.RepairLoad Property

The property RepairLoad indicates whether the spreadsheet was repaired during the last load with the Excel application.

C#

 var book = new Workbook("sample.xlsx");

var settings = book.Settings;

Console.WriteLine(settings.RepairLoad);

Added TxtLoadOptions.KeepExactFormat Property

The property KeepExactFormat has been added to the TxtLoadOptions class that indicates whether the exact formatting should be kept for the cell value when a string/text is converted to numbers or DateTime. This property has been added to match the behavior of Microsoft Excel for loading DateTime or numeric values from CSV files. In order to simulate Excel’s behavior, set the KeepExactFormat property to false, whereas the default value is true, so the cell value will retain the string format from the CSV file.

C#

 var options = new TxtLoadOptions();

options.KeepExactFormat = false;

var book = new Workbook("sample.csv", options);

Added Shape.Id Property

The property Id has been added to the Shape class to uniquely identify each shape object in a given spreadsheet. This new property also helps identify Chart objects in a spreadsheet as demonstrated below.

C#

 var book = new Workbook("sample.xlsx");

foreach(Chart chart in book.Worksheets[0].Charts)

{

    var shape = (Shape)chart.ChartObject;

    Console.WriteLine(shape.Id);

}

Added PlotArea.SetPositionAuto Method

The method SetPositionAuto has been added to the PlotArea class that helps set the chart’s plot area to automatic mode.

C#

 var book = new Workbook("sample.xlsx");

var chart = book.Worksheets[0].Charts[0];

chart.PlotArea.SetPositionAuto();
Public API Changes in Aspose.Cells 8.2.2 Public API Changes in Aspose.Cells 8.3.1