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

Parameters

formula
The formula list.

Return Value

The validator.
Example
This example creates a formula list validator.
activeSheet.setValue(0, 2, 5);
activeSheet.setValue(1, 2, 4);
activeSheet.setValue(2, 2, 5);

spread.options.highlightInvalidData = true;
var dv = GC.Spread.Sheets.DataValidation.createFormulaListValidator("$C$1:$C$3");
dv.showInputMessage(true);
dv.inputMessage("Pick a value from the list.");
dv.inputTitle("tip");
activeSheet.setDataValidator(1, 1, 1, 1, dv, GC.Spread.Sheets.SheetArea.viewport);
var validList = activeSheet.getDataValidator(1, 1).getValidList(activeSheet, 1, 1);
alert(validList);
See Also

Reference

DataValidation type