Sheetbar"

From Documentation
m
m
Line 72: Line 72:
  
 
See the full source code for Composer [https://code.google.com/p/zkbooks/source/browse/trunk/zssessentials/examples/src/org/zkoss/zssessentials/config/SheetbarComposer.java here]
 
See the full source code for Composer [https://code.google.com/p/zkbooks/source/browse/trunk/zssessentials/examples/src/org/zkoss/zssessentials/config/SheetbarComposer.java here]
 
  
 
=Version History=
 
=Version History=

Revision as of 04:44, 5 April 2012

WarningTriangle-32x32.png This page is under construction, so we cannot guarantee the accuracy of the content!



Purpose

ZK Spreadsheet provide sheetbar for user to perform sheet actions, such as select sheet, add sheet, delete sheet etc...

Show Sheetbar

Use Spreadsheet.setShowSheetbar to show sheetbar.

ZKSsEss Spreadsheet Sheetbar.png

Add Sheet

Click the button to add sheet
ZKSsEss Spreadsheet Sheetbar addSheetButton.png

The new sheet name prefix use Sheet, developer could change it by use I18N key zss.sheet
ZKSsEss Spreadsheet Sheetbar addedSheet.png

I18N

Each button/menuitem map to a key, developer could browser all I18 keys by Action.getLabelKeys

Here is partial keys for sheetbar

Action I18 Key
Sheet zss.sheet
Add Sheet zss.addSheet
Delete Sheet zss.deleteSheet
Rename Sheet zss.renameSheet
Move Sheet Left zss.moveSheetLeft
Move Sheet Right zss.moveSheetRight
Protect Sheet zss.protectSheet

Refer to sample i3-label.properties

ZUML

Here is a sample example ZUL file

<zk>
	<window vflex="1" width="100%" apply="org.zkoss.zssessentials.config.SheetbarComposer">
		<button id="toggleSheetbar" label="Toggle sheetbar"/>
		<spreadsheet showSheetbar="true"
			id="spreadsheet" vflex="true" width="100%"
			src="/WEB-INF/excel/config/ZSS-demo_sample.xlsx" maxcolumns="40" maxrows="200"
			></spreadsheet>
	</window>
</zk>

View complete source of ZUML sheetbar.zul

Composer

The composer use Spreadsheet.setShowContextMenu to show or hide context menu.

	public void onClick$toggleSheetbar() {
		boolean toggle = !spreadsheet.isShowSheetbar();
		spreadsheet.setShowSheetbar(toggle);
	}

See the full source code for Composer here

Version History

Last Update : 2012/04/05


Version Date Content
2.3.0 April, 2012 Sheetbar
     


All source code listed in this book is at Github.


Last Update : 2012/04/05

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