Aspose.Cells for .NET updated

Aspose.Cells for .NET delivers real Excel spreadsheets in a desktop or web server environment without Microsoft Excel installed on either server or user's computer. Aspose.Cells supports spreadsheet generation and other basic file formatting features. It also supports a number of advanced features. These advanced features make it much more convenient for developers to manipulate contents, format cells and protect files.

Updates in V4.8.1

Aspose.Cells:

• External workbook references from Excel 2007 XLSX file are supported.
• Supports Summary Below Data for Subtotals.
• Allows more than 3 data sorter keys.
• Provides support for Excel 2007 Themes and Colors.
• Formula Calculation Engine is enhanced.
• Includes Area3D chart in the supported chart list for Chart-to-Image feature.
• Named Range comments can be accessed.
• Sets picture as a background fill format of the chart.

Aspose.Cells.GridWeb:

• Provides support for importing or exporting XLSX files.
• Adds some valuable overloaded methods: AutoFitColumns, AutoFitColumn, AutoFitRows, AutoFitRow.
• Formula Calculation Engine is enhanced.
• Supports MEDIAN, ISERR and ISNUMBER formulas/functions.
• Memory usage for styles is optimized.
• Calculation dependence tree for formulas in Ajax mode is supported.
• Handles events at client side before submitting.
• All operators, behaviors and operations work in Ajax mode.
• Supports setting style to a specified range of cells.

Aspose.Cells.GridDesktop:

• Implements match mode in custom row filter.
• Formula Calculation Engine is enhanced.
• Supports MEDIAN, ISERR and ISNUMBER formulas/functions.
• Allows maximum 1,048,576 rows and 1,024 columns.
• Provides support to sum up selected cells' values.
• Blanks, NonBlanks and AutoRowFilter options are included in auto-filters.
• Memory usage is optimized.
• Includes Find/Replace feature.
• Enhances Undo/Redo feature for the change in the operations: apply styles, insertion/deletion and resizing rows/columns.
• Provides support to customize behaviors when validation is failed.
• Supports copying/pasting when hosted within IE.

About Aspose

Aspose Pty Ltd was founded in March 2002 in Sydney, Australia. The corporate portal was firstly launched in October 2002. Aspose strives to provide the richest component choices for global .NET programmers. Thousands of organizations from tens of countries have acquired Aspose products, including Microsoft, IBM, PricewaterhouseCoopers, Ernst & Young, DuPont, Hilton Hotels, Reader's Digest, Bank of America, Boeing, Siemens, etc.