SpreadJS Documentation
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.

Using Code

This example sets the canUserEditFormula method.

JavaScript
Copy Code
spread.canUserEditFormula(true);

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.