Assign Macros to Shapes & Restrict Generation of Frame Scripts for Spreadsheet to HTML Conv.
10/12/2015

This new release enables Java developers to Restrict Generation of Frame Scripts for Spreadsheet to HTML Conversion & Assign Macros to Shapes in Java Apps.

Online PR News – 12-October-2015 – Lane Cove, NSW, 2066 – What’s new in this release?

We are pleased to announce the new release of Aspose.Cells for Java 8.6.0. This month’s release contains many useful features and improvements along with some critical bug fixes. Aspose.Cells for Java API has exposed the WorkbookMetadata class that is light weight as compared to Workbook class and allows loading 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 Java 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. It has exposed the HtmlSaveOptions.ExportFrameScriptsAndProperties 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 detects the browser type and adjusts the layout accordingly. 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. The most notable enhancements in this release includes, exposed OoxmlSaveOptions.UpdateZoom 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, Improved the HTML & PDF rendering engines for alignment, layout and shape rendering while handling ODS and other spreadsheet formats and improved the calculation engine to provide support for CORREL, RSQ , STEYX Excel functions. This release includes several enhanced features and bug fixes as listed below

• Provide a property for HtmlSaveOptions that could control the generation of JavaScript and Conditional Comments
• Detecting Chart changes before Rendering
• Apply macro to a button
• Cannot move to next cell when pressing Enter key in input mode for a cell
• Cannot copy empty cell in GridWeb (JAVA)
• Text Alignment is lost when spreadsheet is converted to HTML
• Cell E4 is not set overflow:hidden in output HTML
• Height of the cell does not shrink in output HTML
• Painted rectangle loses its background color in the output HTML
• Correl() function is not able to calculate correct result
• Function RSQ is not calculated correctly
• Function STEYX() not supported by formula calculation engine in Apose.Cells
• Wrong layout when rendering PDF from an ODS file
• ODS to HTML Conversion - Font size and color issue
• Workbook.copy loses ListBox controls' formatting and properties
• No image is getting populated in the pdf
• Chart data point size is wrong in output HTML
• CellsException - If there is only a series on the primary axis, you could not plot the series to the second axis
• Deleting a column corrupts the resultant spreadsheet beyond repair
• PageSetup.Zoom has changed after opening and saving the workbook
• Background color for the sheet changed when reloading the GridWeb
• Aspose.Cells.GridWeb (JAVA) - cannot scroll to the last line in Google chrome

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 Java documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

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

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

Overview: Aspose.Cells for Java

Aspose.Cells is a Java component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted excel files, macros, VBA, unicode, formula settings, pivot tables, importing data from JDBC ResultSet and support of CSV, SpreadsheetML, PDF, ODS and all file formats from Excel 97 to Excel 2007. It is compatible with Windows, Linux & Unix and supports all advanced features of data management, formatting, worksheet, charting and graphics.

More about Aspose.Cells for Java

- Homepage of Aspose.Cells for Java: http://www.aspose.com/java/excel-component.aspx

- Download Aspose.Cells for Java: http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/default.aspx

- Online documentation of Aspose.Cells for Java: http://www.aspose.com/docs/display/cellsjava/Home

- Demos of Aspose.Cells for Java: http://www.aspose.com/demos/java-components/aspose.cells/default.aspx

- Post your technical questions/queries to Aspose.Cells for Java 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 Java 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