ssml:dataValidation
Data Validation
Element information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-sheet.xsd
Type: ssml:CT_DataValidation
Properties: Local, Qualified
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 in
- Type ssml:CT_DataValidations (Element ssml:dataValidations)
Sample instance
<ssml:dataValidation sqref="string string"> <ssml:formula1>string</ssml:formula1> <ssml:formula2>string</ssml:formula2> </ssml:dataValidation>