setActiveCell Method

Sets the active cell for this sheet.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: any
value = instance.setActiveCell(row, col, rowViewportIndex, colViewportIndex);

function setActiveCell( 
   row : number,
   col : number,
   rowViewportIndex : number,
   colViewportIndex : number
) : any;

Parameters

row: The row index of the cell.
col: The column index of the cell.
rowViewportIndex: The row viewport index of the cell.
colViewportIndex: The column viewport index of the cell.

Example

This example sets the active cell.

Javascript

sheet.setActiveCell(5,5);
alert(sheet.getActiveColumnIndex());
alert(sheet.getActiveRowIndex());
spread.bind(GC.Spread.Sheets.Events.EnterCell, function (event, data) {
    alert(data.col);
    alert(data.row);
  });
spread.bind(GC.Spread.Sheets.Events.LeaveCell, function (event, data) {
    alert(data.col);
    alert(data.row);
  });

Reference

Worksheet type