Home > Computing > Auto-Fit Columns, Rows While Importing HTML & Get List of Fonts Used in Spreadsheet using Java

Auto-Fit Columns, Rows While Importing HTML & Get List of Fonts Used in Spreadsheet using Java

Added: (Mon Mar 13 2017)

Pressbox (Press Release) - What�s new in this release?

Aspose team is pleased to announce the new release of Aspose.Cells for Java 17.2.0. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the API. The release notes also list any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for Java. This release offers the metered licensing mechanism in parallel to its traditional licensing. In order to provide the usage based licensing, Aspose.Cells for Java has exposed the Metered class that allows the developers to set public and private keys by calling its setMeteredKey method. The metered licensing system monitors the regular usage of Aspose.Cells API and keeps track of the Aspose API licenses. It has exposed the getFonts method for the Workbook class. The Workbook.getFonts method returns the list of individual fonts used to format the cell contents for a given spreadsheet. The list returned by the Workbook.getFonts method is in the form of an array of type com.aspose.cells.Font. The newly exposed method is useful in scenarios where the developers require to extract the list of the fonts used in a particular spreadsheet. The extracted list can further be used to match the available fonts on the machine before rendering the spreadsheet. This is because, if Aspose.Cells APIs are not able to find the required fonts, they try to replace the required font with some other suitable font which is present on the system. By comparing the system�s font list against the fonts used in the spreadsheet, the developers can devise some mechanism to either pick the required fonts from a custom location or substitute a particular font with a list of available fonts. Aspose.Cells for Java has now added the HTMLLoadOptions.AutoFitColsAndRows property which indicates if the API should auto-fit columns and rows while importing the HTML in its object mode. The Boolean type property has the default value as false which means that the cell heights & widths will be imported as they are, however, when the aforementioned property is set to true, the API tries to adjust the column widths and row heights according to the contents. Latest revision of Aspose.Cells for Java has exposed the Cells.textToColumns method in order to mimic the Excel�s Text to Columns feature. Excel provides this feature from the command group Data Tools under the Data tab as highlighted in the snapshot on blog announcement page.This release has exposed the WarningCallback property for the LoadOptions class in order to get or set the warning callbacks. Developers have to implement the IWarningCallback interface in order to get custom warnings in their applications. This revision of Aspose.Cells for Java has exposed Boolean type TrimLeadingBlankRowAndColumn property for the TxtSaveOptions class that indicates whether leading blank rows and columns should be trimmed like Excel does while exporting data to CSV or Tab-delimited formats. The default value of aforementioned property is false. In case the data on the worksheet does not start from the first cell, that is: A1, the Excel application removes the leading blank rows and columns while exporting the data to CSV or Tab-delimited formats, however, Aspose.Cells APIs by default, retain the blank rows & columns for the same sample in order to keep the data location retained if the exported CSV or Tab-delimited files have to be imported back using Aspose.Cells APIs. It has enhanced its core for more stability as well as fixed a few critical bugs. Moreover, there are numerous minor enhancements in order to improve the overall usage of the API. It enhanced Support to load Excel 2016 chart types, Enhanced HTML rendering engine for shapes & handled a few exceptions. Below are some important new features, enhancement and bug fixes part of this release.

� Support MS Excel 2016 TreeMap Chart
� Support MS Excel 2016 Waterfall Chart
� Support Converting Text to Columns MS Excel feature
� Data loss while copying range with hidden rows & columns to new workbook and converting it to HTML
� Data loss while copying range with hidden rows & columns to new workbook and converting it to HTML - II
� Data loss while copying range with hidden rows & columns to new workbook and converting it to HTML - III
� Save as PDF does not preserve formatting
� Excel formula is not working and shown as "#DIV/0!"
� Concurrent save issue
� Top and bottom borders of cells are gone while converting to HTML
� Excel formula is not working properly
� Recalculating a number of formulas using Aspose Cells APIs results in "#NUM!" error
� Demo page of math does not load correctly in GridWeb (Java) demo project
� List data validation drop down does not close when reloading data
� PageSetup.BlackAndWhite does not seem to work
� Bug in try catch and re-throw exception where ExceptionType is changed
� Waterfall chart, when calculate() is called, chart series colors are reverted.
� Logarithmic scale bug in Excel causes Aspose Cells to hang
� Vertical Axis bound values changed while rendering spreadsheet to PDF
� Horizontal & vertical axis bound values changed while rendering Chart to EMF
� Hebrew - Space character is missing in PDF
� Chart is vertically suppressed while rendering to image
� DataTable series are missing while exporting chart to image
� Missing underline in title when chart is converted into image
� Background image in chart is wrong
� The space b/w chart's axis (hebrew) labels/legend is missing in the output PDF file
� Contents of the rectangle shape do not render while converting spreadsheet to HTML
� Chart has been changed while converting spreadsheet to HTML
� Formula in chart has changed position while converting spreadsheet to HTML
� Excel to PDF conversion - Arabic text is reversed
� Sheet name gets Upper-cased on inserting formula
� Call to updateSelectedValue changes activeSheetIndex

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
Phone: 888.277.6734
Fax: 866.810.9465

Submitted by:Aspose
Disclaimer: Pressbox disclaims any inaccuracies in the content contained in these releases. If you would like a release removed please send an email to remove@pressbox.co.uk together with the url of the release.