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 GcSpread.Sheets.Spread(document.getElementById("spreadContainer"),{sheetCount:3}); var activeSheet = spread.getActiveSheet(); //Allow users to enter mathematical formula. spread.canUserEditFormula(true); activeSheet.setValue(0, 0, 1000); activeSheet.setValue(1, 0, 200);

JavaScript

Copy Code

window.onload = function () {
var spread = new GcSpread.Sheets.Spread(document.getElementById("spreadContainer"),{sheetCount:3});
var activeSheet = spread.getActiveSheet();
//Allow users to enter mathematical formula.
spread.canUserEditFormula(true);

activeSheet.setValue(0, 0, 1000);
activeSheet.setValue(1, 0, 200);

Developer's Guide

Using Formulas

Formula Reference

Send comments on this topic.