SpreadJS Documentation
Allowing Users to Enter Formulas
SpreadJS Documentation > Sample Code > Sample Code for Formulas > Allowing Users to Enter Formulas

You can allow users to enter formulas in cells.

Using Code

This example allows users to enter formulas.

JavaScript
Copy Code

window.onload = function(){
         var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
         var sheet = spread.getActiveSheet();
//Allow users to enter mathematical formula.
spread.options.allowUserEditFormula = true;
activeSheet.setValue(0, 0, 1000);
activeSheet.setValue(1, 0, 200);

See Also

Developer's Guide

Formula Reference