SpreadJS 13
SpreadJS Documentation / Developer's Guide / Features / Manage User Interface / Formulas / Allow Users to Enter Formulas
In This Topic
    Allow Users to Enter Formulas
    In This Topic

    Users can enter a formula in a cell by starting with an equals sign (=). Type the equal sign and then the formula such as = sum(A1+B1). You can allow or prevent the user from entering formulas with the options.allowUserEditFormula property.

    Using Code

    This example sets the options.allowUserEditFormula property.

    JavaScript
    Copy Code
    spread.options.allowUserEditFormula = true;