Set Default Font for Rendering Spreadsheets to Image & HTML File Formats and Impose Excel 2003 Restrictions while Refreshing Pivot Tables with Aspose.Cells for .NET 8.9.0

Share on FacebookTweet about this on TwitterShare on LinkedIn

Aspose.Cells for .NET logoWe are pleased to announce our next version of Aspose.Cells for .NET v8.9.0. This release includes some new features and other enhancements with critical bug fixes. Please see the release notes in order to know what is new and what has been changed/fixed with this version of Aspose.Cells for .NET. If you are planning to upgrade the Aspose.Cells for .NET API to the latest revision, we would strongly suggest you to check the complete Public API Changes section to know what APIs are changed so far. We have highlighted some important features and other enhancements here.

Set Default Font for Rendering Spreadsheets to Image Formats

Aspose.Cells for .NET API has provided the ability to specify the default font name for rendering spreadsheets to image formats by exposing the ImageOrPrintOptions.DefaultFont property. The DefaultFont property is of type System.String with default value as null. The said property can be used when Unicode characters in the spreadsheet have not been formatted with appropriate font in the cell’s style, consequently such characters may appear as blocks in the resultant images. It is advised to set the DefaultFont property to MingLiu or MS Gothic to show Unicode characters. If the DefaultFont property is not set, Aspose.Cells for .NET API will use the system’s default font to show the Unicode characters.

Below provided code snippet demonstrates the simple usage scenario of newly exposed ImageOrPrintOptions.DefaultFont. Please check the detailed article on Setting Default Font for Rendering Spreadsheets in Image Formats if you wish to get more in-depth understanding of the aforementioned feature.

// 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");

Set Default Font for Rendering Spreadsheets to HTML

Aspose.Cells for .NET 8.9.0 has exposed the DefaultFontName property for the HtmlSaveOptions class that allows to specify the default font name while rendering spreadsheets to HTML format. The default font will be used only when a particular font used to format some contents in the spreadsheet does not exist on the machine where conversion process has to take place. The default value of HtmlSaveOptions.DefaultFontName property is null that means, Aspose.Cells for .NET API will use the universal font which has the same family with the original font.

Below provided code snippet demonstrates the simple usage scenario of newly exposed HtmlSaveOptions.DefaultFontName. In order to get a more detailed understanding of this feature, please check the article on Setting Default Font for Rendering Spreadsheets to HTML Format.

// 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);

Impose Restrictions of Excel 2003 while Refreshing Pivot Table

Aspose.Cells for .NET API has exposed the Boolean type IsExcel2003Compatible property for the PivotTable class which allows to specify if a given PivotTable is Excel 2003 compatible for refreshing purposes. The default value of IsExcel2003Compatible property is true, that 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.

Below provided code snippet demonstrates the simple usage scenario of PivotTable.IsExcel2003Compatible property. In order to get a more detailed understanding of this feature, please check the article on Compatibility for Excel 2003 while Refreshing Pivot Tables.

// 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();

Other Enhancements and Fixes

The most notable enhancements in this release are as follow:

We have handled a few exceptions regarding reading and writing Excel and HTML file formats. We have also handled an exception when calling Autofit operation on a worksheet.

In this release, several important issues have been addressed. For example, issues around reading and writing Microsoft Excel file formats, copying worksheets, manipulating PivotTables, adding List Objects/Tables, converting spreadsheets to HTML files and vice versa, manipulating and rendering charts and shapes, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. We have also enhanced the Aspose.Cells’ formula calculation engine and fixed a few issues in this regard.

Aspose.Cells for .NET Resources

The resources, you may need to accomplish your tasks: