New Features of ZK Spreadsheet 2.2

From Documentation
DocumentationSmall Talks2012JanuaryNew Features of ZK Spreadsheet 2.2
New Features of ZK Spreadsheet 2.2

Sam Chuang
Jan 10, 2012
ZK Spreadsheet 2.2


ZK Spreadsheet is an Ajax component that delivers functionalities of Microsoft Excel to your browsers. ZK Spreadsheet 2.2 brings with it a host of new features including validation functionality, supporting more chart types, adding/deleting/moving/sizing charts and pictures, collaboration editing, locale-aware date/number input and output and also performance enhancement.

Collaboration editing

Collaboration editing is one of the most important features added to this release allowing a group of individuals to edit the spreadsheet file at the same time like that of Google's online spreadsheet. Prior to this release, users were able to edit but if another user is also editing at the same time, they will be competing to save as the latest version , however, users are now offered the ability to edit, add or delete the content at will and observe other users' edits in real time.

ZKSsEss Spreadsheet Coedit.png

To add this new feature to your web application, please refer to ZK Spreadsheet Essentials - ZK Spreadsheet/Collaboration Edit

Validation functionality

Data validation helps users in editing and verifying cell values to ensure data accuracy and consistency. It also allows you to do the following:

  • Prompt message: Create a prompt message that explains the data type of the cell

  • ZKSsEss Spreadsheet Validation Prompt.png

  • Validation list: Make a list of the entries that restricts the values allowed in a cell

  • ZKSsEss Spreadsheet Validation List1.png

    ZKSsEss Spreadsheet Validation List2.png

  • Incorrect message: Pop-up an incorrect message dialog when incorrect data has been entered

  • ZKSsEss Spreadsheet Validation IncorrectMessage1.png
    ZKSsEss Spreadsheet Validation IncorrectMessage2.png

To add this feature to your web application, please refer to ZK Spreadsheet Essentials - Data Validation

Chart/Picture Operation

Users are now also offered the ability to orientate charts and pictures more freely, you can now add, delete, move and even re-size chart and pictures at will just like operating on a desktop spreadsheet application.

To Add a Chart

To add a chart to your spreadsheet file, follow the steps below;

  • select desired data
  • ZKSsEss Spreadsheet Chart Adding1.png

  • select chart type
  • ZKSsEss Spreadsheet Chart Adding2.png

  • chart added
  • ZKSsEss Spreadsheet Chart Adding3.png

To Add a Picture

  • focus on a cell and click upload button
  • ZKSsEss Spreadsheet Picture Adding1.png

  • picture uploaded
  • ZKSsEss Spreadsheet Picture Adding2.png

To Delete a Chart

  • focus on a chart
  • ZKSsEss Spreadsheet Chart Deleting1.png

  • press delete key
  • ZKSsEss Spreadsheet Chart Deleting2.png

To Move a Chart

  • simply drag the chart that you want to move and drop it to the desired destination
  • ZKSsEss Spreadsheet Chart Moving2.png

To Resize a Chart

  • simply focus on the chart and resize it
  • ZKSsEss Spreadsheet Chart Sizing1.png

New Chart Types

ZK Spreadsheet 2.2 introduces us a variety of new chart types, improving end user experience offering more choices of presentation for their data including;

  • Area chart
  • ZKSsEss Spreadsheet Chart Area.png

  • Bar chart
  • ZKSsEss Spreadsheet Chart Bar.png
    Bar chart in 3D

  • Scatter chart
  • ZKSsEss Spreadsheet Chart Scatter.png

Locale-aware date/number input & output

This function supports different date formats for different locations by simply setting the default language saving users the time and effort to manually format the date & number each time.

  • firstly, set your preferred language in your browser
  • Locale setting.png

  • locale-aware will then be automatically enabled
  • Locale01.png

  • drag down
  • Locale02.png

  • result
  • Locale03.png

Performance enhancement

As performance is a very important aspect in enterprise level applications, enhancing performance is always one of our most critical tasks. In ZSS 2.2, we have gone through a mechanism adjustment where previously, data must be retrieved from the server-side but now, part of the cache is saved on the client-side thus optimizing the scrolling of a page. Moreover, we have also fine tuned the code to optimize page loading by 1.4 times compared to that of ZK Spreadsheet 2.1.1


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