New Features of ZK Spreadsheet 2.0
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. The following image is a sample for introducing onCellDoubleClick event.
Selection Events
Users can write selection event listeners for listening user selecting cell(s), column(s) or row(s). A very simple example is like following picture, formula bar and position bar are selection event listeners of spreadsheet. When user select a cell, selection event will be triggered. The value of selected cell will be displayed on formula bar, and the position bar will show position of current cell.
Hyperlink Event
ZK Spreadsheet supports hyperlink event: This event will be triggered after user clicked hyperlink on ZK Spreadsheet.