New Features of ZK Spreadsheet 2.0
Introduction
This article introduces new features of ZK Spreadsheet 2.0.0.
Rich Functionality
Menu of Functions
You can use menu item on the menubar to manipulate ZK Spreadsheet.
Styles
Change Style by toolbar button
ZK Spreadsheet supports editing content of cell by Quick Access Toolbar.
ZK Spreadsheet provides a convenience function for editing style -- Quick Style Menu --. Following will show an example of Quick Style Menu.
Number Formatting
ZK Spreadsheet supports number formatting.
Rich Texts and Bullet Texts in a Cell
ZK Spreadsheet supports applying different text formats in a cell.
Multiple Sheets Tabs
ZK Spreadsheet can show multiple sheets in different tabs.
Quick Keyboard Shortcut Keys
ZK Spreadsheet supports several shortcut keys.
Adding Hyperlink
You can insert hyperlink into ZK Spreadsheet.
Drag and Drop Editing of Selected Range
ZK Spreadsheet supports drag-and-drop editing that you can use the mouse to move and copy cells, rows, and columns.
Inserting or Deleting Row/Column/Cell
End user can insert or delete row, column or cell in ZK Spreadsheet.
Auto Fill Cells
You can drag to auto-fill cells on ZK Spreadsheet.
Support Copy/Paste/PasteSpecial
Support Ascending/Descending/Customizing Sorting
ZK Spreadsheet does not only support normal ascending/descending sorting, but also supports customizing sorting.
Editing
ZK Spreadsheet supports content editing.
Selection and Highlight
Selection is a special rectangle to show an area of cells that been selected, it could be changed either by user or program. Highlight is a special rectangle too, but it only could be changed by program. You could use highlight to emphasize a area that are marked to do something such as copy.
Manipulating Rows and Columns
You can manipulate row(s) and column(s) in ZK Spreadsheet. Even you can customize header of row(s) and column(s). Additionally, you also can decide whether to display header of row(s) and column(s) or not.
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 by Context Menu
Hide and Unhide Rows and Columns by Dragging
Maximum Rows and Columns
You can decide to show how many rows and columns.
Loading Cells on Demand
ZK Spreadsheet supports loading cells on demand.
Image
Users can open excel file which includes image on ZK Spreadsheet.
Display or Hide Grid Lines
You can deside to hide or display grid lines on ZK Spreadsheet.
Chart
Support showing chart
ZK Spreadsheet supports presenting chart. Additionally, the chart in ZK Spreadsheet is "live".
Report
PDF Exporting
You can export all sheets, current sheet, or selection range in ZK Spreadsheet to a PDF file.
Support exporting Excel Chart to PDF
ZK Spreadsheet supports export sheet chart to a PDF file.
Events
ZK Spreadsheet supports numerous events such as Editing Events, Key Events, Mouse Events, Selection Events and Hyperlink Event. You can listen to these events to develop highly interactive spreadsheet applications. If you want to know more detail, please reference Implement ZK Spreadsheet Event Listeners
Editing Events
There are three editing events that ZK Spreadsheet supports: onStartEditing, onStopEditing, onEditboxEditing.
Key Events
Users can write key event listeners for key events such as ctrl+C, ctrl+V to call relative ZK Spreadsheet APIs to really copy and paste cell(s).
Mouse Events
There are two types of Mouse events. One is cell mouse events such as onCellClick, onCellDoubleClick and onCellRightClick; and the other is header mouse events such as onHeaderClick, onHeaderDoubleClick and onHeaderRightClick. Following is an onHeaderRightClick event example. When end user right clicks the header of column or row, onHeaderRightClick event will be triggered. You can write an event listener to listen this event and popup context menu.
Selection Events
You can write selection event listeners for selection events. A very simple example is like following. When end user select a cell, selection event will be triggered. Formula bar and name box listen to the event and show the value and cell name of the selected cell, respectively.
Hyperlink Event
ZK Spreadsheet supports hyperlink event: This event will be triggered after user clicked hyperlink on ZK Spreadsheet.
Functions
Built-in Functions
ZK Spreadsheet supports following formula functions: (Total: 246)
Math formula functions
Total 60 Math formula functions:
ABS |
ACOS |
ACOSH |
ASIN |
ASINH |
ATAN |
ATAN2 |
ATANH |
CEILING |
COMBIN |
COS |
COSH |
DEGREES |
EVEN |
EXP |
FACT |
FACTDOUBLE |
FLOOR |
GCD |
INT |
LCM |
LN |
LOG |
LOG10 |
MDETERM |
MINVERSE |
MMULT |
MOD |
MROUND |
MULTINOMIAL |
ODD |
PI |
POWER |
PRODUCT |
QUOTIENT |
RADIANS |
RAND |
RANDBETWEEN |
ROMAN |
ROUND |
ROUNDDOWN |
ROUNDUP |
SERIESSUM |
SIGN |
SIN |
SINH |
SQRT |
SQRTPI |
SUBTOTAL |
SUM |
SUMIF |
SUMIFS |
SUMPRODUCT |
SUMSQ |
SUMX2MY2 |
SUMX2PY2 |
SUMXMY2 |
TAN |
TANH |
TRUNC |
Statistical formula functions
Total 45 Statistical formula functions:
AVEDEV |
AVERAGE |
AVERAGEA |
AVERAGEIF |
AVERAGEIFS |
BETADIST |
BETAINV |
BINOMDIST |
CHIDIST |
CHIINV |
COUNT |
COUNTA |
COUNTBLANK |
COUNTIF |
DEVSQ |
EXPONDIST |
FDIST |
FINV |
GAMMADIST |
GAMMAINV |
GAMMALN |
GEOMEAN |
GROWTH |
HARMEAN |
HYPGEOMDIST |
INTERCEPT |
KURT |
LARGE |
MAX |
MAXA |
MEDIAN |
MIN |
MINA |
MODE |
NORMDIST |
POISSON |
SKEW |
SLOPE |
SMALL |
STDEV |
STDEVA |
TDIST |
TINV |
VAR |
WEIBULL |
Text Formula Functions
Total 24 Text Formula Functions:
CHAR |
CLEAN |
CODE |
CONCATENATE |
DOLLAR |
EXACT |
FIND, FINDB |
FIXED |
LEFT, LEFTB |
LEN, LENB |
LOWER |
MID, MIDB |
PHONETIC |
PROPER |
REPLACE, REPLACEB |
REPT |
RIGHT, RIGHTB |
SEARCH, SEARCHB |
SUBSTITUTE |
T |
TEXT |
TRIM |
UPPER |
VALUE |
Information Formula Functions
Total 16 Information Formula Functions:
ERROR.TYPE |
INFO |
ISBLANK |
ISERR |
ISERROR |
ISEVEN |
ISLOGICAL |
ISNA |
ISNONTEXT |
ISNUMBER |
ISODD |
ISREF |
ISTEXT |
N |
NA |
TYPE |
Date & Time Functions
Total 15 Date & Time Functions:
DATE |
DATEVALUE |
DAY |
DAYS360 |
HOUR |
MINUTE |
MONTH |
NETWORKDAYS |
NOW |
SECOND |
TIME |
TIMEVALUE |
TODAY |
WEEKDAY |
YEAR |
Logical Formula Functions
Total 7 Logical Formula Functions:
AND |
FALSE |
IF |
IFERROR |
NOT |
OR |
TRUE |
Financial Formula Functions(Total: 41)
ACCRINT |
ACCRINTM |
AMORDEGRC |
AMORLINC |
COUPDAYBS |
COUPDAYS |
COUPDAYSNC |
COUPNCD |
COUPNUM |
COUPPCD |
CUMIPMT |
CUMPRINC |
DB |
DDB |
DISC |
DOLLARDE |
DOLLARFR |
DURATION |
EFFECT |
FV |
FVSCHEDULE |
INTRATE |
IPMT |
NOMINAL |
NPER |
NPV |
PMT |
PPMT |
PRICE |
PRICEDISC |
PRICEMAT |
PV |
RECEIVED |
SLN |
SYD |
TBILLEQ |
TBILLYIELD |
XNPV |
YIELD |
YIELDDISC |
YIELDMAT |
Engineering Formula Functions(Total: 38)
BESSELI |
BESSELJ |
BESSELK |
BESSELY |
BIN2DEC |
BIN2HEX |
BIN2OCT |
COMPLEX |
DEC2BIN |
DEC2HEX |
DEC2OCT |
DELTA |
ERF |
ERFC |
GESTEP |
HEX2BIN |
HEX2DEC |
HEX2OCT |
IMABS |
IMAGINARY |
IMARGUMENT |
IMCONJUGATE |
IMCOS |
IMDIV |
IMEXP |
IMLN |
IMLOG10 |
IMLOG2 |
IMPOWER |
IMPRODUCT |
IMREAL |
IMSIN |
IMSQRT |
IMSUB |
IMSUM |
OCT2BIN |
OCT2DEC |
OCT2HEX |
Custom Functions
You can implement your own formula functions in ZK Spreadsheet.
Java Bean Binding
ZK Spreadsheet supports resolving the name expressions in cells to bind the data from the back end Java beans automatically.