SetOffset
Sets the cell offset.
Syntax
expression.SetOffset(nRow, nCol);
expression - A variable that represents a ApiRange class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| nRow | Required | number | The row number. | |
| nCol | Required | number | The column number. |
Returns
boolean
Example
Shift a cell reference by a given number of rows and columns in a spreadsheet.
// How do I move a range reference to a different position in a spreadsheet?
// Target a new location relative to the original range without selecting it manually in a spreadsheet.
let worksheet = Api.GetActiveSheet();
worksheet.GetRange("B3").SetValue("Old Range");
let range = worksheet.GetRange("B3");
range.SetOffset(2, 2);
range.SetValue("New Range");