Class ExcelDataValidationList¶

Namespace: OfficeOpenXml.DataValidation
Assembly: EPPlus.dll

This class represents an List data validation.

public class ExcelDataValidationList : ExcelDataValidationWithFormula<IExcelDataValidationFormulaList>, IExcelDataValidationList, IExcelDataValidationWithFormula<IExcelDataValidationFormulaList>, IExcelDataValidation

Inheritance¶

object ← ExcelDataValidation ← ExcelDataValidationWithFormula<IExcelDataValidationFormulaList> ← ExcelDataValidationList

Implements¶

IExcelDataValidation
IExcelDataValidationList
IExcelDataValidationWithFormula<IExcelDataValidationFormulaList>

Inherited Members¶

Properties¶

AllowsOperator¶

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

public override bool AllowsOperator { get; }

Property Value¶

bool

HideDropDown¶

True if an in-cell dropdown should be hidden.

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

ValidationType¶

Property for determining type of validation

public override ExcelDataValidationType ValidationType { get; }

Property Value¶

ExcelDataValidationType

Methods¶

Validate()¶

Validate the validation

public override void Validate()