Recursive Calculation of Formulas & Fonts Configuration for Rendering Spreadsheets Using Aspose.Cells for Java 8.9.2
It supports configuring font sources for rendering spreadsheets to image formats and PDF. It has exposed new properties that enable users to calculate the dependent cells recursively when calculating cells which depends on other cells. This release also Control Chart’s data source while copying rows. This release includes some important enhancements, such as HTML rendering engine for shapes such as TextBoxes, Improved PDF rendering engine for charts as well as cell text alignment and more.
Lane Cove, Australia, September 09, 2016 --(PR.com)-- What’s new in this release?
Aspose team is pleased to announce the new release of Aspose.Cells for Java 8.9.2. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the API. Aspose.Cells for Java API has exposed a number of new classes as well as an enumeration to configure font sources for rendering spreadsheets to image formats and PDF. Most important class is the FontConfigs which has many useful factory methods to either set the font sources or set the font substitution along with some inspection APIs to retrieve the list of specified font sources as well as font substitutions. Developers can Set Font Sources and can also Substitute Fonts. It has exposed the Boolean type property to true and passing the object to calculateFormula method directs the Aspose.Cells APIs to calculate the dependent cells recursively when calculating cells which depends on other cells. Aspose.Cells for Java API has exposed the Boolean type property along with the an overload of Cells.copyRows method in order to facilitate the copy rows operation when rows to be copied also contains a chart and its data source. Users can make use of these new APIs to point the chart’s data source to the source or destination worksheets. It allows to get/set the IFilePathProvider for exporting worksheets to separate HTML files. These new APIs are helpful in scenarios where hyperlinks in one worksheet points to a location in another worksheet, where application requirement is to render each worksheet to separate HTML file. Implementing the IFilePathProvider allows to keep the aforementioned hyperlinks intact regardless of the fact that they are pointing to a location in a separate resultant HTML file. This release includes some important enhancements, such as HTML rendering engine for shapes such as TextBoxes, Improved PDF rendering engine for charts as well as cell text alignment, Tweaked Aspose.Cells’ formula calculation engine to match the results with Excel application and Handled a few exceptions such as IndexOutOfBoundsException, NumberFormatException & OutOfMemoryError for certain scenarios. This release includes several enhanced features and bug fixes as listed below
• Calculation time has increased with recent API revisions
• User configurable fonts substitution mechanism is required
• Workbook.calculateFormula() method never terminates for the source Excel file
• Unable to catch image resource while rendering spreadsheet to HTML with IStreamProvider
• Problem with rendering CheckBoxes to HTML
• Issue with getDisplayStringValue() for Date formatted values
• Using Light Cells APIs to process an XLS file, the first cell of the first sheet is always processed
• Character spacing and break not correct for vertical text while rendering spreadsheet to PDF
• Column widths are different on CentOS than on Windows
• Chart scale has shifted while rendering spreadsheet to PDF
• Alignment problem when rendering an Excel file to PDF
• Formatting of legend entries is disturbed while rendering spreadsheet to PDF
• Horizontal axis labels have not been rendered completely, that is; all labels are missing some contents in the rendered image.
• File is corrupted after formula calculation and save
• Calculation result is not correct
• Array Formula is not being calculated properly
• Some values from the Excel file are missing in the output HTML - XLS to HTML conversion
Other most recent bug fixes are also included in this release
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/products/cells/java
- Download Aspose.Cells for Java: http://www.aspose.com/downloads/cells/java
- Online documentation of Aspose.Cells for Java: http://www.aspose.com/docs/display/cellsjava/Home
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
Aspose team is pleased to announce the new release of Aspose.Cells for Java 8.9.2. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the API. Aspose.Cells for Java API has exposed a number of new classes as well as an enumeration to configure font sources for rendering spreadsheets to image formats and PDF. Most important class is the FontConfigs which has many useful factory methods to either set the font sources or set the font substitution along with some inspection APIs to retrieve the list of specified font sources as well as font substitutions. Developers can Set Font Sources and can also Substitute Fonts. It has exposed the Boolean type property to true and passing the object to calculateFormula method directs the Aspose.Cells APIs to calculate the dependent cells recursively when calculating cells which depends on other cells. Aspose.Cells for Java API has exposed the Boolean type property along with the an overload of Cells.copyRows method in order to facilitate the copy rows operation when rows to be copied also contains a chart and its data source. Users can make use of these new APIs to point the chart’s data source to the source or destination worksheets. It allows to get/set the IFilePathProvider for exporting worksheets to separate HTML files. These new APIs are helpful in scenarios where hyperlinks in one worksheet points to a location in another worksheet, where application requirement is to render each worksheet to separate HTML file. Implementing the IFilePathProvider allows to keep the aforementioned hyperlinks intact regardless of the fact that they are pointing to a location in a separate resultant HTML file. This release includes some important enhancements, such as HTML rendering engine for shapes such as TextBoxes, Improved PDF rendering engine for charts as well as cell text alignment, Tweaked Aspose.Cells’ formula calculation engine to match the results with Excel application and Handled a few exceptions such as IndexOutOfBoundsException, NumberFormatException & OutOfMemoryError for certain scenarios. This release includes several enhanced features and bug fixes as listed below
• Calculation time has increased with recent API revisions
• User configurable fonts substitution mechanism is required
• Workbook.calculateFormula() method never terminates for the source Excel file
• Unable to catch image resource while rendering spreadsheet to HTML with IStreamProvider
• Problem with rendering CheckBoxes to HTML
• Issue with getDisplayStringValue() for Date formatted values
• Using Light Cells APIs to process an XLS file, the first cell of the first sheet is always processed
• Character spacing and break not correct for vertical text while rendering spreadsheet to PDF
• Column widths are different on CentOS than on Windows
• Chart scale has shifted while rendering spreadsheet to PDF
• Alignment problem when rendering an Excel file to PDF
• Formatting of legend entries is disturbed while rendering spreadsheet to PDF
• Horizontal axis labels have not been rendered completely, that is; all labels are missing some contents in the rendered image.
• File is corrupted after formula calculation and save
• Calculation result is not correct
• Array Formula is not being calculated properly
• Some values from the Excel file are missing in the output HTML - XLS to HTML conversion
Other most recent bug fixes are also included in this release
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/products/cells/java
- Download Aspose.Cells for Java: http://www.aspose.com/downloads/cells/java
- Online documentation of Aspose.Cells for Java: http://www.aspose.com/docs/display/cellsjava/Home
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
Contact
Aspose
Sher Azam
888.277.6734
http://www.aspose.com/
Sher Azam
888.277.6734
http://www.aspose.com/
Contact
Categories