SpreadJS 14
GC.Spread.Sheets Namespace / DataValidation type / createListValidator Method
The list value.
In This Topic
    createListValidator Method
    In This Topic
    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