Merge Cells or Split Merged Cells"
From Documentation
Line 47: | Line 47: | ||
} | } | ||
</source> | </source> | ||
+ | |||
+ | View complete source of ZUML [https://code.google.com/p/zkbooks/source/browse/trunk/zssessentials/examples/WebContent/config/mergeCells.zul mergeCells.zul] | ||
+ | |||
+ | View complete source of composer [https://code.google.com/p/zkbooks/source/browse/trunk/zssessentials/examples/src/org/zkoss/zssessentials/config/MergeCellComposer.java MergeCellComposer.java] | ||
=Version History= | =Version History= |
Revision as of 02:09, 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
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.