New Features of ZK Spreadsheet 2.0

From Documentation

Introduction

Rich Functionality

Menu of Functions

Styles

Change Style by toolbar button

Change Style by Quick Style menu

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

Users can open excel file which includes image on ZK Spreadsheet.

Display or Hide Grid Lines

Chart

Support showing chart

ZK Spreadsheet supports present chart which is loaded from Excel. Additionally, the loaded chart in ZK Spreadsheet is "live".

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 to call relative ZK Spreadsheet APIs to really copy and paste cell(s).

KeyEvent.png

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. Following is an onHeaderRightClick event example.

Selection Events

Users can write selection event listeners for selection events. A very simple example is like following. When user select a cell, selection event will be triggered. Formula bar and name box listen to the event and show the value and cell name of the selected cell, respectively.


SelectionEvents.png

Hyperlink Event

ZK Spreadsheet supports hyperlink event: This event will be triggered after user clicked hyperlink on ZK Spreadsheet.

Functions

Built-in Functions

formula functions for Matrix operations

Math formula functions

Statistical formula functions

Text formula functions

Information formula functions

Date & Time functions

Logical formula functions

Financial Formula Functions

Engineering Formula Functions

Custom Functions

Java Bean Binding

Downloads

References

Use Excel sheets as styling templates for ZK Spreadsheet