ssml:queryTableRefresh

QueryTable Refresh Information

Element information

Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main

Schema document: sml-queryTable.xsd

Type: ssml:CT_QueryTableRefresh

Properties: Local, Qualified

Content

Sequence [1..1]
1. ssml:queryTableFields [1..1] Query table fields
2. ssml:queryTableDeletedFields [0..1] Deleted Fields
3. ssml:sortState [0..1] Sort State
4. ssml:extLst [0..1] Future Feature Storage Area

Attributes

Name	Occ	Type	Description	Notes
preserveSortFilterLayout	[0..1]	xsd:boolean	Preserve Sort & Filter Layout	Default value is "true".
fieldIdWrapped	[0..1]	xsd:boolean	Next Field Id Wrapped	Default value is "false".
headersInLastRefresh	[0..1]	xsd:boolean	Headers In Last Refresh	Default value is "true".
minimumVersion	[0..1]	xsd:unsignedByte	Minimum Refresh Version	Default value is "0".
nextId	[0..1]	xsd:unsignedInt	Next field id	Default value is "1".
unboundColumnsLeft	[0..1]	xsd:unsignedInt	Columns Left	Default value is "0".
unboundColumnsRight	[0..1]	xsd:unsignedInt	Columns Right	Default value is "0".

Used in

Type ssml:CT_QueryTable (Element ssml:queryTable)

Sample instance

<ssml:queryTableRefresh>
   <ssml:queryTableFields>
      <ssml:queryTableField id="1" name="string">
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:queryTableField>
   </ssml:queryTableFields>
   <ssml:queryTableDeletedFields>
      <ssml:deletedField name="string"/>
   </ssml:queryTableDeletedFields>
   <ssml:sortState ref="string">
      <ssml:sortCondition ref="string" iconSet="3Arrows"/>
      <ssml:extLst>
         <ssml:ext>
            <!--any element-->
         </ssml:ext>
      </ssml:extLst>
   </ssml:sortState>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:queryTableRefresh>