SpreadJS Documentation
setFormula Method
GcSpread.Sheets Namespace > Sheet type : setFormula Method
The row index.
The column index.
The formula to place in the specified cell.
Sets a formula in a specified cell in the specified sheet area.
Syntax
var instance = new GcSpread.Sheets.Sheet(name);
var returnValue; // Type: any
returnValue = instance.setFormula(row, col, value);

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

Parameters

row
The row index.
col
The column index.
value
The formula to place in the specified cell.
Example
This example sets the formula for the specified cell.
activeSheet.setValue(0, 2, 3);
activeSheet.setFormula(1,1,"C1+D1",GcSpread.Sheets.SheetArea.viewport);
See Also

Reference

Sheet type

 

 

Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.