Validate an Entire Worksheet of GridWeb & Customizing Excel Pivot Table using Java

What is new in this release?

The long awaited version of Aspose.Cells for Java 17.3.0 has been released. With this release, Aspose team has opened up a new set of scenarios for developers, which they can utilize in their Java applications. It covers the new feature to enhance the API control over the pivot tables. Developers can retrieve and set globalization settings of a pivot table. They can also call client-side script on the page change event of GridWeb control. GridWeb has support to validate the entire Excel worksheet instead of the updated cells. All the regular bug fixes and enhancements are also included. It is recommended to use the powerful Aspose for Java APIs directly in their Maven Projects with simple configurations. Using Aspose.Cells API, developers can apply various filters to build the corresponding pivot table. After they create a pivot table report and have added the fields that they require, they often want to enhance the layout and format of the report to improve readability and to make it more attractive. To achieve this, Aspose.Cells API allows developers to customize the globalization settings of a pivot table to deal with such scenarios. They can customize the Pivot Total, Sub Total, Grand Total, All Items, Multiple Items, Column Labels, Row Labels, Blank Values text as per the requirements. Aspose.Cells for Java includes an independent web-based grid control (com.aspose.cells.GridWeb) which is designed to work with the web applications. Developers can load an existing Excel file into its grid matrix, manipulate it and save it back. The GridWeb control can hold data in multiple pages via its paging feature. Developers might require to call a client side script on page index change event of GridWeb. This feature covers various scenarios. Developers may require to display the page number in their Java applications, so they can call client side script to get the page number. In the past, GridWeb control was validating the updated cells and not validating the entire Excel worksheet. Using the recent version 17.3 of Aspose.Cells API, developers can now validate the entire worksheet on client side before the GridWeb requests to the server. They need to set the needValidateall variable inside the acwmain.js to true. Aspose.Cells for Java API improvement work never stops because Aspose team is listening to the requests of the clients and gradually integrating their needs. Aspose team has made an important enhancement along with other behind the scenes enhancements. It is about to set the long string literals inside the formula. Several other bug fixes make the API more reliable and functional. It brings quality in rendering the borders of the cells while saving an Excel in other supported formats. The rendering speed of charts has been increased, especially with large data sets. The formula calculation engine is also further enhanced in the new release. Below are some important new features, enhancement and bug fixes part of this release.

- Setting formula with long string literal results in corrupt Excel file
- Dotted borders from the spreadsheet have not rendered to HTML
- Formula calculation is wrong with Aspose.Cells generated Excel file
- Top and bottom borders of cells are gone while converting to HTML
- Comments (at the end) are vertically cut when generated PDF via Aspose.Cells
- Series dash lines for charts are not rendered correctly in the output PDF
- Category axis labels displayed in two lines after converting chart to image
- Waterfall chart, the line from the total bar and the bar right before it is missing
- Subtask - Category axis labels displayed in two lines after converting chart to image
- The exported chart has x-axis labels different from the one in the Excel
- Chart is wrong on opening and saving the source Excel file
- Font has been changed after simply loading and re-saving the XLSM
- Formatting of the resulting file is messed up in the re-saved file
- Waterfall chart, Total series looks wrong
- Protected view after re-saving an XLS file
- Radar chart image is not generated

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 you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Customize Globalization Settings for Pivot Table
- Execute client side function on GridWeb page change

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