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

2024-11-02 08:46:58 Computer

931

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