setDataValidator Method

Sets the cell data validator.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Worksheet(name);
var returnValue; // Type: any
returnValue = instance.setDataValidator(row, col, rowCount, colCount, value, sheetArea);

function setDataValidator( 
   row : number,
   col : number,
   rowCount : number,
   colCount : number,
   value : DefaultDataValidator,
   sheetArea : SheetArea
) : any;

Parameters

row: The row index.
col: The column index.
rowCount: The row count.
colCount: The column count.
value: The data validator.
sheetArea: The sheet area. If this parameter is not provided, it defaults to viewport.

Example

Javascript

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));

Reference

Worksheet type