ssml:CT_QueryTable
Complex type information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-queryTable.xsd
Content
- Sequence [1..1]
- ssml:queryTableRefresh [0..1] QueryTable Refresh Information
- ssml:extLst [0..1] Future Feature Storage Area
Attributes
| Name | Occ | Type | Description | Notes |
|---|---|---|---|---|
| name | [1..1] | ssml:ST_Xstring | QueryTable Name | |
| headers | [0..1] | xsd:boolean | First Row Column Titles | Default value is "true". |
| rowNumbers | [0..1] | xsd:boolean | Row Numbers | Default value is "false". |
| disableRefresh | [0..1] | xsd:boolean | Disable Refresh | Default value is "false". |
| backgroundRefresh | [0..1] | xsd:boolean | Background Refresh | Default value is "true". |
| firstBackgroundRefresh | [0..1] | xsd:boolean | First Background Refresh | Default value is "false". |
| refreshOnLoad | [0..1] | xsd:boolean | Refresh On Load | Default value is "false". |
| growShrinkType | [0..1] | ssml:ST_GrowShrinkType | Grow Shrink Type | Default value is "insertDelete". |
| fillFormulas | [0..1] | xsd:boolean | Fill Adjacent Formulas | Default value is "false". |
| removeDataOnSave | [0..1] | xsd:boolean | Remove Data On Save | Default value is "false". |
| disableEdit | [0..1] | xsd:boolean | Disable Edit | Default value is "false". |
| preserveFormatting | [0..1] | xsd:boolean | Preserve Formatting On Refresh | Default value is "true". |
| adjustColumnWidth | [0..1] | xsd:boolean | Adjust Column Width On Refresh | Default value is "true". |
| intermediate | [0..1] | xsd:boolean | Intermediate | Default value is "false". |
| connectionId | [1..1] | xsd:unsignedInt | Connection ID | |
| autoFormatId | [0..1] | xsd:unsignedInt | Auto Format Id | from group ssml:AG_AutoFormat |
| applyNumberFormats | [0..1] | xsd:boolean | Apply Number Formats | from group ssml:AG_AutoFormat |
| applyBorderFormats | [0..1] | xsd:boolean | Apply Border Formats | from group ssml:AG_AutoFormat |
| applyFontFormats | [0..1] | xsd:boolean | Apply Font Formats | from group ssml:AG_AutoFormat |
| applyPatternFormats | [0..1] | xsd:boolean | Apply Pattern Formats | from group ssml:AG_AutoFormat |
| applyAlignmentFormats | [0..1] | xsd:boolean | Apply Alignment Formats | from group ssml:AG_AutoFormat |
| applyWidthHeightFormats | [0..1] | xsd:boolean | Apply Width / Height Formats | from group ssml:AG_AutoFormat |
Used by
- Element ssml:queryTable