Enumeration TwoConstraintDataValidationOperator

Represents the various operators which can be used when validating the cell value against two constraints.

See

  • [[TwoConstraintDataValidationRule]]
  • [[TwoConstraintDataValidationRule.setLowerConstraint]]
  • [[TwoConstraintDataValidationRule.setLowerConstraint]]
  • [[TwoConstraintDataValidationRule.setUpperConstraint]]
  • [[TwoConstraintDataValidationRule.setUpperConstraint]]
  • [[TwoConstraintDataValidationRule.getLowerConstraintFormula]]
  • [[TwoConstraintDataValidationRule.getLowerConstraintFormula]]
  • [[TwoConstraintDataValidationRule.setLowerConstraintFormula]]
  • [[TwoConstraintDataValidationRule.setLowerConstraintFormula]]
  • [[TwoConstraintDataValidationRule.getUpperConstraintFormula]]
  • [[TwoConstraintDataValidationRule.getUpperConstraintFormula]]
  • [[TwoConstraintDataValidationRule.setUpperConstraintFormula]]
  • [[TwoConstraintDataValidationRule.setUpperConstraintFormula]]
  • [[ValueConstraintDataValidationRule.validationCriteria]]

Enumeration Members

Enumeration Members

Between: 0

Only allows the cell value if it or its text length, depending on the validation criteria, is between the constraints applied to the validation rule. The constraints are inclusive.

NotBetween: 1

Only allows the cell value if it or its text length, depending on the validation criteria, is not between the constraints applied to the validation rule. The constraints are exclusive.