Assign Macro to Form Controls & Manipulate Spreadsheet Document Properties using .NET

We are pleased to announce the new release of Aspose.Cells for .NET 8.6.0. Aspose.Cells for .NET APIs have exposed the WorkbookMetadata class that is light weight as compared to Workbook class and allows to load the spreadsheet in order to manipulate the document properties in a simpler & more efficient way. In addition to the aforesaid class, it has also exposed the MetadataOptions class and MetadataType enumeration that can be used to specify the type of properties to be updated. Aspose.Cells for .NET now provides the Shape.MarcoName property to assign the macros to any control in the spreadsheet. This property is useful in scenarios where application requirement is to add modules and assign them to the controls for user interaction. This new release has exposed a new property that can be used to control the generation of scripts such as Frames & Document Properties while exporting the spreadsheets in HTML format. The aforesaid Boolean type property has the default value of true that means; the resultant HTML will contain the scripts related to the frames as per standards of Excel application. Moreover, the resultant HTML code will contain the conditional comments that detect the browser type and handle the layout accordingly. However, setting this property to false will direct the Aspose.Cells APIs not to generate the frame scripts and conditional comments. In this case the resultant HTML can be viewed in any browser but it cannot be imported back while using Aspose.Cells APIs. In the new version, we have also provided a few enhancements, e.g Exposed a property that can be used to update the PageSetup.Zoom if PageSetup.FitToPagesWide and/or PageSetup.FitToPagesTall properties have been used to control the Worksheet scaling, Supported  users may use Aspose.Cells for .NET to run it in the Medium Trust environment. We have handled some exceptions when reading/writing Excel spreadsheets, rendering Excel spreadsheets to PDF file format, refreshing Pivot tables and rendering Excel files to HTML file format. In this release, several important issues have been addressed. For example, issues around reading/ writing Microsoft Excel file formats, manipulating Pivot Tables, copying ranges, embedding Ole objects, combining workbooks, manipulating shapes, applying PageSetup options, rendering images from Excel worksheets, manipulating charts, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. We have further improved the Aspose.Cells formula calculation engine and fixed a few issues in this regard. This release includes several enhanced features and bug fixes as listed below

 Assign macro to form controls
 Worksheet.Shapes.UpdateSelectedValue throwing CellsException sometimes
 Including a Font Directory with CellsHelper, doesn't seem to work
 Hyperlink.TextToDisplay is not updated
 XLSX document size increases with every save
 Aspose.Cells is not able to run in the Medium Trust
 Wingdings symbols do not render correctly while converting certain spreadsheet to HTML
 Excel always repairs the resultant spreadsheet after adding the PivotTable
 HTML to Excel - CSS Styling Ignored
 Chart changes in resultant spreadsheet after refreshing the Chart
 Workbook.CalculateFormula never returns
 Aspose.Cells Row Insertion Error
 characters overlapped and converted to ######## in Excel to PDF rendering
 Superscript and subscript shifted up too much when generating image
 Chart Axis labels are rendered in jagged text
 WordArt Boxes are balcked out when XLSX is converted to PDF
 SmartArt boxes are coming as black.
 SmartArt layout heading is overlapping with underline under Picture heading.
 Text is being truncated/wrapped in the generated PDF
 Spreadsheet document produces multiple documents when converted
 OLE link ObjectSourceFullName could not be updated
 PageSetup.Zoom has changed after opening and saving the workbook
 Some cell formulas are lost when row is copied
 Double read of Carriage Return Line Feeds
 Combining two XLSM workbooks produces a corrupted workbook
 Images in the spreadsheet do not render while converting to PDF
 Linked Picture is not inside the chart after instantiating the Workbook object and saving it
 Range.CopyData works but Range.Copy is not working
 Adding more than 2084 characters in hyperlink corrupts the output xlsx file
 Excel function renders with #NAME? error on Sheet 1
 Gridweb Print on Chrome does not work correctly

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.

- Assign Macro to Form Control: http://www.aspose.com/docs/display/cellsnet/Assign+Macro+to+Form+Control

- Disable Exporting Frame Scripts and Document Properties: http://www.aspose.com/docs/display/cellsnet/Disable+exporting+frame+scripts+and+document+properties

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/community/files/51/.net-components/aspose.cells-for-.net/default.aspx

- 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

Company :-Aspose

User :- Sher Azam

Email :-sher.azam@aspose.com

Phone :-888-277-6734

Mobile:- -

Url :- http://www.aspose.com/blogs/aspose-products/aspose-cells-product-family/archive/2015/09/29/manipulate-document-properties-without-creating-an-instance-of-workbook-assign-macros-to-controls-and-restrict-the-api-to-generate-frame-scripts-for-html-conversion