Definition Type: ComplexType
Name: CT_QueryTableRefresh
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 sortState in schema sml-querytable_xsd Drilldown into queryTableDeletedFields in schema sml-querytable_xsd Drilldown into queryTableFields in schema sml-querytable_xsd Drilldown into unboundColumnsRight in schema sml-querytable_xsd Drilldown into unboundColumnsLeft in schema sml-querytable_xsd Drilldown into nextId in schema sml-querytable_xsd Drilldown into minimumVersion in schema sml-querytable_xsd Drilldown into headersInLastRefresh in schema sml-querytable_xsd Drilldown into fieldIdWrapped in schema sml-querytable_xsd Drilldown into preserveSortFilterLayout in schema sml-querytable_xsdXSD Diagram of CT_QueryTableRefresh in schema sml-querytable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code:
<xsd:complexType name="CT_QueryTableRefresh">
    <xsd:sequence>
        <xsd:element name="queryTableFields" type="CT_QueryTableFields" minOccurs="1" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Query table fields</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="queryTableDeletedFields" type="CT_QueryTableDeletedFields" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Deleted Fields</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="sortState" minOccurs="0" maxOccurs="1" type="CT_SortState">
            <xsd:annotation>
                <xsd:documentation>Sort State</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="extLst" minOccurs="0" maxOccurs="1" type="CT_ExtensionList">
            <xsd:annotation>
                <xsd:documentation>Future Feature Data Storage Area</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="preserveSortFilterLayout" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Preserve Sort &amp; Filter Layout</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="fieldIdWrapped" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Next Field Id Wrapped</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="headersInLastRefresh" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Headers In Last Refresh</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="minimumVersion" type="xsd:unsignedByte" use="optional" default="0">
        <xsd:annotation>
            <xsd:documentation>Minimum Refresh Version</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="nextId" type="xsd:unsignedInt" use="optional" default="1">
        <xsd:annotation>
            <xsd:documentation>Next field id</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="unboundColumnsLeft" type="xsd:unsignedInt" use="optional" default="0">
        <xsd:annotation>
            <xsd:documentation>Columns Left</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="unboundColumnsRight" type="xsd:unsignedInt" use="optional" default="0">
        <xsd:annotation>
            <xsd:documentation>Columns Right</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
queryTableFields nsM:queryTableFields 1 1
queryTableDeletedFields nsM:queryTableDeletedFields 0 1
sortState nsM:sortState 0 1
extLst nsM:extLst 0 1
Collapse Child Attributes:
Name Type Default Value Use
preserveSortFilterLayout nsM:preserveSortFilterLayout true Optional
fieldIdWrapped nsM:fieldIdWrapped false Optional
headersInLastRefresh nsM:headersInLastRefresh true Optional
minimumVersion nsM:minimumVersion 0 Optional
nextId nsM:nextId 1 Optional
unboundColumnsLeft nsM:unboundColumnsLeft 0 Optional
unboundColumnsRight nsM:unboundColumnsRight 0 Optional
Collapse Derivation Tree:
Collapse References:
nsM:queryTableRefresh