Platforms to show: All Mac Windows Linux Cross-Platform

XLDataValidationValuesMBS class   New in 26.3

Type Topic Plugin Version macOS Windows Linux iOS Targets
class XL MBS XL Plugin 26.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The class for information on a data validation setting.
Example 
Var b As New XLBookMBS(True)
Var s As XLSheetMBS = b.AddSheet("test")

Var type As Integer = s.ValidationTypeDecimal
var op as integer = s.ValidationOpBetween

// add a validation
s.AddDataValidation type, op, 1, 2, 3, 4, "1", "3", True

// and check it again
var c as integer = s.DataValidationSize
Var d As XLDataValidationValuesMBS = s.DataValidation(0)

Break

Constants

Constant Value Description
ValidationOpLessthan 4 ConstantsGroup: Validation Operations Example
ValidationOpLessthanorequal 5 ConstantsGroup: Validation Operations Example

Data Validation Error Styles

Constant Value Description
ValidationErrstyleInformation 2 This data validation error style uses an information icon in the error alert.
ValidationErrstyleStop 0 This data validation error style uses a stop icon in the error alert.
ValidationErrstyleWarning 1 This data validation error style uses a warning icon in the error alert.

Validation Operations

Constant Value Description
ValidationOpBetween 0 Data validation which checks if a value is between two other values.
ValidationOpEqual 2 Data validation which checks if a value is equal to a specified value.
ValidationOpGreaterthan 6 Data validation which checks if a value is greater than a specified value.
ValidationOpGreaterthanorequal 7 Data validation which checks if a value is greater than or equal to a specified value.
ValidationOpNotbetween 1 Data validation which checks if a value is not between two other values.
ValidationOpNotequal 3 Data validation which checks if a value is not equal to a specified value.

Data Validation Types

Constant Value Description
ValidationTypeCustom 7 Data validation which uses a custom formula to check the cell value.
ValidationTypeDate 4 Data validation which checks for date values satisfying the given condition.
ValidationTypeDecimal 2 Data validation which checks for decimal values satisfying the given condition.
ValidationTypeList 3 Data validation which checks for a value matching one of list of values.
ValidationTypeNone 0 No data validation.
ValidationTypeTextlength 6 Data validation which checks for text values, whose length satisfies the given condition.
ValidationTypeTime 5 Data validation which checks for time values satisfying the given condition.
ValidationTypeWhole 1 Data validation which checks for whole number values satisfying the given condition.

This class has no sub classes.

Release notes

  • Version 26.3
    • Added XLDataValidationValuesMBS class.

Some methods using this class:

Some related classes:


The items on this page are in the following plugins: MBS XL Plugin.


XLCorePropertiesMBS   -   XLFilterColumnMBS


The biggest plugin in space...