SpreadJS 13
SpreadJS Documentation / Sample Code / Sample Code for Formulas / Allowing Users to Enter Formulas
In This Topic
    Allowing Users to Enter Formulas
    In This Topic

    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