New Features of ZK Spreadsheet 2.0

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

Introduction

Rich Functionality

Menu of Functions

Fast Icon Toolbar

Muti-Sheets Supported Tabs

Quick Style Menu & Color Picker

Quick Keyboard Shortcut

Adding Hyperlink

Sort Rows/Columns

Drag and Drop Editing of Rows/Columns/Area

Inserting or Deleting Rows/Columns/Area

Drag to Copy Cells

Support Copy/Paste/PasteSpecial Menu and Toolbar Button

Report

PDF Exporting

Support exporting Excel Chart to PDF

Rich User Interface

Styles

Editing

Selection and Highlight

Custom Row and Column Title

Maximum Rows and Columns

Loading Cell on Demand

Freezing Row and Column

Image

Display or Hide Grid Lines

Rich Texts and Bullet Texts in a Cell

Hide/Unhide Row Headers and/or Column Headers

Hide and Unhide Rows and Columns

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 function for calculating distribution

Statistical formula functions for calculating mean

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