Hide Row and Column Titles"

From Documentation
m (Created page with '{{ZKSpreadsheetEssentialsPageHeader}} __TOC__ ZK Spreadsheet can hide row or column use Range.setHidden() ==Scenario== User can select row or column and right click on header …')
 
Line 10: Line 10:
 
===ZUML Example===
 
===ZUML Example===
  
<source lang="xml" high="4,7">
+
<source lang="xml" high="4,5,8">
 
<zk>
 
<zk>
 
<div height="100%" width="100%" apply="demo.HideHeaderComposer">
 
<div height="100%" width="100%" apply="demo.HideHeaderComposer">
Line 37: Line 37:
 
}
 
}
 
</source>
 
</source>
 
 
  
 
=Version History=
 
=Version History=

Revision as of 06:55, 18 November 2010


ZK Spreadsheet can hide row or column use Range.setHidden()

Scenario

User can select row or column and right click on header to open menu popup, select hide to hide selected range.

ZUML Example

<zk>
<div height="100%" width="100%" apply="demo.HideHeaderComposer">
	<menupopup id="headerMenupopup">
		<menuitem id="show" label="Show"/>
		<menuitem id="hide" label="Hide"/>
	</menupopup>
	<div height="3px"></div>
	<spreadsheet id="spreadsheet" src="/demo_sample.xls"	
			maxrows="200" 
			maxcolumns="40"
			width="100%"
			height="450px"></spreadsheet>
</div>
</zk>

Current range

We can get user's selection range from onCellSelection event

Range currentRange;
public void onCellSelection$spreadsheet(CellSelectionEvent event) {
	currentRange = Ranges.range(event.getSheet(), event.getTop(), event.getLeft(), 
			event.getBottom(), event.getRight());
}

Version History

Last Update : 2010/11/18


Version Date Content
     


All source code listed in this book is at Github.


Last Update : 2010/11/18

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