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. |