Following are the breaking changes for Data Validations.
These methods have been deprecated in v12. In the new API's set for v12, similar functions which use Reference instead of RangeReference have been exposed as RangeReference is intended to be used for calculation engine only.
- Add(RangeReference rangeRef, DataValidationType type, DataValidationErrorStyle errorStyle, DataValidationOperator @operator, string formula1, string formula2 = null)
- Add(RangeReference[] rangeRefs, DataValidationType type, DataValidationErrorStyle errorStyle, DataValidationOperator @operator, string formula1, string formula2 = null)