The ZK Spreadsheet Component"
m |
m |
||
Line 2: | Line 2: | ||
__TOC__ | __TOC__ | ||
− | === | + | ===Purpose=== |
In this section, a brief overview is given on how developers work with the ZK Spreadsheet component. | In this section, a brief overview is given on how developers work with the ZK Spreadsheet component. | ||
− | === | + | ===ZUML=== |
− | + | ||
ZK Spreadsheet is a single ZK component. Developers could declare it within any ZK container components, such as Window, tabs, groupbox, etc. | ZK Spreadsheet is a single ZK component. Developers could declare it within any ZK container components, such as Window, tabs, groupbox, etc. | ||
Line 21: | Line 21: | ||
[[Image: bareSpreadsheet.png]]<br/> | [[Image: bareSpreadsheet.png]]<br/> | ||
− | + | ===Spreadsheet Component Attributes=== | |
− | + | ||
Developers customize the spreadsheet component by declaring its attributes, for example: | Developers customize the spreadsheet component by declaring its attributes, for example: | ||
*the source file of the spreadsheet, for example src="/demo_sample.xls" | *the source file of the spreadsheet, for example src="/demo_sample.xls" | ||
Line 31: | Line 31: | ||
====Triggered Spreadsheet Events==== | ====Triggered Spreadsheet Events==== | ||
− | |||
=====Cell Event===== | =====Cell Event===== | ||
Revision as of 03:44, 23 November 2010
Purpose
In this section, a brief overview is given on how developers work with the ZK Spreadsheet component.
ZUML
ZK Spreadsheet is a single ZK component. Developers could declare it within any ZK container components, such as Window, tabs, groupbox, etc.
For example:
<window title="Bare ZK Spreadsheet" border="normal" height="500px">
<spreadsheet src="/demo_sample.xls"
maxrows="200"
maxcolumns="40"
width="100%"
height="450px"></spreadsheet>
</window>
Spreadsheet Component Attributes
Developers customize the spreadsheet component by declaring its attributes, for example:
- the source file of the spreadsheet, for example src="/demo_sample.xls"
- the maximum number of rows of this spread sheet, for example maxrows="200"
- the maximum number of columns of this spread sheet, for example maxcolumns="40"
- size of the spreadsheet component, for example: width="500px" height="300px"
Triggered Spreadsheet Events
Cell Event
CellEvent
Description: Notifies one that the user has a focus on cell | |
CellEvent
Description: Notifies one that the user has modified contents directly or indirectly on cell | |
CellMouseEvent
Description: Notifies one that the user has left click on a cell | |
CellMouseEvent
Description: Notifies one that the user has right click on a cell | |
CellMouseEvent
Description: Notifies one that the user has double click on a cell |
Header Event
HeaderMouseEvent
Description: Notifies one that the user has left click on a header | |
HeaderMouseEvent
Description: Notifies one that the user has right click on a header | |
HeaderMouseEvent
Description: Notifies one that the user has double click on a header | |
HeaderEvent
Description: Notifies one that the user has resize a header |
Edit Event
CellEvent
Description: Notifies one that user has start editing cell | |
StopEditingEvent
Description: Notifies one that the user has stop editing cell |
Selection Event
CellSelectionEvent
Description: Notifies one that user has select a range of cells | |
SelectionChangeEvent
Description: Notifies one that the user has move or modify the range of a selection |
Hyperlink Event
HyperlinkEvent
Description: Notifies one that user has click on the hyperlink of a cell |
Version History
Version | Date | Content |
---|---|---|
All source code listed in this book is at Github.