Spread.Sheets Documentation
createFormulaValidator Method
GC.Spread.Sheets Namespace > DataValidation type : createFormulaValidator Method
The formula condition.
Creates a validator based on a formula.
Syntax
var value; // Type: DefaultDataValidator
value = GC.Spread.Sheets.DataValidation.createFormulaValidator(formula);
function createFormulaValidator( 
   formula : string
) : DefaultDataValidator;

Parameters

formula
The formula condition.

Return Value

The validator.
Example
This example creates a formula validator.
spread.options.highlightInvalidData = true;
//The formula validator is valid if the formula condition returns true.
var dv = GC.Spread.Sheets.DataValidation.createFormulaValidator("A1>0");
dv.showInputMessage(true);
dv.inputMessage("Enter a value greater than 0 in A1.");
dv.inputTitle("Tip");
activeSheet.setDataValidator(0, 0, 1, 1, dv, GC.Spread.Sheets.SheetArea.viewport);
See Also

Reference

DataValidation type