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 12:50, 22 November 2010 by
Murasakiwu
(
talk
|
contribs
)
(
diff
)
← Older revision
|
Latest revision
(
diff
) |
Newer revision →
(
diff
)
Contents
1
Introduction
2
Rich Functionality
2.1
Menu of Functions
2.2
Styles
2.2.1
Change Style by toolbar button
2.2.2
Change Style by Quick Style menu
2.3
Muti-Sheets Supported Tabs
2.4
Quick Keyboard Shortcut
2.5
Adding Hyperlink
2.6
Drag and Drop Editing of Rows/Columns/Area
2.7
Inserting or Deleting Row/Column/Cell
2.8
Drag to Copy Cells
2.9
Support Copy/Paste/PasteSpecial Menu and Toolbar Button
2.10
Styles
2.11
Editing
2.12
Selection and Highlight
2.13
Sort Rows/Columns
2.14
Manipulating Rows and Columns
2.14.1
Headers
2.14.1.1
Custom Row and Column Title
2.14.1.2
Hide/Unhide Row Headers and/or Column Headers
2.14.2
Controlling/Editing
2.14.2.1
Freezing Row and Column
2.14.2.2
Hide and Unhide Rows and Columns
2.14.2.3
Maximum Rows and Columns
2.15
Loading Cell on Demand
2.16
Image
2.17
Display or Hide Grid Lines
2.18
Rich Texts and Bullet Texts in a Cell
3
Report
3.1
PDF Exporting
3.2
Support exporting Excel Chart to PDF
4
Chart
4.1
Support showing chart(Bar, Bar3D, Line, Line3D, Pie, Pie3D, Donut, Excel 97-2003, xls, Excel 2007, xlsx)
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 functions
6.1.4
Text formula functions
6.1.5
Information formula functions
6.1.6
Date & Time functions
6.1.7
Logical formula functions
6.1.8
Financial Formula Functions
6.1.9
Engineering Formula Functions
6.2
Custom Functions
7
Java Bean Binding
8
Downloads
9
References
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