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

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.movePicture (Picture, ClientAnchor) to move the position of the specified picture from the sheet.

ZUML

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

Composer

ZK Spreadsheet use Worksheet.getPictures() to retrieve all pictures in the sheet.

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

View the complete source of ZUML movePicture.zul

View the complete source of composer MovePictureComposer.java

Version History

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

All source code listed in this book is at Github.