• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Devaka Cooray
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
  • paul wheaton
  • Jeanne Boyarsky
  • Tim Cooke
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Tim Moores
  • Mikalai Zaikin
  • Carey Brown

Assign Macros to Shapes & Restrict Generation of Frame Scripts for Spreadsheet to HTML Conv.

Ranch Hand
Posts: 714
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is new in this release?

The long awaited version of Aspose.Cells for Java 8.6.0 has been released. 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 to load the spreadsheet in order to manipulate the document properties in a simpler & more efficient way. In addition to the aforesaid class, the Aspose.Cells for Java 8.6.0 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. Aspose.Cells for Java 8.6.0 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
- 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
- Download Aspose.Cells for Java
- Online documentation of Aspose.Cells for Java

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Aspose - The .NET and Java component publisher
Phone: 888.277.6734
Fax: 866.810.9465
I'm gonna teach you a lesson! Start by looking at this tiny ad:
a bit of art, as a gift, the permaculture playing cards
    Bookmark Topic Watch Topic
  • New Topic