Public API Changes in Aspose.Cells 8.0.2

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

Added TextDirection Property to Shape Class

The Shape class exposes the TextDirection property, which can be used to get or set the direction of the text flow for the Shape object. The TextDirection property can also be used to set the desired text direction for comments in a spreadsheet, as demonstrated below.

Java

 //Instantiate a new Workbook

Workbook book = new Workbook();

//Get the first worksheet

Worksheet sheet = book.getWorksheets().get(0);

//Adding a comment to "F5" cell

int commentIndex = sheet.getComments().add("F5");

Comment comment = sheet.getComments().get(commentIndex);

//Set its vertical alignment setting            

comment.getCommentShape().setTextVerticalAlignment(TextAlignmentType.CENTER);

//Set its horizontal alignment setting

comment.getCommentShape().setTextHorizontalAlignment(TextAlignmentType.RIGHT);

//Set the Text Direction - Right-to-Left

comment.getCommentShape().setTextDirection(TextDirectionType.RIGHT_TO_LEFT);

//Set the Comment note

comment.setNote("This is my Comment Text. This is test");

//Save the Excel file

book.save(myDir + "output.xlsx");

Added ConvertFormulasData Property to HTMLLoadOptions Class

The ConvertFormulasData property has been added to the HTMLLoadOptions class to facilitate developers in loading Excel formulas from HTML files. The boolean ConvertFormulasData property indicates whether to convert the string to a formula when the string value starts with the character ‘=’.

Java

 //Create an instance of HTMLLoadOptions

HTMLLoadOptions loadOptions = new HTMLLoadOptions();

//Set ConvertFormulasData to true

loadOptions.setConvertFormulasData(true);

//Create an instance of Workbook and load an HTML based spreadsheet 

//while passing the instance of HTMLLoadOptions

Workbook workbook = new Workbook(myDir + "spreadsheet.html", loadOptions);

The default value of the ConvertFormulasData property is false.

Added ImageOptions Property to HtmlSaveOptions Class

The ImageOptions property has been added to the HtmlSaveOptions class. Exposing the ImageOptions property has enabled developers to set the preferences for images embedded in the HTML while exporting spreadsheets.

Obsoleted HtmlSaveOptions.ExportChartImageFormat Property

HtmlSaveOptions.ExportChartImageFormat has been marked obsolete starting from Aspose.Cells for Java 8.0.2. It is advised to use HtmlSaveOptions.ImageOptions instead for image format settings while exporting spreadsheets to HTML format.