-
FEATURED COMPONENTS
First time here? Check out the FAQ!
Hi all,
I'm newbie to ZK.
I've tried to write some code from demo and create excel inside tab, but they're not reload perfectly. It seem spreadsheet not reload perfectly if inside zk tab, line number and ABC Column not appear until you resize it.
Please see screenshot below :
http://img121.imageshack.us/img121/3660/spreasheetproblem.jpg
I also attach my code :
<?page title="My Converter v1.0"?> <zk> <tabbox height="450px"> <tabs> <tab label="Upload" /> <tab label="Result" /> <tab label="Analyze" /> <tab label="Report" /> <tab label="Export" /> </tabs> <tabpanels> <tabpanel> <html> <![CDATA[<br/><br/> <center> <br/><br/> ]]></html> <vbox id="pics"/> <html> <![CDATA[ </center> ]]></html> </tabpanel> <!-- Result --> <tabpanel> <!-- code --> <window id="win" width="100%"> <hbox spacing="10px" style="margin:20px" width="100%"> <spreadsheet id="ss0" src="/upload/demo.xls" width="90%" height="400px" maxcolumns="40"/> <separator/> <spreadsheet id="ss1" src="/upload/demo.xls" width="90%" height="400px" maxcolumns="40"/> </hbox> <zscript> import org.zkoss.zss.ui.event.StopEditingEvent; import org.zkoss.zss.ui.event.CellEvent; import org.zkoss.zss.model.*; import org.zkoss.zss.model.impl.SheetImpl; import org.zkoss.zss.ui.Rect; import org.zkoss.zss.ui.Position; Spreadsheet[] ss=new Spreadsheet[2]; ss[0]=(Spreadsheet)win.getFellow("ss0"); ss[1]=(Spreadsheet)win.getFellow("ss1"); for(int i=0; i==0||i==1;i++){ ss<i >.addEventListener(org.zkoss.zss.ui.event.Events.ON_STOP_EDITING, new EventListener() { public void onEvent(Event event) throws Exception { onStopEditingEvent((StopEditingEvent) event); } }); ss<i >.addEventListener(org.zkoss.zss.ui.event.Events.ON_CELL_FOUCSED, new EventListener() { public void onEvent(Event event) throws Exception { onFocusedEvent((CellEvent) event); } }); } ss[1].setSelection(new Rect(2,2,2,2)); ss[1].setCellFocus(new Position(2,2)); public void onStopEditingEvent(StopEditingEvent event){ int row=event.getRow(); int col=event.getColumn(); Sheet targetSheet; if(event.getTarget()==ss[0]) targetSheet=ss[1].getSelectedSheet(); else targetSheet=ss[0].getSelectedSheet(); Cell tmpCell=targetSheet.getCell(row, col); if(tmpCell==null)//then new one tmpCell=((SheetImpl)targetSheet).getMatrix().getCellIndex(row, col).getCell(); tmpCell.setEditText((String)event.getEditingValue()); } public void onFocusedEvent(CellEvent event){ int row=event.getRow(); int col=event.getColumn(); Spreadsheet targetSpreadsheet; if(event.getTarget()==ss[0]) ss[1].moveEditorFocus("ss1", "red", row, col); else ss[0].moveEditorFocus("ss0", "green", row, col); } </zscript> </window> <!-- code --> </tabpanel> <!-- Analyze --> <tabpanel> </tabpanel> <!-- Report --> <tabpanel> </tabpanel> <!-- Export --> <tabpanel> </tabpanel> </tabpanels> </tabbox> </zk>
Thank you very much for Help...
Asked: 2010-02-14 06:43:26 +0800
Seen: 450 times
Last updated: Feb 28 '10