Get Application Version and Retrieve Worksheet Instance from Chart with Aspose.Cells for .NET 8.2.2

Aspose.Cells for .NET logoAspose.Cells for .NET 8.2.2 has been released. This release contains useful new features and a number of improvements. It introduces contains over 60 improvements, including the new features listed below. If you are planning to upgrade the API from a previous release, we suggest you to check the Public API Changes section.

Get a Spreadsheet’s Application Version

Microsoft Excel application allows the user to save spreadsheets to different formats corresponding to the application versions such as Microsoft Excel version 2003, 2007, 2010 and 2013. This information is embedded in the spreadsheet, and can be used for version identification. Aspose.Cells for .NET now provides the means to get and set this information with the BuiltInDocumentPropertyCollection.Version property. Check the detailed article on Getting the Version Number of the Application that Created the Excel Document.

Get Worksheet Instance of the Chart

Before the release of Aspose.Cells for .NET 8.2.2, retrieving the Worksheet instance from the Chart object was not possible. The latest version has made this possible by exposing the Worksheet property for the Chart class. Please check the usage scenario below and the detailed article on Getting Worksheet of a Chart.

//Create workbook from sample Excel file
Workbook workbook = new Workbook("Book1.xlsx");

//Access first worksheet of the workbook
Worksheet worksheet = workbook.Worksheets[0];

//Print worksheet name
Console.WriteLine("Sheet Name: " + worksheet.Name);

//Access the first chart inside this worksheet
Chart chart = worksheet.Charts[0];

//Access the chart's sheet and display its name again
Console.WriteLine("Chart's Sheet Name: " + chart.Worksheet.Name);

Other Enhancements and Fixes

In the new version, we have fixed a few exceptions that occurred while opening Microsoft Excel 2007/2010 file formats and converting Excel files to PDF format. We have also enhanced the Excel to PDF conversion process which seemed to hanged for spreadsheets with millions of rows.

In this release, several important issues have been addressed. For example, issues around applying formatting to cells, manipulating built-in and custom styles, rendering and manipulating pivot tables, manipulating shapes and other drawing objects, rendering images from Excel worksheets, manipulating charts with formatting, rendering images files from charts, creating and manipulating list objects/tables and exporting Excel workbooks to PDF format have been resolved. We have also fixed a few issues regarding Aspose.Cells formula calculation engine to make it more robust.

We have also fixed a few issues in the web based Grid control regarding the paging and formatting features provided by Aspose.Cells for .NET.

To see a complete list of enhancements and fixes, and to download Aspose.Cells for .NET 8.2.2, please visit the download page.