ssml:CT_DataValidation
Complex type information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-sheet.xsd
Content
- Sequence [1..1]
- ssml:formula1 [0..1] Formula 1
- ssml:formula2 [0..1] Formula 2
Attributes
Name | Occ | Type | Description | Notes |
---|---|---|---|---|
type | [0..1] | ssml:ST_DataValidationType | Data Validation Type | Default value is "none". |
errorStyle | [0..1] | ssml:ST_DataValidationErrorStyle | Data Validation Error Style | Default value is "stop". |
imeMode | [0..1] | ssml:ST_DataValidationImeMode | IME Mode Enforced | Default value is "noControl". |
operator | [0..1] | ssml:ST_DataValidationOperator | Operator | Default value is "between". |
allowBlank | [0..1] | xsd:boolean | Allow Blank | Default value is "false". |
showDropDown | [0..1] | xsd:boolean | Show Drop Down | Default value is "false". |
showInputMessage | [0..1] | xsd:boolean | Show Input Message | Default value is "false". |
showErrorMessage | [0..1] | xsd:boolean | Show Error Message | Default value is "false". |
errorTitle | [0..1] | ssml:ST_Xstring | Error Alert Text | |
error | [0..1] | ssml:ST_Xstring | Error Message | |
promptTitle | [0..1] | ssml:ST_Xstring | Prompt Title | |
prompt | [0..1] | ssml:ST_Xstring | Input Prompt | |
sqref | [1..1] | ssml:ST_Sqref | Sequence of References |
Used by
- Element ssml:dataValidation