Definition Type: Group
Name: CellType
Namespace: urn:schemas-microsoft-com:office:spreadsheet
Containing Schema: excelss.xsd
Collapse XSD Schema Diagram:
Drilldown into NamedCell in schema excelss_xsd Drilldown into phonetictext in schema excel_xsd Drilldown into Comment in schema excelss_xsd Drilldown into Data in schema excelss_xsd Drilldown into SmartTags in schema office_xsdXSD Diagram of CellType in schema excelss_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code:
<xsd:group name="CellType">
    <xsd:sequence>
        <xsd:element ref="o:SmartTags" minOccurs="0" maxOccurs="unbounded" />
        <xsd:element name="Data" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the value of a cell. The value should be specified in the format appropriate for the Type attribute of the cell.</xsd:documentation>
            </xsd:annotation>
            <xsd:complexType mixed="true">
                <xsd:sequence>
                    <xsd:any processContents="skip" minOccurs="0" maxOccurs="unbounded" />
                </xsd:sequence>
                <xsd:attribute form="qualified" name="Type" use="required">
                    <xsd:annotation>
                        <xsd:documentation>Specifies the type of data to be contained by the cell.</xsd:documentation>
                    </xsd:annotation>
                    <xsd:simpleType>
                        <xsd:restriction base="xsd:string">
                            <xsd:enumeration value="Number" />
                            <xsd:enumeration value="DateTime" />
                            <xsd:enumeration value="Boolean" />
                            <xsd:enumeration value="String" />
                            <xsd:enumeration value="Error" />
                        </xsd:restriction>
                    </xsd:simpleType>
                </xsd:attribute>
                <xsd:attribute ref="x:Ticked" />
            </xsd:complexType>
        </xsd:element>
        <xsd:element name="Comment" type="CommentType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a comment to be associated with a cell.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element ref="x:phonetictext" minOccurs="0" />
        <xsd:element name="NamedCell" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Presence of this tag indicates that this cell is a member of a user-defined named range. When saved from Excel, this tag is only present on cells that are non-empty or contain formatting. This tag can appear multiple times (one for each user-defined name that this cell lies in).</xsd:documentation>
            </xsd:annotation>
            <xsd:complexType>
                <xsd:attribute form="qualified" name="Name" type="xsd:string" use="optional">
                    <xsd:annotation>
                        <xsd:documentation>Specifies a user-defined named range to which the cell belongs.</xsd:documentation>
                    </xsd:annotation>
                </xsd:attribute>
            </xsd:complexType>
        </xsd:element>
    </xsd:sequence>
</xsd:group>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
SmartTags o:SmartTags 0 unbounded
Data ss:Data 0 (1)
Comment ss:Comment 0 (1)
phonetictext x:phonetictext 0 (1)
NamedCell ss:NamedCell 0 unbounded