New Features of ZK Spreadsheet 2.0

From Documentation

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.

Change Style by Quick Style Menu

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/Paste Special

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.

LoadCellOnDemand.png

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

KeyEvent.png

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.


SelectionEvents.png

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 Financial Formula Functions:

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 Engineering Formula Functions:

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.

DataBinding Chart.png

Downloads

References

Integrate ZK Spreadsheet 2.0.0 with Spring

Use JavaBean in Excel with ZK Spreadsheet 2.0.0