New Features of ZK Spreadsheet 3.0.0 RC"

From Documentation
m
(10 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
{{Template:Smalltalk_Author|
 
{{Template:Smalltalk_Author|
 
|author= Hawk Chen
 
|author= Hawk Chen
|date=August 20, 2013
+
|date=August 22, 2013
 
|version=ZK Spreadsheet 3.0.0 RC
 
|version=ZK Spreadsheet 3.0.0 RC
 
}}
 
}}
Line 7: Line 7:
  
 
=Overview =
 
=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.
+
ZK Spreadsheet is an AJAX component that delivers Excel-like experience to your browser. Version 3.0.0 RC contains several new features and many bug fixes.
  
 +
= New Features =
  
= New Features =
+
== Simpler API ==
 +
We have polished up those APIs under <tt>org.zkoss.zss.api</tt> and <tt>org.zkoss.zss.api.model</tt> to help users work with Spreadsheet better. For example, <tt>SheetOperationUtil</tt> and <tt>CellOperationUtil</tt> to help you perform some common user actions like picture insertion or changing style in a simpler way. Numerous other model classes such as <tt>Book</tt>, <tt>Sheet</tt>, <tt>CellData</tt>, <tt>CellStyle</tt>, <tt>Color</tt>, <tt>Hyperlink</tt>, and <tt>Font</tt> will also help you extract information from cells more easily than ever.
 +
 
 +
== Undo / Redo ==
 +
The undo/redo of common cell operations 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==
 
== Freeze Rows and Columns by Sheet==
Now each sheet can have its own freeze settings, so different sheet may freeze different part.
+
Now each sheet can have its own freeze settings, so different sheet may freeze at different parts/sections. Freeze settings are now stored in Spreadsheet's book model, too.
  
 
[[File:release-freeze1.png | center]]
 
[[File:release-freeze1.png | center]]
<div style='text-align:center'>'''Freeze 2 rows in sheet1'''</div>
+
<div style='text-align:center'>'''Freeze 2 rows in Sheet1'''</div>
  
[[File:release-freeze2.png | center]]
 
<div style='text-align:center'>'''Freeze A column in sheet2'''</div>
 
  
  
== Richer API ==
+
[[File:release-freeze2.png | center]]
We have created richer API under <tt>org.zkoss.zss.api</tt> and <tt>org.zkoss.zss.api.model</tt>. For example, <tt>SheetOperationUtil</tt> and <tt>CellOperationUtil</tt> help you perform some common user actions like picture insertion or changing style more easier. Besides, plentiful model classes such as <tt>Book</tt>, <tt>Sheet</tt>, <tt>CellData</tt>, <tt>CellStyle</tt>, <tt>Color</tt>, <tt>Hyperlink</tt>, and <tt>Font</tt> also help you extract information from cell easily.
+
<div style='text-align:center'>'''Freeze A column in Sheet2'''</div>
  
 
== Show User Names in Collaboration Edit ==
 
== 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.
+
When we share a Spreadsheet's book model to enable collaboration edit, each user can see other users' current selection box which are painted with different colours. Besides, the user name of each Spreadsheet will also show up beside the selection box when any cell is focused.
  
 
The screenshot below is what the current user sees another user's (John) current selection (purple box).
 
The screenshot below is what the current user sees another user's (John) current selection (purple box).
 
[[File:release-coedit.png | center]]
 
[[File:release-coedit.png | center]]
 
 
== 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).
 
  
  

Revision as of 10:05, 22 August 2013

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

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


Overview

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

New Features

Simpler API

We have polished up those APIs under org.zkoss.zss.api and org.zkoss.zss.api.model to help users work with Spreadsheet better. For example, SheetOperationUtil and CellOperationUtil to help you perform some common user actions like picture insertion or changing style in a simpler way. Numerous other model classes such as Book, Sheet, CellData, CellStyle, Color, Hyperlink, and Font will also help you extract information from cells more easily than ever.

Undo / Redo

The undo/redo of common cell operations 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 at different parts/sections. Freeze settings are now stored in Spreadsheet's book model, too.

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 a Spreadsheet's book model to enable collaboration edit, each user can see other users' current selection box which are painted with different colours. Besides, the user name of each Spreadsheet will also show up beside the selection box when any cell is 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.