SpreadJS 13
SpreadJS Documentation / Sample Code / Sample Code for Rows and Columns / Setting the Top Row and Column
In This Topic
    Setting the Top Row and Column
    In This Topic

    You can specify the row and column at the top of the widget.

    Sheet with custom top row and column

    Using Code

    This example sets the top row and column.

    JavaScript
    Copy Code
    $("#button1").click(function ()
    {
        var activeSheet = spread.getActiveSheet();
        activeSheet.showRow(9, GC.Spread.Sheets.VerticalPosition.top);
    });
    
    $("#button2").click(function()
    {
        var activeSheet = spread.getActiveSheet();
        activeSheet.showColumn(9, GC.Spread.Sheets.HorizontalPosition.left);
    });