New Features of ZK Spreadsheet 3.0.0 RC

From Documentation
DocumentationSmall Talks2013AugustNew Features of ZK Spreadsheet 3.0.0 RC
New Features of ZK Spreadsheet 3.0.0 RC

Author
Hawk Chen
Date
August 20, 2013
Version
ZK Spreadsheet 3.0.0 RC


Overview

ZK Spreadsheet is an AJAX component that delivers Excel-like experience to your browser. The version 3.0.0 RC contains several new features and many bug fixes.


New Features

Richer API

We have created richer API under org.zkoss.zss.api and org.zkoss.zss.api.model. For example, SheetOperationUtil and CellOperationUtil help you perform some common user actions like picture insertion or changing style more easier. Besides, plentiful model classes such as Book, Sheet, CellData, CellStyle, Color, Hyperlink, and Font also help you extract information from cell easily.


Undo / Redo

The undp/redo of common cell operation are now supported, including editing text, changing style, copy, paste, and rows (columns) insertion and deletion. You can easily use them with hotkey Ctrl+z (undo) and Ctrl+y (redo).


Freeze Rows and Columns by Sheet

Now each sheet can have its own freeze settings, so different sheet may freeze different part.

Release-freeze1.png
Freeze 2 rows in sheet1
Release-freeze2.png
Freeze A column in sheet2


Show User Names in Collaboration Edit

When we share Spreadsheet's book model to achieve collaboration edit, each user can see others' current selection box which are painted with different colors. Besides, the user name of each Spreadsheet will also show up aside the selection box when any cell get focused.

The screenshot below is what the current user sees another user's (John) current selection (purple box).

Release-coedit.png



Comments



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