SpreadJS Documentation > Developer's Guide > Managing the User Interface > Using Formulas > Allowing Users to Enter Formulas |
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 canUserEditFormula method.
This example sets the canUserEditFormula method.
JavaScript |
Copy Code
|
---|---|
spread.canUserEditFormula(true); |