getFormulaInformation Method

Gets the formula in the specified cell in this sheet.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: FormulaInformation
value = instance.getFormulaInformation(row, col);

function getFormulaInformation( 
   row : number,
   col : number
) : FormulaInformation;

Parameters

row: The row index.
col: The column index.

Return Value

Returns the formula information about the cell.

Example

This example uses the getFormulaInformation method.This example uses the getFormulaInfomation method.

Javascript

activeSheet.setValue(0,0,1);
activeSheet.setValue(0,1,2);
activeSheet.setValue(0,2,10);
activeSheet.getCell(1,1).formula("=SUM(A1:C1)");
var test = activeSheet.getFormulaInformation(1,1, GcSpread.Sheets.SheetArea.viewport);
alert(test.formula);

Javascript

activeSheet.setValue(0, 2, 3);
activeSheet.setFormula(1,1,"C1+D1",GcSpread.Sheets.SheetArea.viewport);
var information = activeSheet.getFormulaInfomation(1, 1);
alert(information.hasFormula);

Reference

Sheet type