createListValidator Method

Creates a validator based on a list.

Syntax

Javascript (Usage)
Javascript (Specification)

var value; // Type: DefaultDataValidator
value = GcSpread.Sheets.DefaultDataValidator.createListValidator(source);

function createListValidator( 
   source : string
) : DefaultDataValidator;

Parameters

source: The list value.

Return Value

The validator.

Example

Javascript

spread.highlightInvalidData(true);
var dv = GcSpread.Sheets.DefaultDataValidator.createListValidator("1,2,3");
dv.showInputMessage = true;
dv.inputMessage = "Value must be 1, 2 or 3.";
dv.inputTitle = "tip";
activeSheet.setDataValidator(1, 1, dv); 
var validList = activeSheet.getDataValidator(1, 1).getValidList(sheet, 1, 1);

Reference

DefaultDataValidator type

Send comments on this topic.