SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / getStyle Method
The row index.
The column index.
The sheet area. If this parameter is not provided, it defaults to viewport.
In This Topic
    getStyle Method
    In This Topic
    Gets the style information for a specified cell in the specified sheet area.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var value; // Type: Style
    value = instance.getStyle(row, column, sheetArea);
    function getStyle( 
       row : number,
       column : number,
       (optional) sheetArea : SheetArea
    ) : Style;

    Parameters

    row
    The row index.
    column
    The column index.
    sheetArea
    The sheet area. If this parameter is not provided, it defaults to viewport.

    Return Value

    Returns the cell style of the specified cell.
    Example
    This example uses the getStyle method.
    var style = new GC.Spread.Sheets.Style();
    style.backColor = "red";
    style.borderLeft =new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
    style.borderTop = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
    style.borderRight = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
    style.borderBottom = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
    activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
    var cstyle = activeSheet.getStyle(1,1,GC.Spread.Sheets.SheetArea.viewport, true);
    alert(cstyle.backColor);
    See Also

    Reference

    Worksheet type