Spread.Sheets Documentation
setActiveCell Method
The row index of the cell.
The column index of the cell.
The row viewport index of the cell.
The column viewport index of the cell.
Sets the active cell for this sheet.
Syntax
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.
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);
  });
See Also

Reference

Worksheet type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.