Definition Type: ComplexType
Name: CT_QueryTableField
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-queryTable.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-querytable_xsd Drilldown into tableColumnId in schema sml-querytable_xsd Drilldown into clipped in schema sml-querytable_xsd Drilldown into fillFormulas in schema sml-querytable_xsd Drilldown into rowNumbers in schema sml-querytable_xsd Drilldown into dataBound in schema sml-querytable_xsd Drilldown into name in schema sml-querytable_xsd Drilldown into id in schema sml-querytable_xsdXSD Diagram of CT_QueryTableField in schema sml-querytable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code:
<xsd:complexType name="CT_QueryTableField">
    <xsd:sequence minOccurs="0">
        <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Future Feature Data Storage Area</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="id" type="xsd:unsignedInt" use="required">
        <xsd:annotation>
            <xsd:documentation>Field Id</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="name" type="ST_Xstring" use="optional">
        <xsd:annotation>
            <xsd:documentation>Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dataBound" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Data Bound Column</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="rowNumbers" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Row Numbers</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="fillFormulas" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Fill This Formula On Refresh</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="clipped" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Clipped Column</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="tableColumnId" type="xsd:unsignedInt" default="0">
        <xsd:annotation>
            <xsd:documentation>Table Column Id</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
extLst nsM:extLst 0 1
Collapse Child Attributes:
Name Type Default Value Use
id nsM:id Required
name nsM:name Optional
dataBound nsM:dataBound true Optional
rowNumbers nsM:rowNumbers false Optional
fillFormulas nsM:fillFormulas false Optional
clipped nsM:clipped false Optional
tableColumnId nsM:tableColumnId 0 (Optional)
Collapse Derivation Tree:
Collapse References:
nsM:queryTableField