SpreadJS 13
GC.Spread.Sheets Namespace / DataValidation type / createFormulaListValidator Method
The formula list.
In This Topic
    createFormulaListValidator Method
    In This Topic
    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