New Features of ZK Spreadsheet 2.0.0 Beta2"
m (Created page with '{{Template:Smalltalk_Author| |author=Henri Chen, Principal Engineer, Potix Corporation |date=July 30, 2010 |version=ZK 5.0 & ZK Spreadsheet 2.0 Beta2 }} =Introduction= ZK Spread…') |
|||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 19: | Line 19: | ||
==Rich Texts and Bullet Texts in a Cell== | ==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. | 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. | ||
| − | <gflash width="880" height="660"> | + | <gflash width="880" height="660">Richtext.swf</gflash> |
==Hide/Unhide Row Headers and/or Column Headers== | ==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. | As a component, sometimes you just do not want to see the row/column headers in the application. | ||
| − | <gflash width="940" height="580"> | + | <gflash width="940" height="580">Hideheader.swf</gflash> |
==Hyperlink Follow-up== | ==Hyperlink Follow-up== | ||
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. | 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. | ||
| − | <gflash width="880" height="640"> | + | <gflash width="880" height="640">Hyperlink.swf</gflash> |
==Sort Rows/Columns== | ==Sort Rows/Columns== | ||
You can sort rows, columns, or a specified area. | You can sort rows, columns, or a specified area. | ||
| − | <gflash width="980" height="680"> | + | <gflash width="980" height="680">Sort.swf</gflash> |
==Drag and Drop Editing of Rows/Columns/Area== | ==Drag and Drop Editing of Rows/Columns/Area== | ||
You can drag rows, columns, or a specified area to its destination. | You can drag rows, columns, or a specified area to its destination. | ||
| − | <gflash width="880" height="560"> | + | <gflash width="880" height="560">Moverange.swf</gflash> |
==Insert Rows/Columns/Area== | ==Insert Rows/Columns/Area== | ||
| Line 42: | Line 42: | ||
==Delete Rows/Columns/Area== | ==Delete Rows/Columns/Area== | ||
You can delete rows, columns, or a specified area. You can decide whether you want to shift cells up or shift cells left the deleted area. | You can delete rows, columns, or a specified area. You can decide whether you want to shift cells up or shift cells left the deleted area. | ||
| − | <gflash width="980" height="580"> | + | <gflash width="980" height="580">Insertdelete.swf</gflash> |
=Downloads= | =Downloads= | ||
| Line 48: | Line 48: | ||
=Other Resource and Links= | =Other Resource and Links= | ||
| − | [[New Features of ZK Spreadsheet 1.0.0 RC2]] | + | [[Small_Talks/2009/April/New_Features_of_ZK_Spreadsheet_1.0.0_RC2|New Features of ZK Spreadsheet 1.0.0 RC2]] |
| − | [[New Features of ZK Spreadsheet 1.0.0 RC]] | + | [[Small_Talks/2008/July/New_Features_of_ZK_Spreadsheet_1.0.0_RC|New Features of ZK Spreadsheet 1.0.0 RC]] |
| − | [[Various Functions in Spreadsheet]] | + | [[Small_Talks/2008/May/Various_Functions_in_Spreadsheet|Various Functions in Spreadsheet]] |
| − | [[Generate Huge Data Report in a Second]] | + | [[Small_Talks/2008/May/Generate_Huge_Data_Report_in_a_Second|Generate Huge Data Report in a Second]] |
| − | [[Integrate ZK Spreadsheet with Spring]] | + | [[Small_Talks/2008/May/Integrate_ZK_Spreadsheet_with_Spring|Integrate ZK Spreadsheet with Spring]] |
| − | [[Change the Style of Spreadsheet within 1 Min]] | + | [[Small_Talks/2008/April/Change_the_Style_of_Spreadsheet_within_1_Min|Change the Style of Spreadsheet within 1 Min]] |
| − | [[Use JavaBean in Excel with ZK Spreadsheet]] | + | [[Small_Talks/2008/April/Use_JavaBean_in_Excel_with_ZK_Spreadsheet|Use JavaBean in Excel with ZK Spreadsheet]] |
| − | [[How to Build a Rich Excel Report 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]] |
| − | [[A Preview Of ZK Spreadsheet 1.0]](with live demo) | + | [[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_Beta2</comment> | <comment>http://docs.zkoss.org/wiki/New_Features_of_ZK_Spreadsheet_2.0.0_Beta2</comment> | ||
Latest revision as of 02:16, 30 November 2010
Henri Chen, Principal Engineer, Potix Corporation
July 30, 2010
ZK 5.0 & ZK Spreadsheet 2.0 Beta2
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.
With this POI-based 2.0, Excel 2007, hyperlink, rich text, row and column moving, hiding and un-hiding row/column headers, sorting, filtering, and many other features has been implemented:
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.
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.
Hyperlink Follow-up
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.
Sort Rows/Columns
You can sort rows, columns, or a specified area.
Drag and Drop Editing of Rows/Columns/Area
You can drag rows, columns, or a specified area to its destination.
Insert Rows/Columns/Area
You can insert rows, columns, or a specified area. You can decide whether you want to shift cells down or shift cells right the inserted area.
Delete Rows/Columns/Area
You can delete rows, columns, or a specified area. You can decide whether you want to shift cells up or shift cells left the deleted area.
Downloads
Other Resource and Links
New Features of ZK Spreadsheet 1.0.0 RC2
New Features of ZK Spreadsheet 1.0.0 RC
Various Functions in Spreadsheet
Generate Huge Data Report in a Second
Integrate ZK Spreadsheet with Spring
Change the Style of Spreadsheet within 1 Min
Use JavaBean in Excel with ZK Spreadsheet
How to Build a Rich Excel Report with ZK Spreadsheet
A Preview Of ZK Spreadsheet 1.0(with live demo)
| Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License. |