Move Chart"

From Documentation
(1st Draft)
 
m (correct highlight (via JWB))
 
(3 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
{{ZKSpreadsheetEssentialsPageHeader}}
 
{{ZKSpreadsheetEssentialsPageHeader}}
 +
 +
{{Deprecated|url=http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials}}
 +
 +
 
{{ZSS EE}}
 
{{ZSS EE}}
 
 
__TOC__
 
__TOC__
  
Line 8: Line 11:
  
 
===ZUML===
 
===ZUML===
<source lang="xml" high="6">
+
<source lang="xml" highlight="6">
 
<window vflex="1" width="100%"  
 
<window vflex="1" width="100%"  
 
apply="org.zkoss.zssessentials.config.MoveChartComposer">
 
apply="org.zkoss.zssessentials.config.MoveChartComposer">
Line 14: Line 17:
 
         maxcolumns="40" vflex="1" width="100%">
 
         maxcolumns="40" vflex="1" width="100%">
 
     </spreadsheet>
 
     </spreadsheet>
     <button id="delete" label="Move All Charts"/>
+
     <button id="move" label="Move All Charts"/>
 
</window>
 
</window>
 
</source>
 
</source>
Line 20: Line 23:
 
===Composer===
 
===Composer===
 
ZK Spreadsheet use <javadoc directory="zss" method="getCharts()">org.zkoss.zss.model.Worksheet</javadoc> to retrieve all charts in the sheet.
 
ZK Spreadsheet use <javadoc directory="zss" method="getCharts()">org.zkoss.zss.model.Worksheet</javadoc> to retrieve all charts in the sheet.
<source lang="java" high="7">
+
<source lang="java" highlight="7">
 
private Spreadsheet myss;
 
private Spreadsheet myss;
 
 

Latest revision as of 12:55, 19 January 2022


Stop.png This article is out of date, please refer to http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials for more up to date information.


Available in ZK Spreadsheet EE only

Purpose

ZK Spreadsheet uses Range.moveChart (Chart, ClientAnchor) to move the position of the specified chart from the sheet.

ZUML

<window vflex="1" width="100%" 
	apply="org.zkoss.zssessentials.config.MoveChartComposer">
    <spreadsheet id="myss" src="/WEB-INF/excel/config/MoveChart.xlsx" maxrows="200"
        maxcolumns="40" vflex="1" width="100%">
    </spreadsheet>
    <button id="move" label="Move All Charts"/>
</window>

Composer

ZK Spreadsheet use Worksheet.getCharts() to retrieve all charts in the sheet.

	private Spreadsheet myss;
	
	public void onClick$move(MouseEvent evt) throws Exception {
		//move chart
		Worksheet sheet = myss.getSelectedSheet();
		Range rng = Ranges.range(sheet);
		for(Chart chart : sheet.getCharts()) { //move charts down two rows
			ClientAnchor anchor = chart.getPreferredSize();
			anchor.setRow1(anchor.getRow1()+2);
			anchor.setRow2(anchor.getRow2()+2);
			rng.moveChart(chart, anchor);
		}
	}

View the complete source of ZUML moveChart.zul

View the complete source of composer MoveChartComposer.java

Version History

Last Update : 2022/01/19


Version Date Content
2.2.0 Nov. 11, 2011 API to move a chart
     


All source code listed in this book is at Github.


Last Update : 2022/01/19

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