moveTo Method

Moves data from one range to another.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: any
value = instance.moveTo(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount, option);

function moveTo( 
   fromRow : number,
   fromColumn : number,
   toRow : number,
   toColumn : number,
   rowCount : number,
   columnCount : number,
   option : CopyToOption
) : any;

Parameters

fromRow: The source row.
fromColumn: The source column.
toRow: The target row.
toColumn: The target column.
rowCount: The row count.
columnCount: The column count.
option: The copy option.

Example

This example moves the data to the specified location.

Javascript

activeSheet.getCell(0,0).value("A1");
activeSheet.getCell(1,1).value("Test")
activeSheet.moveTo(0,0,3,3,2,2,GcSpread.Sheets.CopyToOption.Value);

Reference

Sheet type