Add ActiveX Control Support, Comments for ListObjects & Rendering Grid Lines to HTML using .NET
07/21/2016

It provides the ability to add & manipulate the ActiveX Controls in spreadsheets. The APIs provide the ability to export spreadsheet contents in HTML format

Online PR News – 21-July-2016 – Lane Cove, NSW – What is new in this release?

We are 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 you 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
• Issue with Custom time format
• Issue regarding unsupported chars indices in CHAR formula
• Conversion to PDF results in 2 PDF pages as opposed to Excel's print preview
• Excel to PDF Conversion - Justified character lost with its formatting
• Excel to PDF rendering - Page break position has been changed
• Aspose.Cells renders the same worksheet to images in different size in Session 1 vs Session 0
• Non-system installed font not working for TextBoxes
• Image rendered differently from the original chart
• Unnecessary lines on the chart while exporting Chart to Image
• Chart image is different from the source
• Chart area becomes gibberish when converted to PDF .NET
• Aspose.Cells incorrectly recognizes the font size of chart title
• Set the text to the shape from the template file.
• References in table become broken after importing two dimension array into the table
• References in table become broken after some manipulation with file
• Different page sizes in the output PDFs than Excel
• Issue with Shape.GetCharacters() method
• Cell validation does not work correctly with INDIRECT function
• Header rows do not repeat when spreadsheet is converted to PDF with Turkish locale
• OTT is detected as ODS
• TextBox.IsFilled set to false but fill appears as light blue when ODS is viewed in OpenOffice
• File becomes corrupted after shape.UpdateSelectedValue
• Different saved Pdf file page sizes for selected or not selected cells in the Excel file
• ODS to PDF: first 2 pages contain blue shade
• Change in behaviour for Smart Marker processing when used in Pivot Table across 8 6 1 & 8 6 3
• ArgumentException: Parameter is not valid, while resizing the form control

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.

- Export Excel to HTML with GridLines: http://www.aspose.com/docs/display/cellsnet/Export+Excel+to+HTML+with+GridLines

- Automatically refresh OLE object via Microsoft Excel using Aspose.Cells: http://www.aspose.com/docs/display/cellsnet/Automatically+refresh+OLE+object+via+Microsoft+Excel+using+Aspose.Cells

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, XLS, SpreadsheetML, OOXML, XLSB, CSV, HTML, ODS, PDF, XPS and all file formats from Excel 97 to Excel 2007. You 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

- 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.9465