showCell Method

Moves the view of a cell to the specified position in the viewport.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: any
value = instance.showCell(row, col, verticalPosition, horizontalPosition);

function showCell( 
   row : number,
   col : number,
   verticalPosition : VerticalPosition,
   horizontalPosition : HorizontalPosition
) : any;

Parameters

row: The row index.
col: The column index.
verticalPosition: The vertical position in which to display the cell.
horizontalPosition: The horizontal position in which to display the cell.

Example

This example uses the showCell method.

Javascript

//Set cell (3,3) as the active cell
activeSheet.setActiveCell(3, 3);
//Display the active cell at top left
activeSheet.showCell(3, 3, GcSpread.Sheets.VerticalPosition.top, GcSpread.Sheets.HorizontalPosition.left);

Reference

Sheet type