Share via

2.7.18 ST_EditValidation

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_FormControlPr

This simple type specifies the type of validation used for data input to the control. If omitted, the value is assumed to be text. If present, the application can proceed to validate the data accordingly. The valid values are included in the following table.

Value

Meaning

text

Edit box contains text.

integer

Edit box contains an integer.

number

Edit box contains a number.

reference

Edit box contains a cell reference ([ISO/IEC29500-1:2016] section 18.17.2.3).

formula

Edit box contains a spreadsheet formula ([ISO/IEC29500-1:2016] section 18.17).

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this simple type.

 <xsd:simpleType name="ST_EditValidation">
   <xsd:restriction base="xsd:token">
     <xsd:enumeration value="text"/>
     <xsd:enumeration value="integer"/>
     <xsd:enumeration value="number"/>
     <xsd:enumeration value="reference"/>
     <xsd:enumeration value="formula"/>
   </xsd:restriction>
 </xsd:simpleType>

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).