SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / setFormula Method
The row index.
The column index.
The formula to place in the specified cell.
In This Topic
    setFormula Method
    In This Topic
    Sets a formula in a specified cell in the specified sheet area.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var returnValue; // Type: any
    returnValue = instance.setFormula(row, col, value);
    function setFormula( 
       row : number,
       col : number,
       value : string
    ) : any;

    Parameters

    row
    The row index.
    col
    The column index.
    value
    The formula to place in the specified cell.
    Example
    This example sets the formula for the specified cell.
    activeSheet.setValue(0, 2, 3);
    activeSheet.setFormula(1,1,"C1+D1",GC.Spread.Sheets.SheetArea.viewport);
    See Also

    Reference

    Worksheet type