Page tree
Skip to end of metadata
Go to start of metadata

Validator 标签可以是:numberValidator, dateValidator, textLengthValidator, formulaValidator, formulaListValidator, 和 listValidator。

下表列出了 validator 的 validator 标签的属性。

属性API 参考类型
errorMessageDefaultDataValidator.errorMessagestring
errorStyleDefaultDataValidator.errorStyleGC.Spread.Sheets.DataValidation.ErrorStyle
errorTitleDefaultDataValidator.errorTitlestring
ignoreBlankDefaultDataValidator.ignoreBlankboolean
inCellDropdownDefaultDataValidator.inCellDropdownBoolean
inputMessageDefaultDataValidator.inputMessagestring
inputTitleDefaultDataValidator.inputTitlestring
showErrorMessageDefaultDataValidator.showErrorMessageBoolean
showInputMessageDefaultDataValidator.showInputMessageBoolean

numberValidator 没有子标签。但有如下属性:

属性API 参考类型
comparisonOperatorDefaultDataValidator.createNumberValidator(comparisonOperator, value, value2, isIntegerValue)GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators
isIntegerValueDefaultDataValidator.createNumberValidator(comparisonOperator, value, value2, isIntegerValue)Boolean
value1DefaultDataValidator.createNumberValidator(comparisonOperator, value, value2, isIntegerValue)string
value2DefaultDataValidator.createNumberValidator(comparisonOperator, value, value2, isIntegerValue)string

dateValidator 没有子标签。 但有如下属性:

属性API 参考类型
comparisonOperatorDefaultDataValidator.createDateValidator(comparisonOperator, value, value2)GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators
value1DefaultDataValidator.createDateValidator(comparisonOperator, value, value2)string
value2DefaultDataValidator.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 参考类型
comparisonOperatorDefaultDataValidator.createTextLengthValidator(comparisonOperator, value, value2)GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators
value1DefaultDataValidator.createTextLengthValidator(comparisonOperator, value, value2)string
value2DefaultDataValidator.createTextLengthValidator(comparisonOperator, value, value2)string


formulaValidator 标签没有子标签,但有如下属性:

属性API 参考类型
formulaDefaultDataValidator.createFormulaValidator(formula)string

formulaListValidator 标签没有子标签,但有如下属性:

属性API 参考类型
formulalistDefaultDataValidator.createFormulaListValidator(formulalist)string


listValidator 没有子标签,但有如下属性:

属性API 参考类型
listDefaultDataValidator.createListValidator(list)string


 

  • No labels