sherazam77
Well-known member
What’s new in this release?
The long awaited version of Aspose.Cells for .NET 7.0.2 has been released. It includes several enhancements and fixed number of user issues/bugs. Moreover, some unnecessary older obsolete methods for Sheet-to-Image feature are removed now. It includes support for getting the document properties for an encrypted XLS file without even knowing its password. We have made enhancements for Smart Markers feature, now you may group data in some complex scenarios where you also need to place dynamic rows for Sub-Totals, Totals and Grand Totals in between the sections of data. The GridDesktop control provided by Aspose.Cells for .NET now supports shapes while loading Excel files. This release includes few new and plenty of enhanced features as listed below
• Access document properties of an encrypted XLS file
• The Worksheet’s TabColor property for Chart type worksheets
• Export data without XLS limitation to SpreadsheetML file
• Smart Markers - How to group Rows (Calculate Totals, Sub-Totals and Grand Totals)
• Problems resolved Excel-to-PDF conversion
• Issues resolved with Chart Image regarding Data labels and Error bars
• Wrap Issue resolved when converting XLS-to-PDF
• Now can change line style of a ChartPoint
• Formulas using intersected ranges now properly working
• Image problems solved when saving to XLS format
• Successful Loading and Updating XLSM then Saving
• Problems resolved for Excel 2010 and XLSM
• Issue resolved with AutoFitRow and the AutoFitMergedCells
• Refresh Pivot table now sort properly
• AutoFitRows work fine
• SheetRender exports inconsistent spacing is fixed
• There are too much formats in the worksheet
• Copying range with validation
• GridDesktop issues resolved while loading an Excel document
• Rendering of document via GridDesktop.ImportExcelFile method is corrected
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.
- Creating Validation Rules for Cells: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/creating-validation-rules-for-cells.html
- Importing Data from DataView to Grid: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/importing-data-from-dataview-to-grid.html
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: http://www.aspose.com/categories/.net-components/aspose.cells-for-.net/default.aspx
- Product Overview for Aspose.Cells for .NET: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/product-overview.html
- Download Aspose.Cells for .NET: http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/default.aspx
- Online documentation of Aspose.Cells for .NET: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/index.html
- Demos of Aspose.Cells for .NET: http://www.aspose.com/demos/.net-components/aspose.cells/default.aspx
- Post your technical questions/queries to Aspose.Cells for .NET Forum:
http://www.aspose.com/community/forums/aspose.cells-product-family/19/showforum.aspx
- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for .NET blog: http://www.aspose.com/community/blogs/aspose.cells-product-family/default.aspx
Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465l
The long awaited version of Aspose.Cells for .NET 7.0.2 has been released. It includes several enhancements and fixed number of user issues/bugs. Moreover, some unnecessary older obsolete methods for Sheet-to-Image feature are removed now. It includes support for getting the document properties for an encrypted XLS file without even knowing its password. We have made enhancements for Smart Markers feature, now you may group data in some complex scenarios where you also need to place dynamic rows for Sub-Totals, Totals and Grand Totals in between the sections of data. The GridDesktop control provided by Aspose.Cells for .NET now supports shapes while loading Excel files. This release includes few new and plenty of enhanced features as listed below
• Access document properties of an encrypted XLS file
• The Worksheet’s TabColor property for Chart type worksheets
• Export data without XLS limitation to SpreadsheetML file
• Smart Markers - How to group Rows (Calculate Totals, Sub-Totals and Grand Totals)
• Problems resolved Excel-to-PDF conversion
• Issues resolved with Chart Image regarding Data labels and Error bars
• Wrap Issue resolved when converting XLS-to-PDF
• Now can change line style of a ChartPoint
• Formulas using intersected ranges now properly working
• Image problems solved when saving to XLS format
• Successful Loading and Updating XLSM then Saving
• Problems resolved for Excel 2010 and XLSM
• Issue resolved with AutoFitRow and the AutoFitMergedCells
• Refresh Pivot table now sort properly
• AutoFitRows work fine
• SheetRender exports inconsistent spacing is fixed
• There are too much formats in the worksheet
• Copying range with validation
• GridDesktop issues resolved while loading an Excel document
• Rendering of document via GridDesktop.ImportExcelFile method is corrected
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.
- Creating Validation Rules for Cells: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/creating-validation-rules-for-cells.html
- Importing Data from DataView to Grid: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/importing-data-from-dataview-to-grid.html
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: http://www.aspose.com/categories/.net-components/aspose.cells-for-.net/default.aspx
- Product Overview for Aspose.Cells for .NET: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/product-overview.html
- Download Aspose.Cells for .NET: http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/default.aspx
- Online documentation of Aspose.Cells for .NET: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/index.html
- Demos of Aspose.Cells for .NET: http://www.aspose.com/demos/.net-components/aspose.cells/default.aspx
- Post your technical questions/queries to Aspose.Cells for .NET Forum:
http://www.aspose.com/community/forums/aspose.cells-product-family/19/showforum.aspx
- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for .NET blog: http://www.aspose.com/community/blogs/aspose.cells-product-family/default.aspx
Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465l