Spread.Sheets Documentation
getFormula Method
The row index.
The column index.
Gets the formula in the specified cell in this sheet.
Syntax
var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: string
value = instance.getFormula(row, col);
function getFormula( 
   row : number,
   col : number
) : string;

Parameters

row
The row index.
col
The column index.

Return Value

Returns the formula string.
Example
This example returns the formula in the specified cell.
activeSheet.setValue(0,0,1);
activeSheet.setValue(0,1,2);
activeSheet.setValue(0,2,10);
activeSheet.getCell(1,1).formula("=SUM(A1:C1)");
var formula = activeSheet.getFormula(1,1);
alert(formula);
See Also

Reference

Worksheet type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.