SpreadJS 15
Features / Formulas / Allow Users to Enter Formulas
In This Topic
    Allow Users to Enter Formulas
    In This Topic

    Users can enter a formula in a cell by starting with an equals sign (=) or a plus sign (+). Type the preferred sign and then the formula such as =sum(A1+B1) or +sum(A1+B1). You can allow or prevent the user from entering formulas with the options.allowUserEditFormula property.

    The plus sign (+) functions the same as the equal sign (=) and Excel users who are accustomed to using the plus sign don't have to change their behavior when using SpreadJS. The equal sign is still automatically added before, so that formulas are converted to work as expected. For example, if you enter "+SUM(1,2)" when editing, it will be "=+SUM(1,2)" when displayed again.

    Users should be aware of the following behavior when using the plus sign (+) for entering formulas:

    Note: The minus (-) sign has the same behavior as the plus (+) sign.

    Using Code

    This example allows users to enter formulas.

    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);