ZK Spreadsheet NullPointerException when deleting a row!

asked 2012-06-07 20:06:40 +0800

isah
42 ● 1

Hi guys. I'm using the latest version of ZK and ZK Spreadsheet. I've a NullPointerException when deleting rows! It's getting me mad. Some rows get deleted some not and I can't figure a pattern! The row index is detected by:

public void onCellRightClick$spreadsheet(CellMouseEvent event) {
	rowIndex = event.getRow();
	colIndex = event.getColumn();
	currentSheet = event.getSheet();
	cellMenupopup.open(event.getPageX(), event.getPageY());
}

java.lang.NullPointerException
>> at org.zkoss.zss.model.impl.BookHelper.reevaluate(BookHelper.java:300)
>> at org.zkoss.zss.model.impl.BookHelper.reevaluateAndNotify(BookHelper.java:437)
>> at org.zkoss.zss.model.impl.RangeImpl.notifyMergeChange(RangeImpl.java:770)
>> at org.zkoss.zss.model.impl.RangeImpl.delete(RangeImpl.java:697)
>> at com.pespa.ctrl.TableProdIGatshemCtrl.onClick$deleteEntireRow(TableProdIGatshemCtrl.java:215)

The code where I delete 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); <-- Exception happening here
}