Anonymous
Not logged in
Login
Documentation
Search
New Features of ZK Spreadsheet 2.0
From Documentation
Namespaces
Page
Discussion
More
More
Languages
Page actions
View
View source
History
Revision as of 10:52, 22 November 2010 by
Murasakiwu
(
talk
|
contribs
)
(
→Functions
)
(
diff
)
← Older revision
|
Latest revision
(
diff
) |
Newer revision →
(
diff
)
Contents
1
Introduction
2
ZK Spreadsheet Live
2.1
Menu of Functions
2.2
Fast Icon Toolbar
2.3
Muti-Sheets Supported Tabs
2.4
Quick Style Menu & Color Picker
2.5
Quick Keyboard Shortcut
2.6
Adding Hyperlink
2.7
Sort Rows/Columns
2.8
Drag and Drop Editing of Rows/Columns/Area
2.9
Inserting or Deleting Rows/Columns/Area
2.10
Drag to Copy Cells
2.11
Support Copy/Paste/PasteSpecial Menu and Toolbar Button
3
Report
3.1
PDF Exporting
3.2
Support exporting Excel Chart to PDF
4
Rich User Interface
4.1
Styles
4.2
Editing
4.3
Selection and Highlight
4.4
Custom Row and Column Title
4.5
Maximum Rows and Columns
4.6
Loading Cell on Demand
4.7
Freezing Row and Column
4.8
Image
4.9
Display or Hide Grid Lines
4.10
Rich Texts and Bullet Texts in a Cell
4.11
Hide/Unhide Row Headers and/or Column Headers
4.12
Hide and Unhide Rows and Columns
5
Events
5.1
Editing Events
5.2
Key Events
5.3
Mouse Events
5.4
Selection Events
5.5
Hyperlink Event
6
Functions
6.1
Built-in Functions
6.1.1
formula functions for Matrix operations
6.1.2
Math formula functions
6.1.3
Statistical formula function for calculating distribution
6.1.4
Statistical formula functions for calculating mean
6.1.5
Text formula functions
6.1.6
Information formula functions
6.1.7
Date & Time functions
6.1.8
Logical formula functions
6.1.9
Financial Formula Functions
6.1.10
Engineering Formula Functions
6.2
Custom Functions
7
Chart
7.1
Support showing chart(Bar, Bar3D, Line, Line3D, Pie, Pie3D, Donut, Excel 97-2003, xls, Excel 2007, xlsx)
8
Downloads
9
References
Introduction
ZK Spreadsheet Live
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
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
Chart
Support showing chart(Bar, Bar3D, Line, Line3D, Pie, Pie3D, Donut, Excel 97-2003, xls, Excel 2007, xlsx)
Downloads
References