New Features of ZK Spreadsheet 2.0"

From Documentation
 
(92 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
{{Template:Smalltalk_Author|
 +
|author= The ZK Team
 +
|date=January 25, 2011
 +
|version=ZK Spreadsheet 2.0.1
 +
}}
 
__TOC__
 
__TOC__
−
 
 
=Introduction=
 
=Introduction=
 +
ZK Spreadsheet is an Ajax component that delivers functionalities found in Microsoft Excel to your browsers.<br/>
 +
Embedding ZK Spreadsheet in your Java web application to garner features such as:
 +
*Import your Excel 2003/2007 files to ZK Spreadsheet and make them collaborative online.
 +
*Control or configure an Ajax spreadsheet with pure Java and seamlessly integrate with Java EE and other back-end services.
 +
*Register event listeners on rows, columns, cells, or any range of selected cells to make a highly interactive web application.
 +
*Enter name expressions in cells to make bindings to back-end Java beans transparently, including Spring and CDI managed beans.
 +
*Export to Excel or PDF for reporting
 +
*Extend on top of hundreds built in functions that come with ZK Spreadsheet in Java.
 +
*Use ZK Spreadsheet as a JSF Component.
 +
*Use ZK Spreadsheet as a JSP Component.
  
−
This article introduces new features of ZK Spreadsheet 2.0.0.
+
=Features=
−
 
+
==Embeddable Ajax Java Component==
−
=Rich Functionality=
 
−
 
 
−
==Menu of Functions==
 
−
 
 
−
You can use menu item on the menubar to manipulate ZK Spreadsheet.
 
−
 
 
−
<gflash width="770" height="600">MenuFunction.swf</gflash>
 
−
 
 
−
==Styles==
 
−
 
 
−
===Change Style by Toolbar Button===
 
−
 
 
−
ZK Spreadsheet supports editing content of cell by Quick Access Toolbar.
 
−
 
 
−
<gflash width="760" height="600">FastIconToolbar.swf</gflash>
 
−
 
 
−
===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.
 
−
 
 
−
<gflash width="760" height="600">ChangeStyleByContextMenu.swf</gflash>
 
−
 
 
−
===Number Formatting===
 
−
 
 
−
ZK Spreadsheet supports number formatting.
 
−
 
 
−
<gflash width="785" height="600">NumberFormatting.swf</gflash>
 
−
 
 
−
===Rich Texts and Bullet Texts in a Cell===
 
−
 
 
−
ZK Spreadsheet supports applying different text formats in a cell.
 
−
 
 
−
<gflash width="770" height="600">RichFormattedText.swf</gflash>
 
−
 
 
−
==Multiple Sheets Tabs==
 
−
 
 
−
ZK Spreadsheet can show multiple sheets in different tabs.
 
−
 
 
−
<gflash width="780" height="600">Muti-Sheets.swf</gflash>
 
−
 
 
−
==Quick Keyboard Shortcut Keys==
 
−
 
 
−
ZK Spreadsheet supports several shortcut keys.
 
−
 
 
−
<gflash width="785" height="600">ShortcutKeys.swf</gflash>
 
−
 
 
−
==Adding Hyperlink==
 
−
 
 
−
You can insert hyperlink into ZK Spreadsheet.
 
−
 
 
−
<gflash width="770" height="600">Hyperlink.swf</gflash>
 
−
 
 
−
==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.
 
−
 
 
−
<gflash width="785" height="600">DragNDropCells.swf</gflash>
 
−
 
 
−
==Inserting or Deleting Row/Column/Cell==
 
−
 
 
−
End user can insert or delete row, column or cell in ZK Spreadsheet.
 
−
 
 
−
<gflash width="750" height="600">AlterRanges.swf</gflash>
 
−
 
 
−
==Auto Fill Cells==
 
−
 
 
−
You can drag to auto-fill cells on ZK Spreadsheet.
 
−
 
 
−
<gflash width="780" height="670">AutoFillCells.swf</gflash>
 
−
 
 
−
==Support Copy/Paste/Paste Special==
 
−
 
 
−
<gflash width="770" height="600">CopyPaste.swf</gflash>
 
−
 
 
−
==Support Ascending/Descending/Customizing Sorting==
 
−
 
 
−
ZK Spreadsheet does not only support normal ascending/descending sorting, but also supports customizing sorting.
 
−
 
 
−
<gflash width="770" height="600">Sorting.swf</gflash>
 
−
 
 
−
==Editing==
 
−
 
 
−
ZK Spreadsheet supports content editing.
 
−
 
 
−
<gflash width="785" height="600">EditingZSS.swf</gflash>
 
  
−
==Selection and Highlight==
+
*'''Server-centric Architecture'''
 +
*:Seamlessly integrate with Java EE, Web services and other back-end technologies.
 +
*:No JavaScript required.
  
−
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.
+
*'''Fully Controllable in Java'''
 +
*: The backend data model and formula evaluation engine is built on top of the Apache POI library. Developers could control, configure, or extend the Ajax spreadsheet entirely in Java.
 +
* '''Event Driven'''
 +
*: A comprehensive set of events were designed to allow developers to create a highly interactive spreadsheet application.
 +
*: [/_w/images/8/88/EditingEvents.swf See Demo-Editing Events], [/_w/images/c/cd/KeyEvent.png See Illustration-Key Events], [/_w/images/1/1b/OnHeaderRightClick.swf See Demo-Mouse Events], [/_w/images/4/40/SelectionEvents.png See Illustration-Selection Events]
 +
*:[[ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Implement_ZK_Spreadsheet_Event_Listeners | Read Doc]]
  
−
<gflash width="785" height="600">SelectionHighlight.swf</gflash>
+
* '''Java Bean Binding'''[[#Reference | *]]
 +
*: ZK Spreadsheet resolves name expressions in cells to make bindings to back-end Java beans transparently, including Spring and CDI managed beans.
 +
*: [/_w/images/5/5e/DataBinding_Chart.png See Illustration]
  
−
==Manipulating Rows and Columns==
+
* '''Embeddable in Java Web Pages'''
 +
*: ZK Spreadsheet is a ZK component which developers could embed into any Java web application, such as JSP, JSF, and ZUML.
 +
*: Interact with other Ajax components such as Charts, Google Maps, etc.
  
−
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.
+
*'''Support All Major Browsers without Plugin'''
 +
*: Ajax interactivity without Applets, Flash, ActiveX, or Excel.
 +
*: ZK Spreadsheet supports all major browsers: IE 6-9, Firefox, Chrome, Safari, Opera, ...
  
−
===Headers===
+
* '''Collaborate Among Multiple Users'''[[#Reference | *]]
 +
*: Allow multiple users to collaborate on the same worksheet.
  
−
====Custom Row and Column Title====
+
* '''Use as a JSF Component'''[[#Reference | *]]
 +
*: In addition as an embeddable ZK component, ZK Spreadsheet is also provided as a JSF Ajax Component.
  
−
<gflash width="770" height="600">ModifyHeader.swf</gflash>
+
==Imort/Export Worksheet==
 +
* '''Import/Export Excel 2003/2007 Files'''
 +
*: Import or export worksheets with xls (Excel 2003) or xlsx (Excel 2007) formats.
  
−
====Hide/Unhide Row Headers and/or Column Headers====
+
* '''Export to PDF'''[[#Reference | *]]
 +
*: Print worksheets or a selection of cells to PDF.
 +
*:  [/_w/images/5/5a/ExportPDF.swf See Demo]
  
−
<gflash width="770" height="600">HeaderDisplay.swf</gflash>
+
==Worksheet Operations==
 +
* '''3-D Cell Reference'''
 +
*: Reference the same cell or range on multiple worksheets
  
−
===Controlling/Editing===
+
* '''External Book Reference'''[[#Reference | *]]
 +
*: Reference a cell or range on a worksheet in another workbook.
  
−
====Freezing Row and Column====
+
*  '''Sorting and Custom Sort'''
 +
*: Sort columns or rows in ascending/descending order, or sort with predefined conditions, such as sorting columns of data one by one sequentially.
 +
*: [/_w/images/c/cf/Sorting.swf See Demo]
  
−
<gflash width="785" height="600">FreezeColRow.swf</gflash>
+
* '''Drag and Drop Editing of Selected Cells'''
 +
*:  Use drag and drop to copy or move selected cell on worksheets.
 +
*:  [/_w/images/9/9c/DragNDropCells.swf See Demo]
  
−
====Hide and Unhide Rows and Columns by Context Menu====
+
*  '''Auto-fill Cells'''
 +
*:  Select and drag a selection of cells to copy their content to adjacent cells.
 +
*:  [/_w/images/6/69/AutoFillCells.swf See Demo]
  
−
<gflash width="770" height="600">HideRowCol.swf</gflash>
+
* '''Merge/Unmerge Cells'''
 +
*: ZK Spreadsheet supports merging and unmerging of horizontal cells
  
−
====Hide and Unhide Rows and Columns by Dragging====
+
* '''Copy-Paste Cells with Paste Special Support'''
 +
*: Users can copy and paste selected cells with the option of executing a specific paste special task.
 +
*:  [/_w/images/b/b4/CopyPaste.swf See Demo]
  
−
<gflash width="785" height="600">HideRowColByDragging.swf</gflash>
+
*'''Access Named Range of Cells'''
 +
*: Access a named range imported from Excel in ZK Spreadsheet.
  
−
====Maximum Rows and Columns====
+
* '''Insert/Delete Rows, Columns, or a Range of Cells'''
 +
*: Rows, columns, or a selected range of cells can be inserted or deleted dynamically.
 +
*: [/_w/images/a/a2/AlterRanges.swf See Demo]
  
−
You can decide to show how many rows and columns.
+
*  '''Keystroke Shortcuts'''
 +
*: ZK Spreadsheet has an array of built in shortcuts, such as "Ctrl + Delete" for clearing CSS styling,"Shift + Arrow Keys" for selecting a range of cells, etc.
 +
*:  [/_w/images/4/41/ShortcutKeys.swf See Demo]
  
−
<gflash width="770" height="600">MaxColRow.swf</gflash>
+
* '''Hyperlink Web Pages'''
 +
*: A hyperlink can be opened in the same window or users can hold the Ctrl key to open the web page in a new tab.
 +
*: [/_w/images/c/cd/Hyperlink.swf See Demo]
  
−
==Loading Cells on Demand==
+
* '''Multi-line In-place Cell Editing'''
 +
*: Users can key in multiple rows in a cell.
 +
<!-- [/_w/images/9/9e/EditingZSS.swf See Demo] This demo shows in-place editing, not multi-line-->
  
−
ZK Spreadsheet supports loading cells on demand.
+
==Worksheet Customization==
 +
*  '''User Defined Functions'''[[#Reference | *]]
 +
*: ZK Spreadsheet allows developers to implement custom formula functions on top of hundreds built in ones in Java. End users can use custom these functions just like any other built in functions.
  
−
[[image:LoadCellOnDemand.png]]
+
* '''Multiple Worksheets'''
 +
*:  Multiple worksheets are allowed for a workbook
 +
*: [/_w/images/d/d4/Muti-Sheets.swf See Demo]
  
−
==Image==
+
* '''Freeze Rows and Columns'''
 +
*: Rows and columns can be made frozen so that desired rows or columns are locked in view.
 +
*: [/_w/images/d/d1/FreezeColRow.swf See Demo]
  
−
Users can open excel file which includes image on ZK Spreadsheet.
+
* '''Hide/Show Rows and Columns'''
 +
*: Rows and columns can be shown or hidden using context menu or by simply dragging the rows or columns to collapse or expand.
 +
*: [/_w/images/b/b0/HideRowCol.swf See Demo - Using Context Menu]
 +
*: [/_w/images/1/12/HideRowColByDragging.swf See Demo - Using Drag and Collapse/Expand]
  
−
<gflash width="830" height="670">LoadImage.swf</gflash>
+
* '''Hide/Show Row/Column Headers'''
 +
*:  Headers for rows and columns can be made visible/invisible
  
−
==Display or Hide Grid Lines==
+
*  '''Modify Row/Column Headers'''
 +
*: [/_w/images/1/12/ModifyHeader.swf See Demo]
  
−
You can deside to hide or display grid lines on ZK Spreadsheet.
+
*  '''Hide/Show Grid Lines'''
 +
*: Users can make grid visible/invisible with a click of the check-box.
 +
*: [/_w/images/c/c5/GridLines.swf See Demo]
  
−
<gflash width="790" height="670">GridLines.swf</gflash>
+
*  '''Set Maximum Rows and Columns Allowed'''
 +
*: The maximum number of rows and columns allowed for a ZK Spreadsheet component can be predefined.
 +
*: [/_w/images/0/04/MaxColRow.swf See Demo]
  
−
=Chart=
+
* '''Set Column Width and Row Height'''
 +
*: Column width and row height are adjustable.
  
−
==Support Showing Chart==
+
* '''Set Worksheet Size'''
 +
*: ZK Spreadsheet is sizable just like other ZK components.
  
−
ZK Spreadsheet supports presenting chart. Additionally, the chart in ZK Spreadsheet is '''"live"'''.
+
*: [[ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Implement_Your_Own_Formula_Functions/As_Simple_as_a_Java_Static_Method | Read Doc]]
  
−
<gflash width="785" height="600">ColumnChart.swf</gflash>
+
==Cell Formatting and Styling==
 +
* '''CSS Styling'''
 +
*: Cells can be styled using CSS definitions.
 +
*: [/_w/images/d/d4/FastIconToolbar.swf See Toolbar Demo]
 +
*: [/_w/images/b/b3/ChangeStyleByContextMenu.swf See Context-menu Demo]
  
−
=Report=
+
* '''Bullet List in Cells'''
 +
*: Content in cells can be shown in bullet form.
  
−
==PDF Exporting==
+
* '''Number Formatting'''
 +
*:  Numbers can be formatted to reflect their context such as date, currency, etc.
 +
*: [/_w/images/b/bf/NumberFormatting.swf See Demo]
  
−
You can export all sheets, current sheet, or selection range in ZK Spreadsheet to a PDF file.
+
*  '''Text Formatting'''
 +
*: Text formatting options include font, boldfaced, italic, among others. Any text format imported from an Excel worksheet would remain consistent in ZK Spreadsheet.
 +
*:[/_w/images/5/52/RichFormattedText.swf See Demo]
  
−
<gflash width="800" height="600">ExportPDF.swf</gflash>
+
* '''Input Mask for Date and Time'''
 +
*: Data and time values are converted to the appropriate format.
  
−
==Support Exporting Excel Chart to PDF==
+
* '''Text Overflow to Adjacent Cells'''
 +
*: Over-sized content in cells is automatically overflown to the right adjacent cell.
  
−
ZK Spreadsheet supports export sheet chart to a PDF file.
+
*'''Text Wrapping'''
 +
*: Over-sized content can be wrapped in cells.
  
−
<gflash width="750" height="600">ExportChartPDF.swf</gflash>
+
*  '''Selected Cells Highlighting'''
 +
*: Selected cells are masked with a shade.
 +
*: [/_w/images/8/8b/SelectionHighlight.swf See Demo]
  
−
=Events=
+
* '''Set Borders'''
−
ZK Spreadsheet supports numerous events such as [http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Implement_ZK_Spreadsheet_Event_Listeners/Editing_Events Editing Events], [http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Implement_ZK_Spreadsheet_Event_Listeners/Key_Events Key Events], [http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Implement_ZK_Spreadsheet_Event_Listeners/Mouse_Events Mouse Events], [http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Implement_ZK_Spreadsheet_Event_Listeners/Selection_Events Selection Events] and [http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Implement_ZK_Spreadsheet_Event_Listeners/Hyperlink_Event Hyperlink Event]. You can listen to these events to develop highly interactive spreadsheet applications. If you want to know more detail, please reference
+
*: Borders of a cell can be made visible or invisible.
−
[http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Implement_ZK_Spreadsheet_Event_Listeners Implement ZK Spreadsheet Event Listeners]
 
  
−
==Editing Events==
+
* '''Text Alignment'''
−
There are three editing events that ZK Spreadsheet supports: '''onStartEditing''', '''onStopEditing''', '''onEditboxEditing'''.
+
*:  Text in cells can be made aligned to right, center, and left.
 +
*: [/_w/images/5/51/MenuFunction.swf  See Menu Demo]
  
−
<gflash width="770" height="600">EditingEvents.swf</gflash>
+
==Charts and Images==
 +
* '''Work with Interactive Excel Charts'''[[#Reference | *]]
 +
*: Charts created in Excel can be imported to ZK Spreadsheet. Changes in the data are reflected on the charts instantly.
 +
*: Charts supported include: Bar, Bar3D, Line, Line3D, Pie, Pie3D, and Donut in 2003(xls) and 2007(xlsx) format.
 +
*:  [/_w/images/2/2c/ColumnChart.swf See Demo]
  
−
==Key Events==
+
* '''Export Excel Charts to PDF'''[[#Reference | *]]
−
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).
+
*: Export Excel charts to PDF
 +
*:  [/_w/images/3/3f/ExportChartPDF.swf See Demo]
  
−
[[File:KeyEvent.png]]
+
* '''Insert/Import Images'''[[#Reference | *]]
 +
*: Users can insert images into cells and images embedded in an Excel 2003 (xls) and 2007 (xlsx) worksheets can be rendered in ZK Spreadsheet when it is imported into ZK Spreadsheet.
 +
*: [/_w/images/0/00/LoadImage.swf See Demo]
  
−
==Mouse Events==
+
==Worksheet Utilities==
−
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.
+
* '''Load on Demand'''
−
 
+
*:  Like other tabular components in ZK, ZK Spreadsheet supports “Load on Demand” which only the cells in view are loaded.
−
<gflash width="800" height="600">OnHeaderRightClick.swf</gflash>
+
*:  [/_w/images/1/1a/LoadCellOnDemand.png See Illustration]
−
 
+
* '''Efficient Formula Reference Dependency Tracking'''
−
==Selection Events==
+
*: Advanced algorithm for formula evaluation and calculation.
−
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.
+
* '''POI Enhancements'''
−
 
+
*: Performance tuning, bug fixing, feature enhancements, etc.
−
 
 
−
[[File: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==
 
==Built-in Functions==
 +
'''38 Financial Formula Functions'''[[#Reference | *]]
  
−
ZK Spreadsheet supports following formula functions: (Total: 246)
+
{| cellpadding=5 style="border:1px solid #BBB" width="90%"
−
 
+
| ACCRINT || ACCRINTM || AMORDEGRC || AMORLINC || COUPDAYBS || COUPDAYS || COUPDAYSNC || COUPNCD || COUPNUM || COUPPCD
−
===Math Formula Functions===
 
−
 
 
−
Total 60 Math Formula Functions:
 
−
 
 
−
{| class="wikitable"
 
−
|-
 
−
|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
+
| CUMIPMT || CUMPRINC || DB || DDB || DISC || DOLLARDE || DOLLARFR || DURATION || EFFECT || FV
 
|-
 
|-
−
|SUM
+
| FVSCHEDULE || INTRATE || IPMT || NOMINAL || PPMT || PRICE || PRICEDISC || PRICEMAT || PV || RECEIVED
 
|-
 
|-
−
|SUMIF
+
| SLN || SYD || TBILLEQ || TBILLYIELD || XNPV || YIELD || YIELDDISC || YIELDMAT
−
|-
 
−
|SUMIFS
 
−
|-
 
−
|SUMPRODUCT
 
−
|-
 
−
|SUMSQ
 
−
|-
 
−
|SUMX2MY2
 
−
|-
 
−
|SUMX2PY2
 
−
|-
 
−
|SUMXMY2
 
−
|-
 
−
|TAN
 
−
|-
 
−
|TANH
 
−
|-
 
−
|TRUNC
 
 
|}
 
|}
 +
<br/>
  
−
===Statistical Formula Functions===
+
'''60 Math Formula Functions'''[[#Reference | *]]
−
 
+
{| cellpadding=5 style="border:1px solid #BBB" width="90%"
−
Total 45 Statistical Formula Functions:
+
| ABS || ACOS || ACOSH || ASIN || ASINH || ATAN || ATAN2 || ATANH || CEILING || COMBINACCRINT
−
 
 
−
{| class="wikitable"
 
−
|-
 
−
|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
+
| COS  || COSH  || DEGREES  || EVEN  || EXP  || FACT  || FACTDOUBLE  || FLOOR  || GCD  || INT
 
|-
 
|-
−
|MAX
+
| LCM  || LN  || LOG  || LOG10  || MDETERM  || MINVERSE  || MMULT  ||  MOD  || MROUND  || MULTINOMIAL
 
|-
 
|-
−
|MAXA
+
| ODD  || PI  || POWER  || PRODUCT  || QUOTIENT  || RADIANS  || RAND  || RANDBETWEEN  || ROMAN  || ROUND
 
|-
 
|-
−
|MEDIAN
+
| ROUNDDOWN  || ROUNDUP  || SERIESSUM  || SIGN  || SIN  || SINH  || SQRT  || SQRTPI  || SUBTOTAL  || SUM
 
|-
 
|-
−
|MIN
+
| SUMIF || SUMIFS  || SUMPRODUCT  || SUMSQ  || SUMX2MY2  || SUMX2PY2  || SUMXMY2  || TAN  || TANH  || TRUNC
−
|-
 
−
|MINA
 
−
|-
 
−
|MODE
 
−
|-
 
−
|NORMDIST
 
−
|-
 
−
|POISSON
 
−
|-
 
−
|SKEW
 
−
|-
 
−
|SLOPE
 
−
|-
 
−
|SMALL
 
−
|-
 
−
|STDEV
 
−
|-
 
−
|STDEVA
 
−
|-
 
−
|TDIST
 
−
|-
 
−
|TINV
 
−
|-
 
−
|VAR
 
−
|-
 
−
|WEIBULL
 
 
|}
 
|}
−
 
+
<br/>
−
===Text Formula Functions===
+
'''45 Statistical Formula Functions'''[[#Reference | *]]
−
 
+
{| cellpadding=5 style="border:1px solid #BBB" width="90%"
−
Total 24 Text Formula Functions:
+
| AVEDEV || AVERAGE || AVERAGEA || AVERAGEIF || AVERAGEIFS || BETADIST || BETAINV || BINOMDIST || CHIDIST || CHIINV
−
 
 
−
{| class="wikitable"
 
−
|-
 
−
|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
+
|COUNT || COUNTA || COUNTBLANK || COUNTIF || DEVSQ || EXPONDIST || FDIST || FINV || GAMMADIST || GAMMAINV
 
|-
 
|-
−
|SUBSTITUTE
+
| GAMMALN || GEOMEAN || GROWTH || HARMEAN || HYPGEOMDIST || INTERCEPT || KURT || LARGE || MAX || MAXA
 
|-
 
|-
−
|T
+
| MEDIAN || MIN || MINA || MODE || NORMDIST || POISSON || SKEW || SLOPE || SMALL || STDEV
 
|-
 
|-
−
|TEXT
+
| STDEVA || TDIST || TINV || VAR || WEIBULL
−
|-
 
−
|TRIM
 
−
|-
 
−
|UPPER
 
−
|-
 
−
|VALUE
 
 
|}
 
|}
−
 
+
<br/>
−
===Information Formula Functions===
+
'''7 Logical Formula Functions'''[[#Reference | *]]
−
 
+
{| cellpadding=5 style="border:1px solid #BBB" width="90%"
−
Total 16 Information Formula Functions:
+
| AND || FALSE || IF || IFERROR || NOT || OR || TRUE
−
 
 
−
{| class="wikitable"
 
−
|-
 
−
|ERROR.TYPE
 
−
|-
 
−
|INFO
 
−
|-
 
−
|ISBLANK
 
−
|-
 
−
|ISERR
 
−
|-
 
−
|ISERROR
 
−
|-
 
−
|ISEVEN
 
−
|-
 
−
|ISLOGICAL
 
−
|-
 
−
|ISNA
 
−
|-
 
−
|ISNONTEXT
 
−
|-
 
−
|ISNUMBER
 
−
|-
 
−
|ISODD
 
−
|-
 
−
|ISREF
 
−
|-
 
−
|ISTEXT
 
−
|-
 
−
|N
 
−
|-
 
−
|NA
 
−
|-
 
−
|TYPE
 
 
|}
 
|}
−
 
+
<br/>
−
===Date & Time Functions===
+
'''38 Engineering Formula Functions'''[[#Reference | *]]
−
 
+
{| cellpadding=5 style="border:1px solid #BBB" width="90%"
−
Total 15 Date & Time Functions:
+
| BESSELI || BESSELJ || BESSELK || BESSELY || BIN2DEC || BIN2HEX || BIN2OCT || COMPLEX || DEC2BIN || DEC2HEX
−
 
 
−
{| class="wikitable"
 
−
|-
 
−
|DATE
 
−
|-
 
−
|DATEVALUE
 
−
|-
 
−
|DAY
 
−
|-
 
−
|DAYS360
 
−
|-
 
−
|HOUR
 
−
|-
 
−
|MINUTE
 
−
|-
 
−
|MONTH
 
−
|-
 
−
|NETWORKDAYS
 
−
|-
 
−
|NOW
 
−
|-
 
−
|SECOND
 
−
|-
 
−
|TIME
 
−
|-
 
−
|TIMEVALUE
 
 
|-
 
|-
−
|TODAY
+
| DEC2OCT || DELTA || ERF || ERFC || GESTEP || HEX2BIN || HEX2DEC || HEX2OCT || IMABS || IMAGINARY
 
|-
 
|-
−
|WEEKDAY
+
| IMARGUMENT || IMCONJUGATE || IMCOS || IMDIV || IMEXP || IMLN || IMLOG10 || IMLOG2 || IMPOWER || IMPRODUCT
 
|-
 
|-
−
|YEAR
+
| IMREAL || IMSIN || IMSQRT || IMSUB || IMSUM || OCT2BIN || OCT2DEC || OCT2HEX
 
|}
 
|}
−
 
+
<br/>
−
===Logical Formula Functions===
+
'''21 Text Functions'''[[#Reference | *]]
−
 
+
{| cellpadding=5 style="border:1px solid #BBB" width="90%"
−
Total 7 Logical Formula Functions:
+
| CHAR || CODE || CONCATENATE || DOLLAR || EXACT || FIND, FINDB || FIXED || LEFT, LEFTB || LEN, LENB || LOWER
−
 
 
−
{| class="wikitable"
 
−
|-
 
−
|AND
 
−
|-
 
−
|FALSE
 
−
|-
 
−
|IF
 
 
|-
 
|-
−
|IFERROR
+
| MID, MIDB || PROPER || REPLACE, REPLACEB || REPT || RIGHT, RIGHTB|| SEARCH, SEARCHB || SUBSTITUTE || T || TEXT ||  TRIM
 
|-
 
|-
−
|NOT
+
| UPPER
−
|-
 
−
|OR
 
−
|-
 
−
|TRUE
 
 
|}
 
|}
 +
<br/>
  
−
===Financial Formula Functions===
+
'''16 Info Functions'''[[#Reference | *]]
−
 
+
{| cellpadding=5 style="border:1px solid #BBB" width="90%"
−
Total 41 Financial Formula Functions:
+
| ERROR.TYPE || INFO || ISBLANK || ISERR || ISERROR || ISEVEN || ISLOGICAL || ISNA || ISNONTEXT || ISNUMBER
−
 
 
−
{| class="wikitable"
 
−
|ACCRINT
 
 
|-
 
|-
−
|ACCRINTM
+
| ISODD || ISREF || ISTEXT || N || NA || TYPE
−
|-
 
−
|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
 
 
|}
 
|}
−
 
+
<br/>
−
===Engineering Formula Functions===
+
'''14 Date & Time Functions'''[[#Reference | *]]
−
 
+
{| cellpadding=5 style="border:1px solid #BBB" width="90%"
−
Total 38 Engineering Formula Functions:
+
| DATE  || DATEVALUE  || DAY  || DAYS360  || HOUR  || MINUTE  || MONTH  ||  NOW  || SECOND || TIME
−
 
 
−
{| class="wikitable"
 
 
|-
 
|-
−
|BESSELI
+
| TIMEVALUE  || TODAY  || WEEKDAY  || YEAR
−
|-
 
−
|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
 
 
|}
 
|}
 +
<br/>
  
−
==Custom Functions==
+
==ZK Spreadsheet App==
 +
* '''Excel-like Web Application'''
 +
*: A stand-alone web based spreadsheet application that allows real-time online collaboration.
 +
*: Tap into the functionalities of ZK Spreadsheet with menus, context menus, dialogs, wizards, etc.
 +
*: Import/export Excel worksheets, Charts and PDF.
 +
<br/>
 +
=Reference=
 +
[[ZK Spreadsheet Essentials]]
  
−
You can [http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Implement_Your_Own_Formula_Functions/As_Simple_as_a_Java_Static_Method implement your own formula functions] in ZK Spreadsheet.
+
[[ZK Spreadsheet Quick Start Guide]]
  
−
= Java Bean Binding=
+
[[Small_Talks/2008/May/Integrate_ZK_Spreadsheet_with_Spring | Integrate ZK Spreadsheet with Spring]]
  
−
ZK Spreadsheet supports resolving the [http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Bind_Java_Bean_to_ZK_Spreadsheet name expressions in cells to bind the data from the back end Java beans automatically].
+
[[Small_Talks/2008/April/Use_JavaBean_in_Excel_with_ZK_Spreadsheet | Use JavaBean in Excel with ZK Spreadsheet]]
  
−
[[File:DataBinding_Chart.png]]
+
'''*'''ZK Spreadsheet have the standard and EE versions; for the feature comparison list, please [http://www.zkoss.org/product/zkspreadsheet-edition.dsp click here]
  
−
=Downloads=
 
  
−
=References=
+
{{Template:CommentedSmalltalk_Footer|
−
 
+
|name=Potix Corporation
−
[http://docs.zkoss.org/wiki/Integrate_ZK_Spreadsheet2.0.0_with_Spring Integrate ZK Spreadsheet 2.0.0 with Spring]
+
}}
−
*[[Small_Talks/2008/May/Integrate_ZK_Spreadsheet_with_Spring | Integrate ZK Spreadsheet with Spring]]
 
−
 
 
−
 
 
−
[http://docs.zkoss.org/wiki/Use_JavaBean_in_Excel_with_ZK_Spreadsheet_2.0.0 Use JavaBean in Excel with ZK Spreadsheet 2.0.0]
 
−
[[Small_Talks/2008/April/Use_JavaBean_in_Excel_with_ZK_Spreadsheet | Use JavaBean in Excel with ZK Spreadsheet]]
 

Latest revision as of 09:52, 25 January 2011

DocumentationSmall Talks2010DecemberNew Features of ZK Spreadsheet 2.0
New Features of ZK Spreadsheet 2.0
Author
The ZK Team
Date
January 25, 2011
Version
ZK Spreadsheet 2.0.1

Introduction

ZK Spreadsheet is an Ajax component that delivers functionalities found in Microsoft Excel to your browsers.
Embedding ZK Spreadsheet in your Java web application to garner features such as:

  • Import your Excel 2003/2007 files to ZK Spreadsheet and make them collaborative online.
  • Control or configure an Ajax spreadsheet with pure Java and seamlessly integrate with Java EE and other back-end services.
  • Register event listeners on rows, columns, cells, or any range of selected cells to make a highly interactive web application.
  • Enter name expressions in cells to make bindings to back-end Java beans transparently, including Spring and CDI managed beans.
  • Export to Excel or PDF for reporting
  • Extend on top of hundreds built in functions that come with ZK Spreadsheet in Java.
  • Use ZK Spreadsheet as a JSF Component.
  • Use ZK Spreadsheet as a JSP Component.

Features

Embeddable Ajax Java Component

  • Server-centric Architecture
    Seamlessly integrate with Java EE, Web services and other back-end technologies.
    No JavaScript required.
  • Fully Controllable in Java
    The backend data model and formula evaluation engine is built on top of the Apache POI library. Developers could control, configure, or extend the Ajax spreadsheet entirely in Java.
  • Event Driven
    A comprehensive set of events were designed to allow developers to create a highly interactive spreadsheet application.
    [/_w/images/8/88/EditingEvents.swf See Demo-Editing Events], [/_w/images/c/cd/KeyEvent.png See Illustration-Key Events], [/_w/images/1/1b/OnHeaderRightClick.swf See Demo-Mouse Events], [/_w/images/4/40/SelectionEvents.png See Illustration-Selection Events]
    Read Doc
  • Java Bean Binding *
    ZK Spreadsheet resolves name expressions in cells to make bindings to back-end Java beans transparently, including Spring and CDI managed beans.
    [/_w/images/5/5e/DataBinding_Chart.png See Illustration]
  • Embeddable in Java Web Pages
    ZK Spreadsheet is a ZK component which developers could embed into any Java web application, such as JSP, JSF, and ZUML.
    Interact with other Ajax components such as Charts, Google Maps, etc.
  • Support All Major Browsers without Plugin
    Ajax interactivity without Applets, Flash, ActiveX, or Excel.
    ZK Spreadsheet supports all major browsers: IE 6-9, Firefox, Chrome, Safari, Opera, ...
  • Collaborate Among Multiple Users *
    Allow multiple users to collaborate on the same worksheet.
  • Use as a JSF Component *
    In addition as an embeddable ZK component, ZK Spreadsheet is also provided as a JSF Ajax Component.

Imort/Export Worksheet

  • Import/Export Excel 2003/2007 Files
    Import or export worksheets with xls (Excel 2003) or xlsx (Excel 2007) formats.
  • Export to PDF *
    Print worksheets or a selection of cells to PDF.
    [/_w/images/5/5a/ExportPDF.swf See Demo]

Worksheet Operations

  • 3-D Cell Reference
    Reference the same cell or range on multiple worksheets
  • External Book Reference *
    Reference a cell or range on a worksheet in another workbook.
  • Sorting and Custom Sort
    Sort columns or rows in ascending/descending order, or sort with predefined conditions, such as sorting columns of data one by one sequentially.
    [/_w/images/c/cf/Sorting.swf See Demo]
  • Drag and Drop Editing of Selected Cells
    Use drag and drop to copy or move selected cell on worksheets.
    [/_w/images/9/9c/DragNDropCells.swf See Demo]
  • Auto-fill Cells
    Select and drag a selection of cells to copy their content to adjacent cells.
    [/_w/images/6/69/AutoFillCells.swf See Demo]
  • Merge/Unmerge Cells
    ZK Spreadsheet supports merging and unmerging of horizontal cells
  • Copy-Paste Cells with Paste Special Support
    Users can copy and paste selected cells with the option of executing a specific paste special task.
    [/_w/images/b/b4/CopyPaste.swf See Demo]
  • Access Named Range of Cells
    Access a named range imported from Excel in ZK Spreadsheet.
  • Insert/Delete Rows, Columns, or a Range of Cells
    Rows, columns, or a selected range of cells can be inserted or deleted dynamically.
    [/_w/images/a/a2/AlterRanges.swf See Demo]
  • Keystroke Shortcuts
    ZK Spreadsheet has an array of built in shortcuts, such as "Ctrl + Delete" for clearing CSS styling,"Shift + Arrow Keys" for selecting a range of cells, etc.
    [/_w/images/4/41/ShortcutKeys.swf See Demo]
  • Hyperlink Web Pages
    A hyperlink can be opened in the same window or users can hold the Ctrl key to open the web page in a new tab.
    [/_w/images/c/cd/Hyperlink.swf See Demo]
  • Multi-line In-place Cell Editing
    Users can key in multiple rows in a cell.

Worksheet Customization

  • User Defined Functions *
    ZK Spreadsheet allows developers to implement custom formula functions on top of hundreds built in ones in Java. End users can use custom these functions just like any other built in functions.
  • Multiple Worksheets
    Multiple worksheets are allowed for a workbook
    [/_w/images/d/d4/Muti-Sheets.swf See Demo]
  • Freeze Rows and Columns
    Rows and columns can be made frozen so that desired rows or columns are locked in view.
    [/_w/images/d/d1/FreezeColRow.swf See Demo]
  • Hide/Show Rows and Columns
    Rows and columns can be shown or hidden using context menu or by simply dragging the rows or columns to collapse or expand.
    [/_w/images/b/b0/HideRowCol.swf See Demo - Using Context Menu]
    [/_w/images/1/12/HideRowColByDragging.swf See Demo - Using Drag and Collapse/Expand]
  • Hide/Show Row/Column Headers
    Headers for rows and columns can be made visible/invisible
  • Modify Row/Column Headers
    [/_w/images/1/12/ModifyHeader.swf See Demo]
  • Hide/Show Grid Lines
    Users can make grid visible/invisible with a click of the check-box.
    [/_w/images/c/c5/GridLines.swf See Demo]
  • Set Maximum Rows and Columns Allowed
    The maximum number of rows and columns allowed for a ZK Spreadsheet component can be predefined.
    [/_w/images/0/04/MaxColRow.swf See Demo]
  • Set Column Width and Row Height
    Column width and row height are adjustable.
  • Set Worksheet Size
    ZK Spreadsheet is sizable just like other ZK components.

Cell Formatting and Styling

  • CSS Styling
    Cells can be styled using CSS definitions.
    [/_w/images/d/d4/FastIconToolbar.swf See Toolbar Demo]
    [/_w/images/b/b3/ChangeStyleByContextMenu.swf See Context-menu Demo]
  • Bullet List in Cells
    Content in cells can be shown in bullet form.
  • Number Formatting
    Numbers can be formatted to reflect their context such as date, currency, etc.
    [/_w/images/b/bf/NumberFormatting.swf See Demo]
  • Text Formatting
    Text formatting options include font, boldfaced, italic, among others. Any text format imported from an Excel worksheet would remain consistent in ZK Spreadsheet.
    [/_w/images/5/52/RichFormattedText.swf See Demo]
  • Input Mask for Date and Time
    Data and time values are converted to the appropriate format.
  • Text Overflow to Adjacent Cells
    Over-sized content in cells is automatically overflown to the right adjacent cell.
  • Text Wrapping
    Over-sized content can be wrapped in cells.
  • Selected Cells Highlighting
    Selected cells are masked with a shade.
    [/_w/images/8/8b/SelectionHighlight.swf See Demo]
  • Set Borders
    Borders of a cell can be made visible or invisible.
  • Text Alignment
    Text in cells can be made aligned to right, center, and left.
    [/_w/images/5/51/MenuFunction.swf See Menu Demo]

Charts and Images

  • Work with Interactive Excel Charts *
    Charts created in Excel can be imported to ZK Spreadsheet. Changes in the data are reflected on the charts instantly.
    Charts supported include: Bar, Bar3D, Line, Line3D, Pie, Pie3D, and Donut in 2003(xls) and 2007(xlsx) format.
    [/_w/images/2/2c/ColumnChart.swf See Demo]
  • Export Excel Charts to PDF *
    Export Excel charts to PDF
    [/_w/images/3/3f/ExportChartPDF.swf See Demo]
  • Insert/Import Images *
    Users can insert images into cells and images embedded in an Excel 2003 (xls) and 2007 (xlsx) worksheets can be rendered in ZK Spreadsheet when it is imported into ZK Spreadsheet.
    [/_w/images/0/00/LoadImage.swf See Demo]

Worksheet Utilities

  • Load on Demand
    Like other tabular components in ZK, ZK Spreadsheet supports “Load on Demand” which only the cells in view are loaded.
    [/_w/images/1/1a/LoadCellOnDemand.png See Illustration]
  • Efficient Formula Reference Dependency Tracking
    Advanced algorithm for formula evaluation and calculation.
  • POI Enhancements
    Performance tuning, bug fixing, feature enhancements, etc.

Built-in Functions

38 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 PPMT PRICE PRICEDISC PRICEMAT PV RECEIVED
SLN SYD TBILLEQ TBILLYIELD XNPV YIELD YIELDDISC YIELDMAT


60 Math Formula Functions *

ABS ACOS ACOSH ASIN ASINH ATAN ATAN2 ATANH CEILING COMBINACCRINT
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


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


7 Logical Formula Functions *

AND FALSE IF IFERROR NOT OR TRUE


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


21 Text Functions *

CHAR CODE CONCATENATE DOLLAR EXACT FIND, FINDB FIXED LEFT, LEFTB LEN, LENB LOWER
MID, MIDB PROPER REPLACE, REPLACEB REPT RIGHT, RIGHTB SEARCH, SEARCHB SUBSTITUTE T TEXT TRIM
UPPER


16 Info Functions *

ERROR.TYPE INFO ISBLANK ISERR ISERROR ISEVEN ISLOGICAL ISNA ISNONTEXT ISNUMBER
ISODD ISREF ISTEXT N NA TYPE


14 Date & Time Functions *

DATE DATEVALUE DAY DAYS360 HOUR MINUTE MONTH NOW SECOND TIME
TIMEVALUE TODAY WEEKDAY YEAR


ZK Spreadsheet App

  • Excel-like Web Application
    A stand-alone web based spreadsheet application that allows real-time online collaboration.
    Tap into the functionalities of ZK Spreadsheet with menus, context menus, dialogs, wizards, etc.
    Import/export Excel worksheets, Charts and PDF.


Reference

ZK Spreadsheet Essentials

ZK Spreadsheet Quick Start Guide

Integrate ZK Spreadsheet with Spring

Use JavaBean in Excel with ZK Spreadsheet

*ZK Spreadsheet have the standard and EE versions; for the feature comparison list, please click here


Comments



Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License.


Retrieved from "https://www.zkoss.org/_w/index.php?title=Small_Talks/2010/December/New_Features_of_ZK_Spreadsheet_2.0&oldid=17000"