Spread.Sheets Documentation
getDataValidator Method
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.
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