The new release of Aspose.Cells for Java enables Java Developers to restrict the Excel API to use only one font location while rendering spreadsheets. Developers can now export hidden worksheet contents while saving worksheet to HTML.
Lane Cove, NSW, Australia., June 16, 2014 - (PressReleasePoint) -
The long awaited version of Aspose.Cells for Java v8.1.0 has been released. Aspose team has been hard at work bringing many useful improvements with the latest edition of Aspose.Cells library. User can immediately start exploring the newly added features & enhancements.
This release allows developers to restrict the Excel API to Use only One font location. This newly added feature allows developers to restrict the API to use only one font location while rendering spreadsheets. Users may now set the JVM arguments to tell the API where to look for the required fonts or use the System.setProperty method in application code to achieve the same.
Excel API for Java from Aspose now provides get/set methods for the ExportHiddenWorksheet property exposed by the HtmlSaveOptions class. The aforesaid Boolean property allows the users to choose whether to render the hidden worksheets or not. The default value is true, meaning the hidden worksheet will be rendered as HTML; switching to false excludes hidden worksheets from the rendering process. More details on this topic can be found on the Prevent Exporting Hidden Worksheet Contents while Saving to HTML in the documentation section.
Aspose.Cells has been trying to provide all features that Microsoft Excel offers. One step further, Aspose.Cells has exposed the getter/setters for the DisplayNullString&NullString properties for PivotTable class to handle the Pivot Table option “For empty cells show” offered by the Microsoft Excel. These properties allow the users to set display option for the empty cells inside the Pivot Table to any specified string. Please check the detailed article on Setting Pivot Table Option in Java – For empty cells show.
Aspose.Cells for Java 8.1.0 has provided fix for several important issues, such as a couple of problems related to rendering spreadsheets as PDF on Linux platform, exporting spreadsheets to HTML, print quality & page setup. A few of the most important settings are listed below. This release includes plenty of improved features and bug fixes as listed below:
Restrict the API to use the fonts directory specified using CellsHelper.setFontDir method
lines of diagram are now crisp/sharp
Get display color defined in custom number format
Some colors are shown just before column in one table is now fixed
Images missing is fixed in resultant PDF when spreadsheet is converted on Ubuntu
Gridlines and Font settings missing is resolved in the output HTML
Setting print quality of worksheets is now fixed
PrintCopies are preserved for XLS format but not for XLSX format is now fixed
Saving Pivottable as mht: exception is resolved
CellsException is resolved: Map size (0) must be >= 1
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 user 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.
Press Contact: Zarfishan Zahid Suite 163, 79 Longueville Road 888.277.6734 *********.*****@*s**s*.com Email partially hidden to block spam. Please use the contact form here.