New Features of ZK Spreadsheet 2.0"

From Documentation
Line 7: Line 7:
 
==Menu of Functions==
 
==Menu of Functions==
  
==Fast Icon Toolbar==
+
==Styles==
 +
 
 +
===Change Style by toolbar button===
 +
 
 +
===Change Style by Quick Style menu===
  
 
==Muti-Sheets Supported Tabs==
 
==Muti-Sheets Supported Tabs==
Line 16: Line 20:
  
 
==Adding Hyperlink==
 
==Adding Hyperlink==
 
==Sort Rows/Columns==
 
  
 
==Drag and Drop Editing of Rows/Columns/Area==
 
==Drag and Drop Editing of Rows/Columns/Area==
Line 27: Line 29:
 
==Support Copy/Paste/PasteSpecial Menu and Toolbar Button==
 
==Support Copy/Paste/PasteSpecial Menu and Toolbar Button==
  
=Report=
+
==Styles==
 +
 
 +
==Editing==
 +
 
 +
==Selection and Highlight==
 +
 
 +
==Sort Rows/Columns==
  
==PDF Exporting==
+
==Manipulating Rows and Columns==
  
==Support exporting Excel Chart to PDF==
+
===Headers===
  
=Rich User Interface=
+
====Custom Row and Column Title====
  
==Styles==
+
====Hide/Unhide Row Headers and/or Column Headers====
  
==Editing==
+
===Controlling/Editing===
  
==Selection and Highlight==
+
====Freezing Row and Column====
  
==Custom Row and Column Title==
+
====Hide and Unhide Rows and Columns====
  
==Maximum Rows and Columns==
+
====Maximum Rows and Columns====
  
 
==Loading Cell on Demand==
 
==Loading Cell on Demand==
 
==Freezing Row and Column==
 
  
 
==Image==
 
==Image==
Line 55: Line 61:
 
==Rich Texts and Bullet Texts in a Cell==
 
==Rich Texts and Bullet Texts in a Cell==
  
==Hide/Unhide Row Headers and/or Column Headers==
+
=Report=
  
==Hide and Unhide Rows and Columns==
+
==PDF Exporting==
 +
 
 +
==Support exporting Excel Chart to PDF==
  
 
=Chart=
 
=Chart=

Revision as of 12:11, 22 November 2010

Introduction

Rich Functionality

Menu of Functions

Styles

Change Style by toolbar button

Change Style by Quick Style menu

Muti-Sheets Supported Tabs

Quick Style Menu & Color Picker

Quick Keyboard Shortcut

Adding Hyperlink

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

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 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