ZK Spreadsheet Essentials/Working with ZK Spreadsheet/Configure and Control ZK Spreadsheet/Move Chart

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

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

All source code listed in this book is at Github.