Aspose.Cells for .NET updated

Released: Nov 17, 2009

Updates in this release

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.