Recursive Calculation of Formulas & Fonts Configuration for Rendering Spreadsheets using Java

2024-12-24 05:55:03 Computer

1103

We are 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. You 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

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.

- Change Data Source of the Chart to Destination Worksheet while Copying Rows or Range: http://www.aspose.com/docs/display/cellsjava/Change+Data+Source+of+the+Chart+to+Destination+Worksheet+while+Copying+Rows+or+Range

- Provide exported worksheet html file path via IFilePathProvider interface: http://www.aspose.com/docs/display/cellsjava/Provide+exported+worksheet+html+file+path+via+IFilePathProvider+interface

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

- 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