Merge Cells or Split Merged Cells"
From Documentation
| Line 24: | Line 24: | ||
===Composer=== | ===Composer=== | ||
| + | |||
| + | ====Range to merge or split=== | ||
| + | Use CellSelectionEvent to get current range. | ||
| + | <source lang="java" high="6"> | ||
| + | Spreadsheet spreadsheet; | ||
| + | int topRow; | ||
| + | int bottomRow; | ||
| + | int leftCol; | ||
| + | int rightCol; | ||
| + | |||
| + | public void onCellSelection$spreadsheet(CellSelectionEvent event) { | ||
| + | topRow = event.getTop(); | ||
| + | bottomRow = event.getBottom(); | ||
| + | leftCol = event.getLeft(); | ||
| + | rightCol = event.getRight(); | ||
| + | } | ||
| + | </source> | ||
| + | |||
====Merge Cells==== | ====Merge Cells==== | ||
Use <javadoc directory="zss" method="merge(java.lang.Boolean)">org.zkoss.zss.model.Range</javadoc>to merge cells. | Use <javadoc directory="zss" method="merge(java.lang.Boolean)">org.zkoss.zss.model.Range</javadoc>to merge cells. | ||
Revision as of 02:19, 23 May 2011
Purpose
ZK Spreadsheet support merge cells and split merged cells.
ZUML
<zk>
<div height="100%" width="100%" apply="org.zkoss.zssessentials.config.MergeCellComposer">
<div>
<button id="mergeCells" label="Merge Cells" mold="trendy"></button>
<button id="splitMergedCells" label="Split Merged Cells" mold="trendy"></button>
</div>
<spreadsheet id="spreadsheet" src="/WEB-INF/excel/config/merge.xlsx"
maxrows="200"
maxcolumns="40"
width="100%"
height="450px"></spreadsheet>
</div>
</zk>
Composer
=Range to merge or split
Use CellSelectionEvent to get current range.
Spreadsheet spreadsheet;
int topRow;
int bottomRow;
int leftCol;
int rightCol;
public void onCellSelection$spreadsheet(CellSelectionEvent event) {
topRow = event.getTop();
bottomRow = event.getBottom();
leftCol = event.getLeft();
rightCol = event.getRight();
}
Merge Cells
Use Range.merge(Boolean)to merge cells.
public void onClick$mergeCells() {
Ranges.range(spreadsheet.getSelectedSheet(),
topRow,
leftCol,
bottomRow,
rightCol).merge(false);
}
Split Merged Cells
public void onClick$splitMergedCells() {
Ranges.range(spreadsheet.getSelectedSheet(),
topRow,
leftCol,
bottomRow,
rightCol).unMerge();
}
View complete source of ZUML mergeCells.zul
View complete source of composer MergeCellComposer.java
Version History
| Version | Date | Content |
|---|---|---|
All source code listed in this book is at Github.