Move Chart

From Documentation
Revision as of 09:33, 11 November 2011 by Henrichen (talk | contribs) (1st Draft)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)


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="delete" 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 : 2011/11/11


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 : 2011/11/11

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