SpreadJS 13
GC.Spread.Sheets.DataValidation Namespace / DefaultDataValidator type / inCellDropdown Method
Indicates whether to display a drop-down button.
In This Topic
    inCellDropdown Method
    In This Topic
    Gets or sets whether to display a drop-down button.
    Syntax
    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.
    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);
    See Also