Public API Changes in Aspose.Cells 8.9.0

This document describes the changes to the Aspose.Cells API from version 8.8.3 to 8.9.0 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

Added HtmlSaveOptions.DefaultFontName Property

Aspose.Cells for .NET 8.9.0 has exposed the DefaultFontName property for the HtmlSaveOptions class that allows specifying the default font name while rendering spreadsheets to HTML format. The default font will be used only when the font specified in the style does not exist. The default value of HtmlSaveOptions.DefaultFontName property is null, which means Aspose.Cells for .NET API will use a universal font that has the same family as the original font.

For more details on this feature, please review the article on Setting Default Font for Rendering Spreadsheets to HTML Format.

Following is the simple usage scenario.

C#

 // Create an instance of HtmlSaveOptions

var options = new HtmlSaveOptions();

// Set default font name for Html rendering

options.DefaultFontName = "Arial";

// Load a spreadsheet in an instance of Workbook

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

// Save the spreadsheet in Html format while passing instance of HtmlSaveOptions

book.Save(dir + "output.html", options);

Added ImageOrPrintOptions.DefaultFont Property

Aspose.Cells for .NET 8.9.0 allows setting the default font name for the ImageOrPrintOptions class by exposing the DefaultFont property. The property can be used when Unicode characters in the spreadsheet are not assigned the correct font in the cell style; otherwise, such characters may appear as blocks in the resulting images.

Set the DefaultFont property to MingLiu or MS Gothic to show Unicode characters. If the property is not set, Aspose.Cells will use the system’s default font to show Unicode characters.

For more details on this feature, please review the article on Setting Default Font for Rendering Spreadsheets in Image Formats.

Following is the simple usage scenario.

C#

 // Create an instance of ImageOrPrintOptions

var options = new ImageOrPrintOptions();

// Set default font name for image rendering

options.DefaultFont = "Arial";

// Load a spreadsheet in an instance of Workbook

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

// Access the worksheet to be rendered

var sheet = book.Worksheets[0];

// Create an instance of SheetRender

var render = new SheetRender(sheet, options);

// Save spreadsheet to image

render.ToImage(0, dir + "output.png");

Added PivotTable.IsExcel2003Compatible Property

Aspose.Cells for .NET API has exposed the Boolean-type IsExcel2003Compatible property for the PivotTable class, which allows specifying if the PivotTable is Excel 2003 compatible for refreshing purposes. The default value of the IsExcel2003Compatible property is true, which means a string must be less than or equal to 255 characters. If the string is greater than 255 characters, it will be truncated. If false, the aforementioned restriction will not be imposed.

For more details on this feature, please review the article on Compatibility for Excel 2003 for Refreshing Pivot Tables.

Following is the simple usage scenario.

C#

 // Load a spreadsheet in an instance of Workbook

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

// Access the desired Pivot Table from the spreadsheet

var pivot = book.Worksheets[0].PivotTables[0];

// Set Excel 2003 compatibility to false

pivot.IsExcel2003Compatible = false;

// Refresh & recalculate Pivot Table

pivot.RefreshData();

pivot.CalculateData();

Added GridWeb.GetVersion Method

Aspose.Cells.GridWeb for .NET 8.9.0 has exposed the GetVersion() method which returns the release version of the GridWeb component.