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
-
ExcelDataValidationList
- Implements
- Inherited Members
Properties
AllowsOperator
Read-Only property for seeing if this dataValidation type has an operator.
public override bool AllowsOperator { get; }Property Value
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
Methods
Validate()
Validate the validation
public override void Validate()