Public API Changes in Aspose.Cells 8.8.2

This document describes the changes to the Aspose.Cells API from version 8.8.1 to 8.8.2 that may be of interest to module/application developers. It includes not only new and updated public methods, added and removed classes, etc., but also a description of any changes in the behavior behind the scenes in Aspose.Cells.

Added APIs

Update References Automatically while Deleting Blank Rows & Columns

Aspose.Cells for .NET 8.8.2 has exposed overloaded versions of the Cells.DeleteBlankRows and Cells.DeleteBlankColumns methods. The new methods can accept an instance of the DeleteOptions class and can be used to overcome situations that may arise due to broken references in formulas, chart series data, and so on. The DeleteOptions class currently has only one member, a Boolean‑type property named UpdateReference. If the said property is set to true and the instance of the DeleteOptions class is passed to the Cells.DeleteBlankRows and Cells.DeleteBlankColumns methods, the API will internally adjust formula references (if any) to accommodate the changes.

For more details on this feature, please review the detailed article on Deleting Blank Rows & Columns with Updated References.

The following is a simple usage scenario.

C#

 //Create an instance of Workbook and load an existing spreadsheet

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

//Access worksheet from which blank rows/columns have to be deleted

var sheet = book.Worksheets[0];

//Access cells of the desired worksheet

var cells = sheet.Cells;

//Create an instance of the DeleteOptions class

DeleteOptions options = new DeleteOptions();

//Set UpdateReference property to true;

options.UpdateReference = true;

//Delete all blank rows and columns

cells.DeleteBlankColumns(options);

cells.DeleteBlankRows(options);