Sheetbar"
From Documentation
m |
m |
||
Line 47: | Line 47: | ||
===ZUML=== | ===ZUML=== | ||
Here is a sample example ZUL file | Here is a sample example ZUL file | ||
+ | |||
+ | <source lang="xml" high="4"> | ||
+ | <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> | ||
+ | </source> | ||
View complete source of ZUML [https://code.google.com/p/zkbooks/source/browse/trunk/zssessentials/examples/WebContent/config/sheetbar.zul sheetbar.zul] | View complete source of ZUML [https://code.google.com/p/zkbooks/source/browse/trunk/zssessentials/examples/WebContent/config/sheetbar.zul sheetbar.zul] | ||
+ | |||
+ | ===Composer=== | ||
+ | The composer use <javadoc directory="zss" method="setShowContextMenu">org.zkoss.zss.ui.Spreadsheet</javadoc> to show or hide context menu. | ||
+ | <source lang="java" high="3"> | ||
+ | public void onClick$toggleSheetbar() { | ||
+ | boolean toggle = !spreadsheet.isShowSheetbar(); | ||
+ | spreadsheet.setShowSheetbar(toggle); | ||
+ | } | ||
+ | </source> | ||
+ | |||
+ | 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:43, 5 April 2012
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.
Add Sheet
The new sheet name prefix use Sheet, developer could change it by use I18N key zss.sheet
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
Version | Date | Content |
---|---|---|
2.3.0 | April, 2012 | Sheetbar |
All source code listed in this book is at Github.