Class ExcelDataValidationExtList

Represents a data validation mapped to the extLst element in the worksheet xml.

Inheritance
System.Object
XmlHelper
ExcelDataValidation
ExcelDataValidationWithFormula<IExcelDataValidationFormulaList>
ExcelDataValidationExtList
Implements
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.DataValidation
Assembly: EPPlus.dll
Syntax
public class ExcelDataValidationExtList : ExcelDataValidationWithFormula<IExcelDataValidationFormulaList>, IExcelDataValidationList, IExcelDataValidationWithFormula<IExcelDataValidationFormulaList>, IExcelDataValidation

Properties

HideDropDown

True if an in-cell dropdown should be hidden.

Declaration
public 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.

Implements