SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / getFormatter Method
The row index.
The column index.
The sheet area. If this parameter is not provided, it defaults to viewport.
In This Topic
    getFormatter Method
    In This Topic
    Gets the cell formatter.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var value; // Type: any
    value = instance.getFormatter(row, col, sheetArea);
    function getFormatter( 
       row : number,
       col : number,
       sheetArea : SheetArea
    ) : any;

    Parameters

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

    Return Value

    Returns the cell formatter string or object for the specified cell.
    Example
    This example returns the format object for the active sheet.
    activeSheet.getCell(0, 1).formatter("M");
    activeSheet.setValue(0, 1, new Date(2011, 2, 9));
    var style = activeSheet.getFormatter(0,1,GC.Spread.Sheets.SheetArea.viewport);
    alert(style);
    See Also

    Reference

    Worksheet type