Spread.Sheets Documentation
setFormula Method
GC.Spread.Sheets Namespace > Worksheet 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 GC.Spread.Sheets.Worksheet(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",GC.Spread.Sheets.SheetArea.viewport);
See Also

Reference

Worksheet type

 

 

Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.