Get/Set Excel Version Identification & Better Excel to PDF Conversion Process


Well-known member
Mar 10, 2010
Programming Experience
What is new in this release?

We are pleased to announce the new release of Aspose.Cells for .NET 8.2.2 . It contains over 60 improvements, new features and bug fixes. 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. 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. 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. This release includes several enhanced features and bug fixes as listed below

- Conversion to PDF process seems to hang on a spreadsheet having 115996 rows
- Error "Cannot edit a PivotTable in group edit mode"
- Incorrect value calculated as compared to MS Excel
- Causes the "Unreadable Content" message in MS Excel
- Text in shape renders upside down when spreadsheet is converted to image
- Shape overlapping the text when spreadsheet is rendered as image
Text Indent issue
- Text in Text Box isn't rendered in the resultant PDF
- Pivot table not retaining conditional formatting
- An error appears about unreadable content.
- Shape orientation is wrong when rendering to image
- Wrong pdf export - text trimmed and extra space added
- Character 'P' is clipped in the output PDF
- Conditional Formatting arrows are smaller in size
- White GridLines are rendered Black
- Shape color changes when source file is opened and resaved
- DataLabels' text is wrapped in the output image file format
- Fourth chart on the page 10 does not look like Excel
- Fourth chart on the page 8 does not look like Excel
- Second chart on page 8 does not look like Excel
- Extra line above the bar in the bar chart
- The top number on the y axis for the top chart
- Stacked bar chart multilevel category axis label alignment issue
- Chart axis fill color does't apply when convert to image
- Scatter Chart incorrectly adds extra major X axis marker
- Workbook RefreshChartCache option does not take into consideration regional and language settings
- Wrong Axis Values when Chart is saved as EMF using ToImage
- Text Boxes have been misplaced
- Legend Marks have different thickness
- Missing Axis Title when Chart is saved as EMF using the ToImage
- Missing Axis Values when Chart is saved as EMF using the ToImage
- Missing elements when extracting complex charts
- The Chart's Pre-formating of custom data point icons changes
- Workbook.CalculateFormula populating with wrong values
- Error using Xls file created with Excel 2013
- ListObject Resize adds Filters inside the Table
- Table 3 is resized but the formula and formatting is not copied
- ListObject Resize deletes CalculatedColumnFormula
- Cells.Find doesn't work with Regex
- Corrupt content after copying range using Range.CopyData
- System.NullReferenceException while loading a XLSX file
- ListObject.Resize() does not copy the Data Validation
- Invalid Scatter Style Val Error in "Alarm Volume_Sep152013.xlsx" spreadsheet
- Invalid Scatter Style Val Error in Alarm "Performance_Sep152013.xlsx" spreadsheet
- Range names are not removing after removing sheets
- BuiltinStyleType.Good is interchanged with BuiltinStyleType.Neutral
- Cell borders are lost in the output Excel file
- Stop Light Indicators renders as #N/A
- Formula based values are not rendered
- Wrong value from a Value function after CalculateFormula
- Custom formula gets removed after call workbook.RemoveExternalLinks()
- Verify that cell value satisfies data validation rules
- Data labels entries in the Bubble chart are wrong
- WebWorksheet.SetEditableRange is not working in the GridWeb
- Unable to change tabs and paging is also not working
- Indent Level does not work with any other culture other than US

Other most recent bug fixes are also included in this release.

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for .NET documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Get the Version Number of the Application that Created the Excel Document
- Get Worksheet of the Chart

Overview: Aspose.Cells for .NET

Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects and importing or creating charts. You can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, SpreadsheetML, PDF and all file formats from Excel 97 to Excel 2007.

More about Aspose.Cells for .NET

- Homepage of Aspose.Cells for .NET C#
- Product Overview of Aspose.Cells for .NET
- Download Aspose.Cells for .NET
- Online documentation of Aspose.Cells for .NET
- Demos of Aspose.Cells for .NET

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Aspose - Your File Format Experts
Phone: 888.277.6734
Fax: 866.810.9465