Class $.wijmo.wijspread.DefaultDataValidator
| Constructor Attributes | Constructor Name and Description |
|---|---|
|
$.wijmo.wijspread.DefaultDataValidator(condition)
Constructs a data validator.
|
| Method Attributes | Method Name and Description |
|---|---|
| <static> |
$.wijmo.wijspread.DefaultDataValidator.createDateValidator(typeOperator, v1, v2, isTime)
Creates a validator based on the data.
|
| <static> |
$.wijmo.wijspread.DefaultDataValidator.createFormulaListValidator(formula)
Creates a validator based on a formula list.
|
| <static> |
$.wijmo.wijspread.DefaultDataValidator.createFormulaValidator(formula)
Creates a validator based on a formula.
|
| <static> |
$.wijmo.wijspread.DefaultDataValidator.createListValidator(source)
Creates a validator based on a list.
|
| <static> |
$.wijmo.wijspread.DefaultDataValidator.createNumberValidator(typeOperator, v1, v2, isIntegerValue)
Creates a validator based on numbers.
|
| <static> |
$.wijmo.wijspread.DefaultDataValidator.createTextLengthValidator(typeOperator, v1, v2)
Creates a validator based on text length.
|
|
IgnoreBlank(Whether)
Gets or sets whether to ignore an empty value.
|
|
|
isValid(evaluator, baseRow, baseColumn, actual)
Determines whether the current value is valid.
|
|
|
reset()
Resets the data validator.
|
|
|
value1()
Gets the first value of the data validation.
|
|
|
value2()
Gets the second value of the data validation.
|
Class Detail
$.wijmo.wijspread.DefaultDataValidator(condition)
Constructs a data validator.
- Parameters:
- condition
- The condition.
Method Detail
<static>
$.wijmo.wijspread.DefaultDataValidator.createDateValidator(typeOperator, v1, v2, isTime)
Creates a validator based on the data.
- Parameters:
- {$.wijmo.wijspread.ComparisonOperator} typeOperator
- The type of ComparisonOperator compare operator.
- {object} v1
- The first object.
- {object} v2
- The second object.
- {boolean} isTime
- Set to true if the validator is set to time.
<static>
$.wijmo.wijspread.DefaultDataValidator.createFormulaListValidator(formula)
Creates a validator based on a formula list.
- Parameters:
- {string} formula
- The formula list.
<static>
$.wijmo.wijspread.DefaultDataValidator.createFormulaValidator(formula)
Creates a validator based on a formula.
- Parameters:
- {string} formula
- The formula condition.
<static>
$.wijmo.wijspread.DefaultDataValidator.createListValidator(source)
Creates a validator based on a list.
- Parameters:
- {string} source
- The list value.
<static>
$.wijmo.wijspread.DefaultDataValidator.createNumberValidator(typeOperator, v1, v2, isIntegerValue)
Creates a validator based on numbers.
- Parameters:
- {$.wijmo.wijspread.ComparisonOperator} typeOperator
- The type of ComparisonOperator compare operator.
- {object} v1
- The first object.
- {object} v2
- The second object.
- {boolean} isIntegerValue
- Set to true if the validator is set to a number.
<static>
$.wijmo.wijspread.DefaultDataValidator.createTextLengthValidator(typeOperator, v1, v2)
Creates a validator based on text length.
- Parameters:
- {$.wijmo.wijspread.ComparisonOperator} typeOperator
- The type of ComparisonOperator compare operator.
- {object} v1
- The first object.
- {object} v2
- The second object.
IgnoreBlank(Whether)
Gets or sets whether to ignore an empty value.
- Parameters:
- {boolean} Whether
- to ignore the empty value.
- Returns:
- true if the data validator ignores the empty value; otherwise, false.
isValid(evaluator, baseRow, baseColumn, actual)
Determines whether the current value is valid.
- Parameters:
- {object} evaluator
- The evaluator.
- {number} baseRow
- The base row.
- {number} baseColumn
- The base column.
- {object} actual
- The current value.
- Returns:
- true if the value is valid; otherwise, false.
reset()
Resets the data validator.
value1()
Gets the first value of the data validation.
- Returns:
- The first value.
value2()
Gets the second value of the data validation.
- Returns:
- The second value.