GrapeCity.Documents.Excel.IValidation.InCellDropdown

InCellDropdown Property

InCellDropdown

Gets or sets whether data validation displays a drop-down list that contains acceptable values.

Use this property to determine whether the validation rule shows an in-cell list for selecting allowed values. This setting is typically used with list validation.

Declaration

bool InCellDropdown { get; set; }

Property InCellDropdown As Boolean

Examples

worksheet.Range["A1"].Value = "Open";
worksheet.Range["A2"].Value = "Closed";
IValidation validation = worksheet.Range["C1"].Validation;
validation.Add(ValidationType.List, ValidationAlertStyle.Stop, ValidationOperator.Between, "=$A$1:$A$2", null);
bool inCellDropdown = validation.InCellDropdown;