var instance = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(condition);
function DefaultDataValidator;
var instance = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(condition);
function DefaultDataValidator;
//This example validates the cell data. spread.options.highlightInvalidData = true; var dv = new GC.Spread.Sheets.DataValidation.createTextLengthValidator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.greaterThan, 5); activeSheet.setDataValidator(0, 0, 1, 1, dv, GC.Spread.Sheets.SheetArea.viewport); activeSheet.setValue(0, 0, "abcf");
Object
GC.Spread.Sheets.DataValidation.DefaultDataValidator
Name | Description | |
---|---|---|
DefaultDataValidator Constructor | Represents a data validator. |
Name | Description | |
---|---|---|
comparisonOperator | Gets or sets the comparison operator. | |
condition | Gets or sets the condition to validate. | |
errorMessage | Gets or sets the error message. | |
errorStyle | Gets or sets the error style to display. | |
errorTitle | Gets or sets the error title. | |
getValidList | Returns the valid data lists if the Data validation type is list; otherwise, returns null. | |
ignoreBlank | Gets or sets whether to ignore an empty value. | |
inCellDropdown | Gets or sets whether to display a drop-down button. | |
inputMessage | Gets or sets the input message. | |
inputTitle | Gets or sets the input title. | |
isValid | Determines whether the current value is valid. | |
reset | Resets the data validator. | |
showErrorMessage | Gets or sets whether to display an error message. | |
showInputMessage | Gets or sets whether to display the input title and input message. | |
type | Gets or sets the criteria type of this data validator. | |
value1 | Gets the first value of the data validation. | |
value2 | Gets the second value of the data validation. |