dataValidator Method

Gets or sets the data validator for the column.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Column(sheet, index, sheetArea);
var returnValue; // Type: DefaultDataValidator
returnValue = instance.dataValidator(value);

function dataValidator( 
   value : DefaultDataValidator
) : DefaultDataValidator;

Parameters

value: The column data validator.

Return Value

The column data validator.

Example

This example uses the dataValidator method.

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.getColumn(0).dataValidator(dv);

Reference

Column type

Send comments on this topic.