New Features of ZK Spreadsheet 2.1

Author
The ZK Team

Date
May 31, 2011

Version
ZK Spreadsheet 2.1

ZK Spreadsheet is an Ajax component that delivers functionalities found in Microsoft Excel to your browsers. ZK Spreadsheet 2.1 bring with it a host of new features including auto filter functionality, vertical merging, support for copying and pasting to Excel and exporting to HTML.

AutoFilter functionality

In both the ZK Spreadsheet app and ZK Spreadsheet is is now possible to AutoFilter a range of values from a particular column. Filters can be applied, re-applied and cleared. The UI clearly displays when a filter is cleared, applied or cleared. For example:

Auto filter off

Applied

Cleared

For more information please refer to the ZK Spreadsheet Essentials.

Export to HTML

Having implemented exporting to Excel and PDF in previous versions, ZK Spreadsheet now enables exporting to HTML.

For more information on exporting to HTML please take a look at .

Vertical merge

ZK Spreadsheet 2.0 now introduces the ability to merge cells vertically as well as horizontally. For example:

public void onClick$mergeCells() {
	Ranges.range(spreadsheet.getSelectedSheet(), 
			topRow, 
			leftCol, 
			bottomRow, 
			rightCol).merge(false);
}

For more information please take a look at http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Configure_and_Control_ZK_Spreadsheet/Merge_Cells_or_Split_Merged_Cells.

Support vertical alignment

The vertical alignment of text can be set to top, middle or bottom using a new API introduced in ZK Spreadsheet 2.1. The code to do so is as follows:

CellStyle newStyle = cloneStyle(cell.getCellStyle(), book);
newStyle.setVerticalAlignment(alignment);

For more information please refer to the ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Configure_and_Control_ZK_Spreadsheet/Change_Cell's_Style_and_Text_Format#VerticalAlignment_alignment ZK Spreadsheet Essentials.

Protecting cell ranges

Cells can now be locked to prevent editing. The following example demonstrates how to lock a cell.

CellStyle newCellStyle = cloneStyle(cellStyle, sheet.getBook());
newCellStyle.setLocked(lock);

For more information please see the [ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Configure and Control ZK Spreadsheet/Protect_Worksheet_or_Workbook_Elements | ZK Spreadsheet Essentials].

Comments

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