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

Parameters

source
The list value.

Return Value

The validator.
Example
spread.options.highlightInvalidData = true;
var dv = GC.Spread.Sheets.DataValidation.createListValidator("1,2,3");
dv.showInputMessage(true);
dv.inputMessage("Value must be 1,2 or 3");
dv.inputTitle("tip");
activeSheet.setDataValidator(1,1,1,1,dv,GC.Spread.Sheets.SheetArea.viewport);
alert(activeSheet.getDataValidator(1,1).getValidList(activeSheet,1,1));
See Also

Reference

DataValidation type