Specify Number of Significant Digits & Get Paper Size of a Worksheet inside Java Apps

What is new in this release?

The long awaited version of Aspose.Cells for Java 17.1.0 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 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.

- 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
- Cell string value & rounding problem based on different JDK versions
- Right-to-left and left-to-right control characters are not rendered correctly in PDF when conversion is done on Linux
- Hebrew - In the table the word wrapped lines are aligned to the right in PDF while they should be centered as in Excel
- Wrong conversion of Arabic worksheet to SVG
- Hebrew - Wrapped text is not right-aligned in PDF as in Exce
- Hebrew - Series labels when there is a word wrap the characters are not displayed in the right sequence
- Shape to image Error while rendering 03.xls to PDF
- Shape to image Error while rendering 02.xls to PDF
- Chart image in the HTML is wrong
- Uneven lines' thickness at intersections while rendering spreadsheet with diagram to PDF
- Chart labels are not displayed/rendered the same (as per the original Excel file) in the output PDF file
- Angle of x-axis labels is incorrect in Chart's PDF
- Incorrect rendering of bar charts while rendering spreadsheet to HTML
- Setting formula referring to external workbook creates 3d formula
- Unreadable content error in Excel 2007 after resaving a spreadsheet
- Conditional format expression changes on deleting rows
- Cell.getFormula() returns broken formula for a cell
- Output file gets corrupt after executing DataLabels.setPosition() method
- Conditional format priority order changes on Cells.deleteRows() method
- Vba module is lost while re-saving an XLSM file on Linux
- API adds extra apostrophes to the modified formula
- Dynamic formula in designer spreadsheet using {-1} {-2} return Invalid formula error
- Transparency of the shapes is reset to 0 while converting XLS to XLSB

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
- Download Aspose.Cells for Java
- Online documentation of Aspose.Cells for Java

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Aspose - The .NET and Java component publisher
[email protected]
Phone: 888.277.6734
Fax: 866.810.9465