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

    Parameters

    row
    The row index.
    col
    The column index.
    value
    The formatter string or object.
    sheetArea
    The sheet area. If this parameter is not provided, it defaults to viewport.
    Example
    This example sets the format object for the active sheet.
    activeSheet.setValue(2, 3, new Date(2011, 2, 9));
    activeSheet.setFormatter(2,3,"M",GC.Spread.Sheets.SheetArea.viewport);
    See Also

    Reference

    Worksheet type