New Features of ZK Spreadsheet 2.0

From Documentation
Revision as of 12:50, 22 November 2010 by Murasakiwu (talk | contribs)

Introduction

Rich Functionality

Menu of Functions

Styles

Change Style by toolbar button

Change Style by Quick Style menu

Muti-Sheets Supported Tabs

Quick Keyboard Shortcut

Adding Hyperlink

Drag and Drop Editing of Rows/Columns/Area

Inserting or Deleting Row/Column/Cell

Drag to Copy Cells

Support Copy/Paste/PasteSpecial Menu and Toolbar Button

Styles

Editing

Selection and Highlight

Sort Rows/Columns

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

Rich Texts and Bullet Texts in a Cell

Report

PDF Exporting

Support exporting Excel Chart to PDF

Chart

Support showing chart(Bar, Bar3D, Line, Line3D, Pie, Pie3D, Donut, Excel 97-2003, xls, Excel 2007, xlsx)

Events

Editing Events

Key Events

Mouse Events

Selection Events

Hyperlink Event

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