Auto-Fit Columns, Rows While Importing HTML & Get List of Fonts Used in Spreadsheet Using Java
It adds support for MS Excel 2016 TreeMap Chart & offers the metered licensing mechanism in parallel to its traditional licensing. It has added a new property which indicates if the API should auto-fit columns and rows while importing the HTML in its object mode. It also supports Warning Callback for Template Loading, Trim Leading Blank Rows & Columns while Exporting Contents to Text Formats & enhanced loading Excel 2016 chart types, HTML rendering engine for shapes & handled a few exceptions.
Lane Cove, Australia, March 13, 2017 --(PR.com)-- 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. 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
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
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465
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. 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
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
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465
Contact
Aspose
Sher Azam
888.277.6734
http://www.aspose.com/
Sher Azam
888.277.6734
http://www.aspose.com/
Contact
Categories