New Features of ZK Spreadsheet 2.1

From Documentation
DocumentationSmall Talks2011MayNew Features of ZK Spreadsheet 2.1
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

ZKSsEss Spreadsheet FilterData Clear AutoFilter.png

Applied

ZKSsEss Spreadsheet FilterData Reapply.png

Cleared

ZKSsEss Spreadsheet FilterData ClearFilter.png


For more information please refer to the ZK Spreadsheet Essentials.


Support copy and pasting to Excel

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);
}

ZKSsEss Spreadsheet MergeCell Merge.png

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.


Autofill

Auto linear increase

month/week auto increase

Date auto increase

Number increments

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.

ZKSsEss Spreadsheet Protected LockedCell.png


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.