Class ExcelDataValidationList

This class represents an List data validation.

Inheritance
System.Object
ExcelDataValidation
ExcelDataValidationWithFormula<IExcelDataValidationFormulaList>
ExcelDataValidationList
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 ExcelDataValidationList : ExcelDataValidationWithFormula<IExcelDataValidationFormulaList>, IExcelDataValidationList, IExcelDataValidationWithFormula<IExcelDataValidationFormulaList>, IExcelDataValidation

Properties

AllowsOperator

Read-Only property for seeing if this dataValidation type has an operator.

Declaration
public override bool AllowsOperator { get; }
Property Value
Type Description
System.Boolean
Overrides

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.

ValidationType

Property for determining type of validation

Declaration
public override ExcelDataValidationType ValidationType { get; }
Property Value
Type Description
ExcelDataValidationType
Overrides

Methods

Validate()

Validate the validation

Declaration
public override void Validate()
Overrides
OfficeOpenXml.DataValidation.ExcelDataValidationWithFormula<OfficeOpenXml.DataValidation.Formulas.Contracts.IExcelDataValidationFormulaList>.Validate()

Implements