The long awaited version of Aspose.Cells for Java 8.1.1 has been released. Our team has been hard at work bringing many useful improvements with the latest edition of Aspose.Cells library. The class HtmlSaveOptions has been enhanced to render HTML results with better layout. The feature is now available through the Boolean type PresentationPreference property which can be set to true while exporting spreadsheets to HTML format to get a better presentation layout. With previous releases of Aspose.Cells for Java API, when a possibly damaged spreadsheet was loaded in an instance of Workbook, the API tended to throw a generic message not mentioning where the problem could be. We have changed this behavior since 8.1.1, so that now the API throws an exception with a meaningful message to point out where (which cell) and what (formula expression) causes the exception when reading the template file. Scenarios are part of a suite of commands called what-if analysis tools provided by Microsoft Excel. What-if analysis is the process of changing the values in cells to see how those changes affect the outcome of formulas on the worksheet. They are useful for forecasting and financial models. Microsoft Excel saves a set of values in a scenario, and can automatically substitute these values in the worksheet. With this release of Aspose.Cells for Java, Aspose has provided support for scenarios to allow developers to create, manipulate and remove scenarios without needing Microsoft Excel. Aspose.Cells for Java has exposed many useful classes to make this task possible. Aspose.Cells for Java 8.1.1 has been packaged with the GridWeb component that can be used in Java based web applications to render and visually manipulate spreadsheets on the go. The download package also contains a demo – gridwebdemo.war – that you can deploy on your web server to see the component in action. This release includes plenty of improved features and bug fixes as listed below
- Support GridWeb for Java
- Cell.StringValue/DisplayStringValue returns # for thin columns when - Worksheet.DisplayZeros=false
- Give meaningful messages for CellsException when loading a damaged spreadsheet
- Conditional formatting background colors are now rendered in the PDF
- Setting the ImageOrPrintOptions' Transparency renders the PNG with Black - Background is now fixed
- XLSX to PDF: CellsHelper.setFontDir does not seem to pick the fonts is fixed
- Cell.getType() is detecting number as datetime is now fixed
- Support for localized formats in formulas is now fixed
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.
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.