formula Field

Indicates the formula string for the cell.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.FormulaInformation(name);
var value; // Type: string
value = instance.formula;

var formula : string;

Example

This example gets the 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.formula);

Reference

FormulaInformation type

Send comments on this topic.