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.
Aspose.Cells will deliver Excel spreadsheets in a desktop or web server environment without Microsoft Excel installed on either server or user's PC.
Limitations:
· 30 days trial
What's New in This Release:
Aspose.Cells:
New Features:
· 40611 - Support custom data sorting
Enhancements:
· 41850 - Copy range fails to copy the color of the conditional formula
· 41849 - Clearing Textboxes is not working
Exceptions:
· 41843 - Exception: “Input string was not in a correct format” in reading/writing the template file
· 41858 - Exception that is caused by writing Legend entries
· 41873 - Exception: “Index was out of range” - caused by writing legend entries
Bugs:
· 41903 - Aspose.Cells has two bugs regarding Shapes.AddTextEffect API
· 41807 - Hyperlink over an image in XLSX is not shown when rendering to HTML
· 41904 - The aligned pivot columns are set to "Wrap text" in the resultant file when file is re-saved
· 41891 - Issue with refreshing Pivot table(s)
· 41827 - DataSource is null when the PivotTable's data source is set to a Print area
· 41854 - Pivot table: Date is not shown in the sorted order
· 41830 - Data labels fill color and borders disappeared after repositioning
· 41814 - XY chart scale is inc...