New Features of ZK Spreadsheet 2.1"
Tmillsclare (talk | contribs) m |
m (correct highlight (via JWB)) |
||
(22 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
{{Template:Smalltalk_Author| | {{Template:Smalltalk_Author| | ||
|author= The ZK Team | |author= The ZK Team | ||
− | |date=May | + | |date=May 31, 2011 |
|version=ZK Spreadsheet 2.1 | |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. | 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= | =AutoFilter functionality= | ||
Line 28: | Line 31: | ||
=Support copy and pasting to Excel= | =Support copy and pasting to Excel= | ||
+ | |||
+ | ZK Spreadsheet 2.1 introduces the ability to copy and paste values to and from ZK Spreadsheet to Excel. This provides users with a much better experience and level of co-operations between ZK Spreadsheet, its application and Microsoft Excel. | ||
=Export to HTML= | =Export to HTML= | ||
Line 33: | Line 38: | ||
Having implemented exporting to Excel and PDF in previous versions, ZK Spreadsheet now enables exporting to HTML. | Having implemented exporting to Excel and PDF in previous versions, ZK Spreadsheet now enables exporting to HTML. | ||
− | For more information | + | [[File:zss_export_html.png]] |
+ | |||
+ | For more information please take a look at the [[ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Export_to_Different_File_Format/Export_to_HTML | ZK Spreadsheet Essentials]]. | ||
=Vertical merge= | =Vertical merge= | ||
− | ZK Spreadsheet 2. | + | ZK Spreadsheet 2.1 now introduces the ability to merge cells vertically as well as horizontally. For example: |
− | <source lang="java" | + | <source lang="java" highlight="6"> |
public void onClick$mergeCells() { | public void onClick$mergeCells() { | ||
Ranges.range(spreadsheet.getSelectedSheet(), | Ranges.range(spreadsheet.getSelectedSheet(), | ||
Line 51: | Line 58: | ||
[[File:ZKSsEss_Spreadsheet_MergeCell_Merge.png]]<br/> | [[File:ZKSsEss_Spreadsheet_MergeCell_Merge.png]]<br/> | ||
− | For more information please take a look at [[ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Configure_and_Control_ZK_Spreadsheet/Merge_Cells_or_Split_Merged_Cells | | + | For more information please take a look at [[ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Configure_and_Control_ZK_Spreadsheet/Merge_Cells_or_Split_Merged_Cells | ZK Spreadsheet Essentials]]. |
+ | =Autofill= | ||
− | + | The AutoFill feature has been extended to now function with linear increasing, dates and numbers. Let's take a look at some examples: | |
==Auto linear increase== | ==Auto linear increase== | ||
+ | [[File:ZKSsEss_Spreadsheet_DragFill_AutoFill_Linear1.png]]<br/><br/> | ||
+ | [[File:ZKSsEss_Spreadsheet_DragFill_AutoFill_Linear3.png]]<br/><br/> | ||
==month/week auto increase== | ==month/week auto increase== | ||
− | + | Month <br/> | |
+ | [[File:ZKSsEss_Spreadsheet_DragFill_AutoFill_Month1.png]]<br/><br/> | ||
+ | [[File:ZKSsEss_Spreadsheet_DragFill_AutoFill_Month3.png]]<br/><br/> | ||
+ | Week <br/> | ||
+ | [[File:ZKSsEss_Spreadsheet_DragFill_AutoFill_Week1.png]]<br/><br/> | ||
+ | [[File:ZKSsEss_Spreadsheet_DragFill_AutoFill_Week3.png]]<br/><br/> | ||
==Date auto increase== | ==Date auto increase== | ||
+ | [[File:ZKSsEss_Spreadsheet_DragFill_AutoFill_Date1.png]]<br/><br/> | ||
+ | [[File:ZKSsEss_Spreadsheet_DragFill_AutoFill_Date3.png]]<br/><br/> | ||
+ | ==Number increments== | ||
+ | [[File:ZKSsEss_Spreadsheet_DragFill_AutoFill_Number1.png]]<br/><br/> | ||
+ | [[File:ZKSsEss_Spreadsheet_DragFill_AutoFill_Number3.png]]<br/><br/> | ||
− | + | For more information please refer to the [http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Configure_and_Control_ZK_Spreadsheet/Auto_Fill_-_Drag_Fill ZK Spreadsheet Essentials]. | |
=Support vertical alignment= | =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: | ||
+ | |||
+ | <source lang="java"> | ||
+ | CellStyle newStyle = cloneStyle(cell.getCellStyle(), book); | ||
+ | newStyle.setVerticalAlignment(alignment); | ||
+ | </source> | ||
+ | |||
+ | [[File:zss_vertical_alignment.png]] | ||
+ | |||
+ | 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= | =Protecting cell ranges= | ||
Line 73: | Line 103: | ||
[[File:ZKSsEss_Spreadsheet_Protected_LockedCell.png]] | [[File:ZKSsEss_Spreadsheet_Protected_LockedCell.png]] | ||
− | <source lang="java" | + | |
+ | <source lang="java" highlight="3,10,11"> | ||
CellStyle newCellStyle = cloneStyle(cellStyle, sheet.getBook()); | CellStyle newCellStyle = cloneStyle(cellStyle, sheet.getBook()); | ||
newCellStyle.setLocked(lock); | newCellStyle.setLocked(lock); | ||
</source> | </source> | ||
+ | |||
+ | 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]]. | ||
+ | |||
{{Template:CommentedSmalltalk_Footer| | {{Template:CommentedSmalltalk_Footer| | ||
|name=Potix Corporation | |name=Potix Corporation | ||
}} | }} |
Latest revision as of 04:18, 20 January 2022
The ZK Team
May 31, 2011
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.
Support copy and pasting to Excel
ZK Spreadsheet 2.1 introduces the ability to copy and paste values to and from ZK Spreadsheet to Excel. This provides users with a much better experience and level of co-operations between ZK Spreadsheet, its application and Microsoft Excel.
Export to HTML
Having implemented exporting to Excel and PDF in previous versions, ZK Spreadsheet now enables exporting to HTML.
For more information please take a look at the ZK Spreadsheet Essentials.
Vertical merge
ZK Spreadsheet 2.1 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 ZK Spreadsheet Essentials.
Autofill
The AutoFill feature has been extended to now function with linear increasing, dates and numbers. Let's take a look at some examples:
Auto linear increase
month/week auto increase
Date auto increase
Number increments
For more information please refer to the ZK Spreadsheet Essentials.
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.
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.
Comments
Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License. |