SpreadJS Documentation
Setting the Active Cell at a Specific Location
SpreadJS Documentation > Sample Code > Sample Code for Cells > Setting the Active Cell at a Specific Location

You can specify the location of the active cell.

Using Code

This example sets the location of the active cell.

JavaScript
Copy Code
$("#button1").click(function () {
    var sheet = spread.getActiveSheet();

    //Set cell (3,3) to active
    sheet.setActiveCell(3, 3);

    //Display the active cell on top left
    sheet.showCell(3, 3, GcSpread.Sheets.VerticalPosition.top, GcSpread.Sheets.HorizontalPosition.left);
});

 

 

Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.