SpreadJS 14
Features / Formulas / Built-In Formulas
In This Topic
    Built-In Formulas
    In This Topic

    You can use built-in formulas in cells. Use the formula method or setFormula method to add formulas. You can also specify the reference style with the referenceStyle property.

    Using Code

    This example sets the referenceStyle property in the Workbook method.

    JavaScript
    Copy Code
    spread.options.referenceStyle = GC.Spread.Sheets.ReferenceStyle.R1C1;
    //spread.options.referenceStyle = GC.Spread.Sheets.ReferenceStyle.A1;
    

    Using Code

    This example uses the formula method.

    JavaScript
    Copy Code
    activeSheet.setValue(0,0,1);
    activeSheet.setValue(0,1,2);
    activeSheet.setValue(0,2,10);
    activeSheet.getCell(1,1).formula("=SUM(A1:C1)");
    
    See Also