ZK Spreadsheet

answered 2009-02-02 06:45:36 +0800

kindalu
255

Currently, there is no such api.
And it sounds pretty reasonable to have it, not hard to implement also.
Please post it to feature request.
(http://sourceforge.net/projects/zss/)

answered 2009-02-04 09:01:41 +0800

kindalu
255

updated 2009-02-04 09:05:25 +0800

btw, you may want to try this
int rowSize = ((SheetImpl)sheet).getMaxRowIndex();
int colSize = ((SheetImpl)sheet).getMaxColumnIndex();
this will give you the last cell been edited or with value

answered 2009-02-11 03:33:44 +0800

kindalu
255

updated 2009-02-11 03:43:10 +0800

sorry for that wrong information...
That function will be release for next version.
(I'm using it now and it was implemented by another man, so I thought it was released in previous version)

The reason of invaildate() won't work here is we check the filename and selected sheet name.
If they're both unchanged, it will not reload data.

One way to do the db update is keeping a boolean field like "isModified" in database.
So you could select the modified data from db and update current spreadsheet when tab is clicked.

Another way you have to add a function in the spreadsheet.java like this function

	public void setBookFromStream(InputStream is, String src){
		_selectedSheet=null;
		_selectedSheetId=null;
		setRowfreeze(-1);
		setColumnfreeze(-1);
		_importer = new ExcelImporter();
		_src=src;
		_book = ((ExcelImporter)_importer).importFromStream(is, src);
		_book.addSSDataListener(_dataListener);
		_book.addVariableResolver(_variableResolver);
		_book.addFunctionMapper(_functionMapper);
	}

spreadsheet.setBookFromStream(iStream, src);
spreadsheet.setSelectedSheet(sheetTB.getSelectedTab().getLabel());