SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / getViewportLeftColumn Method
The index of the viewport.
In This Topic
    getViewportLeftColumn Method
    In This Topic
    Gets the index of the left column in the viewport.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var value; // Type: number
    value = instance.getViewportLeftColumn(columnViewportIndex);
    function getViewportLeftColumn( 
       columnViewportIndex : number
    ) : number;

    Parameters

    columnViewportIndex
    The index of the viewport.

    Return Value

    The index of the left column in the viewport.
    Example
    This example uses the getViewportLeftColumn method.
    $("#button1").click(function () {  
        //Acquire top row (column) index
        var topRow = activeSheet.getViewportTopRow(1);
        var leftCol = activeSheet.getViewportLeftColumn(1);
        alert("Index of top row being displayed: " + topRow + "\n" +
            "Index of first column being displayed: " + leftCol);
    });
    
    //Add button control to page
    <input type="button" id="button1" value="button1"/>
    This example returns the indices for the bottom and top rows and left and right columns in the current sheet view.
    var brow = activeSheet.getViewportBottomRow(1);
    var lcol = activeSheet.getViewportLeftColumn(1);
    var rcol = activeSheet.getViewportRightColumn(1);
    var trow = activeSheet.getViewportTopRow(1);
    alert(brow);
    alert(lcol);
    alert(rcol);
    alert(trow);
    See Also

    Reference

    Worksheet type