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