Interface IExcelDataValidationList

Interface for a data validation list

Inherited Members
Namespace: OfficeOpenXml.DataValidation.Contracts
Assembly: EPPlus.dll
Syntax
public interface IExcelDataValidationList : IExcelDataValidationWithFormula<IExcelDataValidationFormulaList>, IExcelDataValidation

Properties

HideDropDown

True if an in-cell dropdown should be hidden.

Declaration
bool? HideDropDown { get; set; }
Property Value
Type Description
System.Nullable<System.Boolean>
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.