ZK Pivottable 2.2.0 Release Notes
Released on Aug 26, 2014
ZK Pivottable 2.2.0 is a minor release to enhance exporting functions and make Excel 2007 the default export format.
ZK Pivottable is an Ajax data component, which takes raw data from a flat table (like tables in relational database) and organize them by desired categories arranged on columns and rows.
ZK Pivottable brings the power of spreadsheet's pivot table to Java web applications, enabling developers to take advantage of a readymade component for presenting complex sets of data online.
Feature Highlights
- Macro Component for Field Control
- Customaizable Cell Style
- Sizable Columns
- Header Sorting
- Filter Utility
- An utility of input data filter is provided to assist refining the model data.
- Zero to many row/column fields
- One to many data fields
- Open/close header node
- Paging
- Subtotal
- Hide/show grand total
- Events
Please see ZK Pivottable Product Page for more information
Example
For more information, please go to the documentation
What's New
New features:
- ZKPVT-65: Export to xlsx format as static report
- ZKPVT-76: Allow user to use their own HSSFWorkbook or XSSFWorkbook to export pivottable
- ZKPVT-77: Export to Excel can choose to use custom renderer for data cells
- ZKPVT-80: Excel 2007 becomes the default export format
Bug fixes:
- ZKPVT-71: Pivottable is broken in Safari 7.0.1
- ZKPVT-72: Pivottable is broken in Chrome 32
- ZKPVT-73: PivotUIEvent returned the header context of the previous row
- ZKPVT-74: Summary should be null if no data
- ZKPVT-75: Export to excel xlsx format file can't be open correctly.
- ZKPVT-78: Exported XLS file did not pass Office File Validation when changed ZPOI version to 3.9.4
- ZKPVT-79: Select subtotal function throw NPE if don't select any calculator.
