setFormula Method

Sets a formula in a specified cell in the specified sheet area.

Syntax

var instance = new GC.Spread.Sheets.Worksheet(name);
var returnValue; // Type: any
returnValue = instance.setFormula(row, col, value);

function setFormula( 
   row : number,
   col : number,
   value : string
) : any;

Example

This example sets the formula for the specified cell.

activeSheet.setValue(0, 2, 3);
activeSheet.setFormula(1,1,"C1+D1",GC.Spread.Sheets.SheetArea.viewport);