Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports a 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 files using a 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.
|Tags||3D effects MS Excel 2010 Sparklines 3D effects on charts Duplicate values Formula Calculation Engine linked picture|
|Licenses||Evaluation License Developer Enterprise License Developer OEM License Site Enterprise|
|Operating Systems||Windows Unix Linux Mac OS X|
|Implementation||Java C# .Net VB.NET|
Release Notes: This release includes an enhancement for copying a cell over a range of cells. A new overload was added: AutoFitColumns (int firstRow, int firstColumn, int lastRow, int lastColumn, AutoFitterOptions options), making it possible to use auto-fitting options even in a range. Similarly, you may now copy tables when copying ranges. issues with rendering Excel files, rendering PivotTables and Pivot Charts, Excel to HTML, applying conditional formatting, rendering image files from worksheets, and exporting to PDF have been resolved. Issues pertaining to the formula calculation engine have also been fixed.
Release Notes: In this release, several important issues have been addressed. For example, issues around formatting cells, rendering PivotTables and charts, rendering Excel files, and rendering image files from charts / worksheets have been resolved. Issues pertaining to the formula calculation engine have also been fixed. Pivot table borders were incorrectly visible, and green ellipse word art/picture was incorrectly rendered around the chart; this is now fixed.
Release Notes: This release adds enhancements for copying ranges and number formatting and an enhancement to the List objects and Tables, which are now copied when copying ranges between workbooks. Similarly, macros and VBA codes are copied in the XSLM file when you use the Workbook.Copy() method. This release fixes a few exceptions when manipulating PivotTables in the template file. Several important issues like rendering MS Excel files, rendering PivotTables, manipulating advanced conditional formatting, rendering image files, and exporting to PDF have been resolved. GridWeb now allows reading a data list on the client side.
Release Notes: This release includes an enhancement for advanced conditional formatting when converting worksheets to image files. The Microsoft Excel ruler is now not displayed when setting Page Layout view. The performance of Excel to PDF rendering was improved, fixing hangs that occurred with certain Excel files. Issues with rendering spreadsheets (XLS, XLSX, etc.), protecting sheets, rendering PivotTables, encrypting files, and exporting to PDF have been resolved. Issues pertaining to the formula calculation engine have also been fixed.
Release Notes: Enhancements were made to the advanced conditional formatting types in Microsoft Excel 2007/2010 file formats.Excel 2010′s advanced data validation is now supported. Data filters in pivot tables are now supported. Several enhancements were made regarding data series and markers for charts. Auto-shape rendering in output HTML has also been enhanced. A few issues in the Web-based grid control provided by Aspose.Cells for .NET that affected grouping data and formatting are now fixed.