Enum ExcelDataValidationOperator¶

Namespace: OfficeOpenXml.DataValidation
Assembly: EPPlus.dll

Operator for comparison between Formula and Formula2 in a validation.

public enum ExcelDataValidationOperator

Fields¶

between = 0

The value of the validated cell should be between two values

equal = 2

The value of the validated cell should be eqal to a specific value

greaterThan = 6

The value of the validated cell should be greater than a specific value

greaterThanOrEqual = 7

The value of the validated cell should be greater than or equal to a specific value

lessThan = 4

The value of the validated cell should be less than a specific value

lessThanOrEqual = 5

The value of the validated cell should be less than or equal to a specific value

notBetween = 1

The value of the validated cell should not be between two specified values

notEqual = 3

The value of the validated cell should not be eqal to a specific value