formula Field

Indicates the formula that specifies a cell.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.CellValueCondition(compareType, expected, formula);
var value; // Type: string
value = instance.formula;

var formula : string;

Example

This example creates a cell value condition.

Javascript

var nCondition = new GcSpread.Sheets.CellValueCondition();
nCondition.compareType = GcSpread.Sheets.GeneralCompareType.GreaterThan;
nCondition.formula = "$C$1";
var validator = new GcSpread.Sheets.DefaultDataValidator(nCondition)
activeSheet.getCell(0, 0, GcSpread.Sheets.SheetArea.viewport).dataValidator(validator);
spread.highlightInvalidData(true);
activeSheet.setValue(0, 0, 5);
activeSheet.setValue(0, 2, 4);

Reference

CellValueCondition type

Send comments on this topic.