SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / getDataValidator Method
The row index.
The column index.
The sheet area. If this parameter is not provided, it defaults to viewport.
In This Topic
    getDataValidator Method
    In This Topic
    Gets the cell data validator.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var value; // Type: DefaultDataValidator
    value = instance.getDataValidator(row, col, sheetArea);
    function getDataValidator( 
       row : number,
       col : number,
       sheetArea : SheetArea
    ) : DefaultDataValidator;

    Parameters

    row
    The row index.
    col
    The column index.
    sheetArea
    The sheet area. If this parameter is not provided, it defaults to viewport.

    Return Value

    Returns the cell data validator for the specified cell.
    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

    Worksheet type