Validator 标签可以是:numberValidator, dateValidator, textLengthValidator, formulaValidator, formulaListValidator, 和 listValidator。
下表列出了 validator 的 validator 标签的属性。
属性 | API 参考 | 类型 |
errorMessage | DefaultDataValidator.errorMessage | string |
errorStyle | DefaultDataValidator.errorStyle | GC.Spread.Sheets.DataValidation.ErrorStyle |
errorTitle | DefaultDataValidator.errorTitle | string |
ignoreBlank | DefaultDataValidator.ignoreBlank | boolean |
inCellDropdown | DefaultDataValidator.inCellDropdown | Boolean |
inputMessage | DefaultDataValidator.inputMessage | string |
inputTitle | DefaultDataValidator.inputTitle | string |
showErrorMessage | DefaultDataValidator.showErrorMessage | Boolean |
showInputMessage | DefaultDataValidator.showInputMessage | Boolean |
numberValidator 没有子标签。但有如下属性:
属性 | API 参考 | 类型 |
comparisonOperator | DefaultDataValidator.createNumberValidator(comparisonOperator, value, value2, isIntegerValue) | GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators |
isIntegerValue | DefaultDataValidator.createNumberValidator(comparisonOperator, value, value2, isIntegerValue) | Boolean |
value1 | DefaultDataValidator.createNumberValidator(comparisonOperator, value, value2, isIntegerValue) | string |
value2 | DefaultDataValidator.createNumberValidator(comparisonOperator, value, value2, isIntegerValue) | string |
dateValidator 没有子标签。 但有如下属性:
属性 | API 参考 | 类型 |
comparisonOperator | DefaultDataValidator.createDateValidator(comparisonOperator, value, value2) | GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators |
value1 | DefaultDataValidator.createDateValidator(comparisonOperator, value, value2) | string |
value2 | DefaultDataValidator.createDateValidator(comparisonOperator, value, value2) | string |
The textLengthValidator element has no child elements. The following table lists the attributes of the textLengthValidator element.
textLengthValidator 标签没有子标签。但 textLengthValidator 的属性。
属性 | API 参考 | 类型 |
comparisonOperator | DefaultDataValidator.createTextLengthValidator(comparisonOperator, value, value2) | GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators |
value1 | DefaultDataValidator.createTextLengthValidator(comparisonOperator, value, value2) | string |
value2 | DefaultDataValidator.createTextLengthValidator(comparisonOperator, value, value2) | string |
formulaValidator 标签没有子标签,但有如下属性:
属性 | API 参考 | 类型 |
formula | DefaultDataValidator.createFormulaValidator(formula) | string |
formulaListValidator 标签没有子标签,但有如下属性:
属性 | API 参考 | 类型 |
formulalist | DefaultDataValidator.createFormulaListValidator(formulalist) | string |
listValidator 没有子标签,但有如下属性:
属性 | API 参考 | 类型 |
list | DefaultDataValidator.createListValidator(list) | string |