Interface IExcelDataValidationList¶

Namespace: OfficeOpenXml.DataValidation.Contracts
Assembly: EPPlus.dll

Interface for a data validation list

public interface IExcelDataValidationList : IExcelDataValidationWithFormula<IExcelDataValidationFormulaList>, IExcelDataValidation

Implements¶

IExcelDataValidation
IExcelDataValidationWithFormula<IExcelDataValidationFormulaList>

Properties¶

HideDropDown¶

True if an in-cell dropdown should be hidden.

bool? HideDropDown { get; set; }

Property Value¶

bool?

Remarks¶

This property corresponds to the showDropDown attribute of a data validation in Office Open Xml. Strangely enough this attributes hides the in-cell dropdown if it is true and shows the dropdown if it is not present or false. We have checked this in both Ms Excel and Google sheets and it seems like this is how it is implemented in both applications. Hence why we have renamed this property to HideDropDown since that better corresponds to the functionality.