Move Chart"

From Documentation
Line 1: Line 1:
 
{{ZKSpreadsheetEssentialsPageHeader}}
 
{{ZKSpreadsheetEssentialsPageHeader}}
 +
 +
{{Deprecated|url=http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials}}
 +
 +
 
{{ZSS EE}}
 
{{ZSS EE}}
 
__TOC__
 
__TOC__

Revision as of 06:40, 22 August 2013


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 : 2013/08/22


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 : 2013/08/22

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