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; |
|
See Also
Workbook Method