SpreadJS 13
GC.Spread.Sheets Namespace / CellRange type / formatter Method
The cell formatter string or object.
In This Topic
    formatter Method
    In This Topic
    Gets or sets the formatter for the cell.
    Syntax
    var instance = new GC.Spread.Sheets.CellRange(sheet, row, col, rowCount, colCount, sheetArea);
    var returnValue; // Type: any
    returnValue = instance.formatter(value);
    function formatter( 
       (optional) value : undefined
    ) : any;

    Parameters

    value
    The cell formatter string or object.

    Return Value

    If no value is set, returns the cell formatter string or object; otherwise, returns the cell.
    Example
    The following examples set the formatter method.
    activeSheet.getCell(1,1).formatter("0.000%");
    activeSheet.getCell(1, -1).formatter("0.000%");
    activeSheet.getCell(1,0).value("2");
    activeSheet.getCell(-1, 0).formatter("0.000%");
    activeSheet.getCell(0,0).value("2");
    See Also

    Reference

    CellRange type