Add ActiveX Control Support, Comments for ListObjects & Rendering Grid Lines to HTML Using Aspose.Cells for .NET 8.8.3
It provides the ability to add & manipulate the ActiveX Controls in spreadsheets. The APIs provide the ability to export spreadsheet contents in HTML format as per the standards opted by Excel application. It has exposed a property which allows refreshing the OleObject’s image if the contents/data of the underlying object has been changed. It allows getting and setting the comments for an instance of ListObject. It has enhanced Specifying text spacing for shapes &Loadlnd spreadsheets etc.
Lane Cove, Australia, July 23, 2016 --(PR.com)-- What is new in this release?
Aspose team is pleased to announce the new release of Aspose.Cells for .NET 8.8.3. This release includes many valuable features, other enhancements and critical bug fixes. It also improves the overall stability and usability of the APIs. Aspose.Cells APIs have provided the ability to add & manipulate the ActiveX Controls in spreadsheets. Aspose.Cells for .NET API has exposed a number of useful classes, enumerations and methods to fully support the ActiveX Controls. The most worth mentioning addition to the public API is the ShapeCollection.AddActiveXControl method which allows adding an ActiveX Control to the collection of shapes by accepting 7 parameters to specify the control type, location to place the control and size of the control. Below provided code snippet demonstrates the simple usage scenario of newly exposed a method to add an ActiveX Control of type Toggle Button. Please check the detailed article on Adding ActiveX Controls to Worksheets if users wish to get more in-depth understanding of the aforementioned feature. Aspose.Cells APIs provide the ability to export spreadsheet contents in HTML format as per the standards opted by Excel application. If a spreadsheet is converted to HTML using Excel application, it does not render the grid lines. Aspose.Cells APIs behave in the same way using its default settings, however, with this release of the API, the developers can now choose to render the grid lines as well. Aspose.Cells for Java API has exposed a property with default value of false. If the said property is set to true, the API renders the grid lines for the available data range in HTML format. Below provided code snippet demonstrates the simple usage scenario of newly exposed HtmlSaveOptions.ExportGridLines to render the grid lines to HTML format. It has exposed the OleObject.AutoLoad property which allows refreshing the OleObject’s image if the contents/data of the underlying object has been changed. The aforementioned property when set to true, forces the Excel application to refresh the OleObject’s image when resultant spreadsheet is loaded in Excel interface. Aspose.Cells APIs now allow to get and set the comments for an instance of ListObject. In order to provide the aforementioned feature, the Aspose.Cells APIs have exposed the ListObject.Comment property with this release. In this release, several important issues have been addressed. For example, issues around reading and writing Microsoft Excel file formats, manipulating shapes, copying Rows/Columns, manipulating PivotTables, converting spreadsheets to HTML files and vice versa, manipulating and rendering charts and shapes, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. This release includes several enhanced features and bug fixes as listed below:
• Support refreshing and calculating Pivot Tables with calculated items
• Publicise the relevant APIs for adding/manipulating ActiveX controls including Toggle Button
• Provide an option to save the spreadsheet with Protected View
• Change character spacing in Excel Textbox
• Support for "WithoutChart" loading option
• Support gridlines for Excel to HTML conversion
• Support decimal value returned by implementation of ICustomFunction and CalculationData.CalculatedValue
• Print quality of the simulated bold font is not good
• Add Comment Property to ListObject/Table
• Using Array Formulas in Smart Markers
• ImportDataTable with insertRows=true replaces first row with blank line
• Apply table style to rich text settings
• Performance problem in Cells.CopyRows() method
• Problem with PivotItem.IsHidden when refreshing data
• Export Html to Excel - the text "!A1" added to the end of link
• File becomes corrupted after Pivot Table refreshes and copies workbook
• Cell shading is not applied uniformly while converting spreadsheet to HTML
• Cannot export all HTML content to Excel when the HTML has nested 'div' elements
Other most recent bug fixes are also included in this release.
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. users can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, XLS, SpreadsheetML, OOXML, XLSB, CSV, HTML, ODS, PDF, XPS and all file formats from Excel 97 to Excel 2007. Users can also view, generate, modify, convert, render and print workbooks all without using Microsoft Excel.
More about Aspose.Cells for .NET
- Homepage of Aspose.Cells for .NET: http://www.aspose.com/.net/excel-component.aspx
- Download Aspose.Cells for .NET: http://www.aspose.com/downloads/diagram/net
- Online documentation of Aspose.Cells for .NET: http://docs.aspose.com/display/cellsnet/Home
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.9465
Aspose team is pleased to announce the new release of Aspose.Cells for .NET 8.8.3. This release includes many valuable features, other enhancements and critical bug fixes. It also improves the overall stability and usability of the APIs. Aspose.Cells APIs have provided the ability to add & manipulate the ActiveX Controls in spreadsheets. Aspose.Cells for .NET API has exposed a number of useful classes, enumerations and methods to fully support the ActiveX Controls. The most worth mentioning addition to the public API is the ShapeCollection.AddActiveXControl method which allows adding an ActiveX Control to the collection of shapes by accepting 7 parameters to specify the control type, location to place the control and size of the control. Below provided code snippet demonstrates the simple usage scenario of newly exposed a method to add an ActiveX Control of type Toggle Button. Please check the detailed article on Adding ActiveX Controls to Worksheets if users wish to get more in-depth understanding of the aforementioned feature. Aspose.Cells APIs provide the ability to export spreadsheet contents in HTML format as per the standards opted by Excel application. If a spreadsheet is converted to HTML using Excel application, it does not render the grid lines. Aspose.Cells APIs behave in the same way using its default settings, however, with this release of the API, the developers can now choose to render the grid lines as well. Aspose.Cells for Java API has exposed a property with default value of false. If the said property is set to true, the API renders the grid lines for the available data range in HTML format. Below provided code snippet demonstrates the simple usage scenario of newly exposed HtmlSaveOptions.ExportGridLines to render the grid lines to HTML format. It has exposed the OleObject.AutoLoad property which allows refreshing the OleObject’s image if the contents/data of the underlying object has been changed. The aforementioned property when set to true, forces the Excel application to refresh the OleObject’s image when resultant spreadsheet is loaded in Excel interface. Aspose.Cells APIs now allow to get and set the comments for an instance of ListObject. In order to provide the aforementioned feature, the Aspose.Cells APIs have exposed the ListObject.Comment property with this release. In this release, several important issues have been addressed. For example, issues around reading and writing Microsoft Excel file formats, manipulating shapes, copying Rows/Columns, manipulating PivotTables, converting spreadsheets to HTML files and vice versa, manipulating and rendering charts and shapes, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. This release includes several enhanced features and bug fixes as listed below:
• Support refreshing and calculating Pivot Tables with calculated items
• Publicise the relevant APIs for adding/manipulating ActiveX controls including Toggle Button
• Provide an option to save the spreadsheet with Protected View
• Change character spacing in Excel Textbox
• Support for "WithoutChart" loading option
• Support gridlines for Excel to HTML conversion
• Support decimal value returned by implementation of ICustomFunction and CalculationData.CalculatedValue
• Print quality of the simulated bold font is not good
• Add Comment Property to ListObject/Table
• Using Array Formulas in Smart Markers
• ImportDataTable with insertRows=true replaces first row with blank line
• Apply table style to rich text settings
• Performance problem in Cells.CopyRows() method
• Problem with PivotItem.IsHidden when refreshing data
• Export Html to Excel - the text "!A1" added to the end of link
• File becomes corrupted after Pivot Table refreshes and copies workbook
• Cell shading is not applied uniformly while converting spreadsheet to HTML
• Cannot export all HTML content to Excel when the HTML has nested 'div' elements
Other most recent bug fixes are also included in this release.
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. users can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, XLS, SpreadsheetML, OOXML, XLSB, CSV, HTML, ODS, PDF, XPS and all file formats from Excel 97 to Excel 2007. Users can also view, generate, modify, convert, render and print workbooks all without using Microsoft Excel.
More about Aspose.Cells for .NET
- Homepage of Aspose.Cells for .NET: http://www.aspose.com/.net/excel-component.aspx
- Download Aspose.Cells for .NET: http://www.aspose.com/downloads/diagram/net
- Online documentation of Aspose.Cells for .NET: http://docs.aspose.com/display/cellsnet/Home
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.9465
Contact
Aspose
Sher Azam
888.277.6734
http://www.aspose.com/
Sher Azam
888.277.6734
http://www.aspose.com/
Contact
Categories