Delete Range"
From Documentation
m (→Purpose) |
|||
| Line 27: | Line 27: | ||
===Composer=== | ===Composer=== | ||
| − | ====Open | + | ====Open Menu==== |
We can use onCellRightClick to get the current mouse position and open popup. | We can use onCellRightClick to get the current mouse position and open popup. | ||
<source lang="java" high="7,8,9,10"> | <source lang="java" high="7,8,9,10"> | ||
| Line 45: | Line 45: | ||
[[File:ZKSsEss_Spreadsheet_DeleteRange_Menu.png]] | [[File:ZKSsEss_Spreadsheet_DeleteRange_Menu.png]] | ||
| − | ====Shift | + | ====Shift Cells Left==== |
<source lang="java" high="3"> | <source lang="java" high="3"> | ||
public void onClick$shiftCellLeft() { | public void onClick$shiftCellLeft() { | ||
| Line 55: | Line 55: | ||
[[File:ZKSsEss_Spreadsheet_DeleteRange_ShiftLeft.png]] | [[File:ZKSsEss_Spreadsheet_DeleteRange_ShiftLeft.png]] | ||
| − | ====Shift | + | ====Shift Cells Up==== |
<source lang="java" high="3"> | <source lang="java" high="3"> | ||
public void onClick$shiftCellUp() { | public void onClick$shiftCellUp() { | ||
| Line 65: | Line 65: | ||
[[File:ZKSsEss_Spreadsheet_DeleteRange_ShiftUp.png]] | [[File:ZKSsEss_Spreadsheet_DeleteRange_ShiftUp.png]] | ||
| − | ====Delete | + | ====Delete Entire Row==== |
<source lang="java" high="5"> | <source lang="java" high="5"> | ||
public void onClick$deleteEntireRow() { | public void onClick$deleteEntireRow() { | ||
| Line 77: | Line 77: | ||
[[File:ZKSsEss_Spreadsheet_DeleteRange_Row.png]] | [[File:ZKSsEss_Spreadsheet_DeleteRange_Row.png]] | ||
| − | ====Delete | + | ====Delete Entire Column==== |
<source lang="java" high="4"> | <source lang="java" high="4"> | ||
public void onClick$deleteEntireColumn() { | public void onClick$deleteEntireColumn() { | ||
Revision as of 04:57, 2 December 2010
Purpose
ZK Spreadsheet can use Range.delete Range.delete(Integer) to delete cell, row or column.
ZUML
<zk>
<div height="100%" width="100%" apply="demo.DeleteRangeComposer">
<div height="3px"></div>
<menupopup id="cellMenupopup">
<menuitem id="shiftCellLeft" label="Shift cells left"></menuitem>
<menuitem id="shiftCellUp" label="Shift cells up"/>
<menuitem id="deleteEntireRow" label="Entire row" />
<menuitem id="deleteEntireColumn" label="Entire column" />
</menupopup>
<spreadsheet id="spreadsheet" src="/demo_sample.xls"
maxrows="200"
maxcolumns="40"
width="100%"
height="450px"></spreadsheet>
</div>
</zk>
Composer
Open Menu
We can use onCellRightClick to get the current mouse position and open popup.
int rowIndex;
int colIndex;
Sheet currentSheet;
Spreadsheet spreadsheet;
Menupopup cellMenupopup;
public void onCellRightClick$spreadsheet(CellMouseEvent event) {
rowIndex = event.getRow();
colIndex = event.getColumn();
currentSheet = event.getSheet();
cellMenupopup.open(event.getPageX(), event.getPageY());
}
Shift Cells Left
public void onClick$shiftCellLeft() {
Range rng = Ranges.range(currentSheet, rowIndex, colIndex);
rng.delete(Range.SHIFT_LEFT);
}
Shift Cells Up
public void onClick$shiftCellUp() {
final Range rng = Ranges.range(currentSheet, rowIndex, colIndex);
rng.delete(Range.SHIFT_UP);
}
Delete Entire Row
public void onClick$deleteEntireRow() {
Row row = currentSheet.getRow(rowIndex);
int lCol = row.getFirstCellNum();
int rCol = row.getLastCellNum();
Ranges.range(currentSheet, rowIndex, lCol, rowIndex, rCol).delete(Range.SHIFT_UP);
}
Delete Entire Column
public void onClick$deleteEntireColumn() {
int tRow = currentSheet.getFirstRowNum();
int bRow = currentSheet.getPhysicalNumberOfRows();
Ranges.range(currentSheet, tRow, colIndex, bRow, colIndex).delete(Range.SHIFT_LEFT);
}
Version History
| Version | Date | Content |
|---|---|---|
All source code listed in this book is at Github.