Delete Range

From Documentation

Stop.png This article is out of date, please refer to for more up to date information.


ZK Spreadsheet can use Range.delete(Integer) to delete range, rows or columns.


<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" />
	<spreadsheet id="spreadsheet" src="/demo_sample.xls"	


Open Menu

We can use onCellRightClick to get the current mouse position and open popup.

int rowIndex;
int colIndex;
Worksheet currentSheet;
Spreadsheet spreadsheet;
Menupopup cellMenupopup;
public void onCellRightClick$spreadsheet(CellMouseEvent event) {
	rowIndex = event.getRow();
	colIndex = event.getColumn();
	currentSheet = event.getSheet();, event.getPageY());

ZKSsEss Spreadsheet DeleteRange Menu.png

Shift Cells Left

public void onClick$shiftCellLeft() {
	Range rng = Ranges.range(currentSheet, rowIndex, colIndex);

ZKSsEss Spreadsheet DeleteRange ShiftLeft.png

Shift Cells Up

public void onClick$shiftCellUp() {
	final Range rng = Ranges.range(currentSheet, rowIndex, colIndex);

ZKSsEss Spreadsheet DeleteRange ShiftUp.png

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);

ZKSsEss Spreadsheet DeleteRange Row.png

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);

ZKSsEss Spreadsheet DeleteRange Column.png

Version History

Last Update : 2022/01/19

Version Date Content

All source code listed in this book is at Github.

Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License.