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

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.

File:MouseEvents.png

Selection Events

Users can write selection event listeners for listening user selecting cell(s), column(s) or row(s).

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