New Features of ZK Spreadsheet 2.0"
From Documentation
Murasakiwu (talk | contribs) (→Events) |
Murasakiwu (talk | contribs) (→Events) |
||
| Line 68: | Line 68: | ||
=Events= | =Events= | ||
| − | ZK Spreadsheet supports numerous events such as | + | ZK Spreadsheet supports numerous events such as [http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Implement_ZK_Spreadsheet_Event_Listeners/Editing_Events Editing Events], [http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Implement_ZK_Spreadsheet_Event_Listeners/Key_Events Key Events], [http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Implement_ZK_Spreadsheet_Event_Listeners/Mouse_Events Mouse Events], [http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Implement_ZK_Spreadsheet_Event_Listeners/Selection_Events Selection Events] and [http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Implement_ZK_Spreadsheet_Event_Listeners/Hyperlink_Event Hyperlink Event]. You can listen to these events to develop highly interactive spreadsheet applications. If you want to know more detail, please reference |
[http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Implement_ZK_Spreadsheet_Event_Listeners Implement ZK Spreadsheet Event Listeners] | [http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Implement_ZK_Spreadsheet_Event_Listeners Implement ZK Spreadsheet Event Listeners] | ||
==Editing Events== | ==Editing Events== | ||
| − | There are three editing events that ZK Spreadsheet supports: '''onStartEditing''', '''onStopEditing''', '''onEditboxEditing''' | + | There are three editing events that ZK Spreadsheet supports: '''onStartEditing''', '''onStopEditing''', '''onEditboxEditing'''. |
| − | |||
==Key Events== | ==Key Events== | ||
| − | Users can write key event listeners for key events such as ctrl+C, ctrl+V and so on | + | Users can write key event listeners for key events such as ctrl+C, ctrl+V and so on. |
| − | |||
==Mouse Events== | ==Mouse Events== | ||
| − | There are two types of Mouse events. One is cell mouse events such as '''onCellClick''', '''onCellDoubleClick''' and '''onCellRightClick'''; and the other is header mouse events such as '''onHeaderClick''', '''onHeaderDoubleClick''' and '''onHeaderRightClick''' | + | There are two types of Mouse events. One is cell mouse events such as '''onCellClick''', '''onCellDoubleClick''' and '''onCellRightClick'''; and the other is header mouse events such as '''onHeaderClick''', '''onHeaderDoubleClick''' and '''onHeaderRightClick'''. |
| − | |||
==Selection Events== | ==Selection Events== | ||
| − | Those events will be triggered when user is selecting cell(s), column(s), or row(s) | + | Those events will be triggered when user is selecting cell(s), column(s), or row(s). |
| − | |||
==Hyperlink Event== | ==Hyperlink Event== | ||
| − | + | Hyperlink Event will be triggered when end user click on the hyperlink of a cell. | |
=Functions= | =Functions= | ||
Revision as of 09:25, 23 November 2010
Introduction
Rich Functionality
Menu of Functions
Styles
Change Style by toolbar button
Rich Texts and Bullet Texts in a Cell
Muti-Sheets Supported Tabs
Quick Keyboard Shortcut
Adding Hyperlink
Drag and Drop Editing of Selected Range
Inserting or Deleting Row/Column/Cell
Auto Fill Cells
Support Copy/Paste/PasteSpecial
Support Ascending/Descending/Customizing Sorting
Editing
Selection and Highlight
Manipulating Rows and Columns
Headers
Custom Row and Column Title
Hide/Unhide Row Headers and/or Column Headers
Controlling/Editing
Freezing Row and Column
Hide and Unhide Rows and Columns
Maximum Rows and Columns
Loading Cell on Demand
Image
Display or Hide Grid Lines
Chart
Support showing chart
Report
PDF Exporting
Support exporting Excel Chart to PDF
Events
ZK Spreadsheet supports numerous events such as Editing Events, Key Events, Mouse Events, Selection Events and Hyperlink Event. You can listen to these events to develop highly interactive spreadsheet applications. If you want to know more detail, please reference Implement ZK Spreadsheet Event Listeners
Editing Events
There are three editing events that ZK Spreadsheet supports: onStartEditing, onStopEditing, onEditboxEditing.
Key Events
Users can write key event listeners for key events such as ctrl+C, ctrl+V and so on.
Mouse Events
There are two types of Mouse events. One is cell mouse events such as onCellClick, onCellDoubleClick and onCellRightClick; and the other is header mouse events such as onHeaderClick, onHeaderDoubleClick and onHeaderRightClick.
Selection Events
Those events will be triggered when user is selecting cell(s), column(s), or row(s).
Hyperlink Event
Hyperlink Event will be triggered when end user click on the hyperlink of a cell.