Merge Cells or Split Merged Cells"
From Documentation
| Line 4: | Line 4: | ||
===Purpose=== | ===Purpose=== | ||
| − | ZK Spreadsheet support merge cells and | + | ZK Spreadsheet support merge cells and split merged cells. |
===ZUML=== | ===ZUML=== | ||
| + | <source lang="xml" high="4,5"> | ||
| + | <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> | ||
| + | </source> | ||
===Composer=== | ===Composer=== | ||
| − | + | ====Merge Cells=== | |
| + | Use Range.merge | ||
| + | <source lang="xml" high="4,5"> | ||
| + | public void onClick$mergeCells() { | ||
| + | Ranges.range(spreadsheet.getSelectedSheet(), | ||
| + | topRow, | ||
| + | leftCol, | ||
| + | bottomRow, | ||
| + | rightCol).merge(false); | ||
| + | } | ||
| + | </source> | ||
| + | ====Split Merged Cells==== | ||
| + | <source lang="xml" high="4,5"> | ||
| + | public void onClick$splitMergedCells() { | ||
| + | Ranges.range(spreadsheet.getSelectedSheet(), | ||
| + | topRow, | ||
| + | leftCol, | ||
| + | bottomRow, | ||
| + | rightCol).unMerge(); | ||
| + | } | ||
| + | </source> | ||
=Version History= | =Version History= | ||
Revision as of 02:02, 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
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();
}
Version History
| Version | Date | Content |
|---|---|---|
All source code listed in this book is at Github.