0

Spreadsheet Error if inside Tab

asked 2010-02-14 06:43:26 +0800

zuki gravatar image zuki
79 1 1 6

updated 2010-02-14 06:44:31 +0800

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...

delete flag offensive retag edit

1 Reply

Sort by ยป oldest newest

answered 2010-02-28 22:22:17 +0800

zuki gravatar image zuki
79 1 1 6

Hello,

any solution for this spreadsheet problem ?

is there any render/refresh function for spreadsheet ?

link publish delete flag offensive edit
Your reply
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Question tools

Follow

RSS

Stats

Asked: 2010-02-14 06:43:26 +0800

Seen: 450 times

Last updated: Feb 28 '10

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More