inCellDropdown Method

Gets or sets whether to display a drop-down button.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(condition);
var returnValue; // Type: any
returnValue = instance.inCellDropdown(value);

function inCellDropdown( 
   value : boolean
) : any;

Parameters

value: Indicates whether to display a drop-down button.

Return Value

If no value is set, returns whether to display a drop-down button; otherwise, returns the data validator.

Example

This example sets the inCellDropdown property.

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");
dv.inCellDropdown(true);
activeSheet.setDataValidator(1,1,1,1,dv,GC.Spread.Sheets.SheetArea.viewport);
var validList = activeSheet.getDataValidator(1, 1).getValidList(activeSheet, 1, 1);
alert(validList);

Reference

DefaultDataValidator type