Specify Number of Significant Digits & Get Paper Size of a Worksheet Using Aspose.Cells for Java 17.1.0
It has improved custom load filtering mechanism & customizing the loading process as per the properties of Worksheet. It also supports getting paper size of the worksheet and verifying custom pattern for the style object. Aspose.Cells APIs store 17 significant digits of double values unlike Excel application, which stores only 15 significant digits. It also enhanced ability to read the color of shape’s glow effect, rendering gradient fill for WordArt objects & more.
Lane Cove, Australia, February 15, 2017 --(PR.com)-- What’s new in this release?
Aspose team is pleased to announce the new release of Aspose.Cells for Java 17.1.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 LoadFilter class allows customizing the loading process as per the properties of the Worksheet. In order to customize the loading process, one has to override the LoadFilter.startSheet method. Please note, there are just a few properties that can be used for a given worksheet object in this scenario because most of the data and properties have not been loaded yet. The available Worksheet properties are: Name, Index & VisibilityType. With the release, the API has added the setter for the LoadFilter.LoadDataFilterOptions property to replace the m_LoadDataFilterOptions instance variable. Users may change the LoadDataFilterOptions property in their own implementation of LoadFilter class to control the behavior of loading template files. Sometimes, application requirement could be to retrieve the worksheet’s paper size in the unit of Inches, which can now be achieved using two properties. The PageSetup.PaperWidth and PageSetup.PaperHeight properties are of type double representing the paper width & height in the unit of inches while considering the page orientation. Aspose.Cells APIs store 17 significant digits of double values unlike Excel application which stores only 15 significant digits. Users can override this default behavior of Aspose.Cells APIs while using the newly exposed property. The code snippet on blog announcement page enforces the Aspose.Cells APIs to use 15 significant digits while storing double values to the spreadsheet files of type XLSX. It has has added a property to the WorkbookSettings class. The CheckCustomNumberFormat is useful in checking if the Style.Custom property has been set properly or not. In case the Style.Custom property has been set improperly, that is; the value does not correspond to valid pattern then the Aspose.Cells for Java APIs will throw CellsException with appropriate message. This new release 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. A few of the worth mentioning enhancements includes, ability to read the color of shape’s glow effect, Support for rendering gradient fill for WordArt objects while converting spreadsheets to HTML, support to load Excel 2016 chart types, enhanced HTML parsing engine for inline CSS, handled a few exceptions and many more. Below are some important new features, enhancement and bug fixes part of this release.
• GetPaperWidth and GetPaperHeight methods added in PageSetup class
• Support Gradient Fill for the WordArt while converting spreadsheets to HTML
• Saving to HTML is wrong
• Gridlines behind Shapes are not exported when converted to HTML
• Some CSS rules ignored when importing HTML
• Contents are striked through in the converted HTML
• Text style of some cells is wrong when saved to HTML
• DataBar wrong when cell has background color set
• Chart picture is not getting saved when EMF or SVG format is used
• HtrmlSaveOptions.ExportGridLines does not seem to be working for a particular spreadsheet
• Recalculating a number of formulas using Aspose Cells APIs results in "#NUM!" error
• Date format problem while importing CSV with ICustomParser
• Name.getRanges() API produces unexpected results
• Unable to access the instance variable m_LoadDataFilterOptions while overriding the startSheet method of LoadFilter class
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.1.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 LoadFilter class allows customizing the loading process as per the properties of the Worksheet. In order to customize the loading process, one has to override the LoadFilter.startSheet method. Please note, there are just a few properties that can be used for a given worksheet object in this scenario because most of the data and properties have not been loaded yet. The available Worksheet properties are: Name, Index & VisibilityType. With the release, the API has added the setter for the LoadFilter.LoadDataFilterOptions property to replace the m_LoadDataFilterOptions instance variable. Users may change the LoadDataFilterOptions property in their own implementation of LoadFilter class to control the behavior of loading template files. Sometimes, application requirement could be to retrieve the worksheet’s paper size in the unit of Inches, which can now be achieved using two properties. The PageSetup.PaperWidth and PageSetup.PaperHeight properties are of type double representing the paper width & height in the unit of inches while considering the page orientation. Aspose.Cells APIs store 17 significant digits of double values unlike Excel application which stores only 15 significant digits. Users can override this default behavior of Aspose.Cells APIs while using the newly exposed property. The code snippet on blog announcement page enforces the Aspose.Cells APIs to use 15 significant digits while storing double values to the spreadsheet files of type XLSX. It has has added a property to the WorkbookSettings class. The CheckCustomNumberFormat is useful in checking if the Style.Custom property has been set properly or not. In case the Style.Custom property has been set improperly, that is; the value does not correspond to valid pattern then the Aspose.Cells for Java APIs will throw CellsException with appropriate message. This new release 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. A few of the worth mentioning enhancements includes, ability to read the color of shape’s glow effect, Support for rendering gradient fill for WordArt objects while converting spreadsheets to HTML, support to load Excel 2016 chart types, enhanced HTML parsing engine for inline CSS, handled a few exceptions and many more. Below are some important new features, enhancement and bug fixes part of this release.
• GetPaperWidth and GetPaperHeight methods added in PageSetup class
• Support Gradient Fill for the WordArt while converting spreadsheets to HTML
• Saving to HTML is wrong
• Gridlines behind Shapes are not exported when converted to HTML
• Some CSS rules ignored when importing HTML
• Contents are striked through in the converted HTML
• Text style of some cells is wrong when saved to HTML
• DataBar wrong when cell has background color set
• Chart picture is not getting saved when EMF or SVG format is used
• HtrmlSaveOptions.ExportGridLines does not seem to be working for a particular spreadsheet
• Recalculating a number of formulas using Aspose Cells APIs results in "#NUM!" error
• Date format problem while importing CSV with ICustomParser
• Name.getRanges() API produces unexpected results
• Unable to access the instance variable m_LoadDataFilterOptions while overriding the startSheet method of LoadFilter class
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