The long awaited version of Aspose.Cells for Java 18.5 has been released. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the APIs. We also recommend our clients to use the powerful Aspose for Java APIs directly in their Maven Projects with simple configurations. Sometimes users want to display text in Far East language font e.g. Japanese, Chinese, Thai etc. Aspose.Cells provides TextOptions.FarEastName property that can be used to specify the font name of Far East language. Besides, users can also specify the Latin font name using TextOptions.LatinName property. Aspose.Cells allows developers to save the workbook in Strict Open XML Spreadsheet format. For that purpose, it provides the Workbook.Settings.Compliance property. If users set its value as OoxmlCompliance.ISO_29500_2008_STRICT, then the output Excel file will be saved in Strict Open XML Spreadsheet format. Generally, users specify the fonts directory or list of fonts for all the workbooks but sometime, users have to specify individual or private set of fonts for a desired workbooks. Aspose.Cells provides IndividualFontConfigs class that can be used to specify the individual or private set of fonts for users' workbook. Below are some important new features, enhancement and bug fixes part of this release.
- The concurrent conversion to PDF while each workbook has his own private (exclusive) set of fonts
- Detect LoadFormat and FileFormatType of XLAM
- Pivot Table's formatting and behavior changed after open/save the template file
- Spreadsheet (XLS) becomes corrupted after simple load & save
- Aspose.Cells breaks iterator interface when calling Iterator.hasnext() twice
- Properties values garbled when extracting document properties
- The workbook is corrupted after adding a watermark
- Same code executes slower in new releases
- Properties are not be extracted in the template file
- NullPointerException when adding HTML to a cell
- Lines disappeared from chart when XLSX file is re-saved
- Exception "IndexOutOfBoundsException" when merging cells in light-weight mode
- Exception "java.lang.IllegalStateException: Invalid encoding: null" when loading an XLS file
- ArrayIndexOutOfBoundsException occurs on opening an Excel file
"java.lang.ArrayIndexOutOfBoundsException" occurs on opening an Excel file
Newly added documentation pages and articles
Some new tips and articles have now been added into Aspose.Cells for Java documentation that may guide users 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.