New Features of ZK Spreadsheet 2.0
Introduction
ZK Spreadsheet is an Ajax component that delivers the rich functionality of Excel on the Java Web application.
Being able to import and export Excel files are just the minimum. Unlike other on-line spreadsheet such as Google Docs or Office 2010 online suite, you can integrate ZK Spreadsheet with your enterprise back-end systems seamlessly and create collaborative and dynamic enterprise applications at minimal cost. You can call versatile Java APIs to control and configure the ZK Spreadsheet component(s). You can register event listeners so an action can be automatically triggered if any specified cell, range, or name changes. You can bind cells to the back-end Java beans, so any changes on the back-end data would be automatically reflected on the ZK Spreadsheet. You can create your own spreadsheet functions in Java and use them in the spreadsheet formulas. Actually, if you like, you can even create by yourselves an on line spreadsheet service with ZK Spreadsheet component.
ZK Spreadsheet is an extensible, customizable, and integratable Java Ajax Web spreadsheet solution, with both built in browser Ajax user interface and back-end server side Excel-like data and logic. None of ActiveX or plug-ins is needed.
Features
Since ZK Spreadsheet 2.0, we have changed the back-end data model from proprietary implementation(ZK Spreadsheet 1.0) to Apache POI for better scalability and more features.
Besides the already implemented versatile features, since version 2 RC, we have fixed 21 bugs and added 42 more new features to make ZK Spreadsheet even stable and useful. Among these new features are more complete supports to the Excel 2007 file format(.xlsx), enhancements to our Web-based Excel like application, ZK Spreadsheet Live, new Financial and Engineering formula functions, and wrapping as a native JSF component.
ZK Spreadsheet Live
More enhancements to our Web-based Excel like application, ZK Spreadsheet Live(zssapp):
Easy Menu and Toolbar Button for Setting Cell Styles
You can set font family, size, style, color, and alignment easily with one click. Also you can add or remove cell borders and change cell background color with only a menu selection.
Wizard for Adding Different Type of Hyperlink
You can use the Hyperlink wizard to add Web URL, document cell link, and email link as your wish. If a hyperlink or HYPERLINK function is inputted in a spreadsheet cell, end user can click on the cell text to follow up the hyperlink. If you simply want to select the cell but not follow up the hyperlink, you have to click on the empty space of the cell or press and hold the cell until the mouse cursor changes. Besides that, ZK Spreadsheet also fire an onHyperlink event so application developer can do further operations if any.
Export Spreadsheet to PDF Format
You can export the whole spreadsheet workbook, the current sheet, or a selected range to PDF format with or without header and/or grid lines.
Display or Hide Grid Lines
You can display or hide grid lines on only one click.
Support Sort/Custom-sort Menu and Toolbar Button
End users can now sort or custom sort selected ranges by selecting proper sorting parameters on the dialog. Additionally, you can sort rows, columns, or a specified area.
Support Copy/Paste/PasteSpecial Menu and Toolbar Button
End users can now copy, paste, and/or pasteSpecial by providing proper paste parameters on the dialog.
Financial Formula Functions
You can now leverage power of ZK Spreadsheet financial functions support to develop enterprise applications that process complex financial data. ZK Spreadsheet currently supports 40 most common financial functions.
Engineering Formula Functions
You can now handle engineering calculation needs with ZK Spreadsheet's engineering functions. ZK Spreadsheet supports all 39 engineering functions. ERROR: Width and Height not set
A Native JSF Ajax Component
Besides working as a ZK Framework component ZK Spreadsheet is also wrapped into a native JSF Ajax component. You can use it within JSF environment seamlessly. For details please check this [article].
Rich Texts and Bullet Texts in a Cell
ZK Spreadsheet can show rich texts and bullet texts in a cell. That is, you can show different font sizes, colors, and styles of texts in a cell. ERROR: Width and Height not set
Hide/Unhide Row Headers and/or Column Headers
As a component, sometimes you just do not want to see the row/column headers in the application. ERROR: Width and Height not set
Drag and Drop Editing of Rows/Columns/Area
You can drag rows, columns, or a specified area to its destination.
Alter Rows/Columns/Area
You can alter rows, columns, or a specified area, includes inserting and deleting.
Export ZK Spreadsheet to PDF file
Now we have supported exporting ZK Spreadsheet to PDF. It accepts the printing setup parameters and print to PDF format. For details, please see this article written by Ashish.
Drag to Hide and Unhide Rows and Columns
End users can drag to hide and unhide selected rows and columns. As in Excel, different mouse cursors indicate whether the dragging is for sizing the visible row/column or unhiding an hidden row/column. ERROR: Width and Height not set
API Calls to Hide and Unhide Rows and Columns
Notice that ZK Spreadsheet is a component that you can control with APIs, too. In this demo, we use API calls to hide and unhide selected area. ERROR: Width and Height not set
Drag to Copy Cells
You can drag the Fill Handle(the small black square at the bottom right) to copy cells in a simple dragging.