ZK Spreadsheet Essentials/Working with Spreadsheet/Handling Data Model/Cut, Copy, Paste

Overview

To copy a range of cells, you should use Ranges to select them and call paste(Range) with another Range object for destination like:

		Range src = Ranges.range(ss.getSelectedSheet(), ss.getSelection());
		Range destination = Ranges.range(getDestinationSheet(), ss.getSelection());
		src.paste(destination);

Similarly, the steps to cut a range is to copy them first, after pasting to destination, just clear the source range's content.

Cutting a range of cells is similar to copy:

		Range src = Ranges.range(ss.getSelectedSheet(), ss.getSelection());
		Range destination = Ranges.range(getDestinationSheet(), ss.getSelection());
		src.paste(destination, true);

There is also a pasteSpecial() to do special pasting like pasting value only or pasting formula only.

With the help of CellOperationUtil, we can easily perform copying and cutting, and it also provides methods for "paste special" such as pasteValue(), or pasteFormula(). These methods all require 2 Range objects as arguments. One is source and another is destination.

To cut a range of cells, you should use

CellOperationUtil.cut(srcRange, destRange);

To copy a range of cells, you should use

CellOperationUtil.paste(srcRange, destRange);

The usages for pasteFormula(), pasteValue(), pasteTranspose(), and pasteAllExceptBorder() are all the same.

Example

The following codes copy a selection range to the same position of another sheet when a user clicks a button.

public class CopyCutComposer extends SelectorComposer<Component> {

	@Wire
	private Spreadsheet ss;


	@Listen("onClick = #copyButton")
	public void copyByUtil() {
		Range src = Ranges.range(ss.getSelectedSheet(), ss.getSelection());
		Range dest = Ranges.range(getResultSheet(), ss.getSelection());
		CellOperationUtil.paste(src, dest);
	}
	
	//omitted codes...
}

All source code listed in this book is at Github.