New Features of ZK Spreadsheet 2.0.0 Beta3

{{Template:Smalltalk_Author|
|author=Henri Chen, Principal Engineer, Potix Corporation
|date=September 7, 2010
|version=ZK 5.0 & ZK Spreadsheet 2.0 Beta3
}}

=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 [http://poi.apache.org/spreadsheet/index.html Apache POI] for better scalability and more features.

Besides the already implemeneted versatile features, since beta3, we have added 21 more new features to make ZK Spreadsheet even useful:

==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 [http://blog.zkoss.org/index.php/2010/09/07/export-zk-spredsheet-to-pdf/ article] written by Ashish.
<br/>
[[Image:zsspdf-demo.png]]
<br/>

==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.
<gflash width="880" height="660">Draghide.swf</gflash>

==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.
<gflash width="880" height="660">Apihide.swf</gflash>

==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.
<gflash width="880" height="440">Dragfill.swf</gflash>

==ZK Spreadsheet Live==
Besides the ZK Spreadsheet component itself, our Web-based Excel like application, ZK Spreadsheet Live(zssapp), are also enhanced. 
===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.
<gflash width="1100" height="800">Zssapp-sort.swf</gflash>

===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.
<gflash width="1100" height="800">Zssapp-paste-special.swf</gflash>

=Downloads=
[http://code.google.com/p/zkspreadsheet/  ZK Spreadsheet 2.0 Beta3]

=Other Resource and Links=
[[Small_Talks/2010/July/New_Features_of_ZK_Spreadsheet_2.0.0_Beta2|New Features of ZK Spreadsheet 2.0.0 Beta2]]

[[Small_Talks/2009/April/New_Features_of_ZK_Spreadsheet_1.0.0_RC2|New Features of ZK Spreadsheet 1.0.0 RC2]]

[[Small_Talks/2008/July/New_Features_of_ZK_Spreadsheet_1.0.0_RC|New Features of ZK Spreadsheet 1.0.0 RC]]

[[Small_Talks/2008/May/Various_Functions_in_Spreadsheet|Various Functions in Spreadsheet]]

[[Small_Talks/2008/May/Generate_Huge_Data_Report_in_a_Second|Generate Huge Data Report in a Second]]

[[Small_Talks/2008/May/Integrate_ZK_Spreadsheet_with_Spring|Integrate ZK Spreadsheet with Spring]]

[[Small_Talks/2008/April/Change_the_Style_of_Spreadsheet_within_1_Min|Change the Style of Spreadsheet within 1 Min]]

[[Small_Talks/2008/April/Use_JavaBean_in_Excel_with_ZK_Spreadsheet|Use JavaBean in Excel with ZK Spreadsheet]]

[[Small_Talks/2008/April/How_to_Build_a_Rich_Excel_Report_with_ZK_Spreadsheet | How to Build a Rich Excel Report with ZK Spreadsheet]]

[[Small_Talks/2009/April/A_Preview_Of_ZK_Spreadsheet_1.0|A Preview Of ZK Spreadsheet 1.0]](with live demo)

<comment>http://docs.zkoss.org/wiki/New_Features_of_ZK_Spreadsheet_2.0.0_Beta3</comment>
[[Category:ZK Spreadsheet]]
[[Category:New Features]]
{{Template:Smalltalk_Footer|
|name=Potix Corporation 
}}