[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
ST_GrowShrinkType (Grow Shrink Type)
This type enumerates behavior patterns for refreshing external data in a query table.
This simple type's contents are a restriction of the XML Schema string datatype.
The following are possible enumeration values for this type:
Enumeration Value |
Description |
insertClear (Insert & Clear On Refresh) |
Insert entire rows for new data, clear unused cells. |
insertDelete (Insert & Delete On Refresh) |
Insert cells for new data, delete unused cells. |
overwriteClear (Overwrite & Clear On Refresh) |
Overwrite existing cells with new data, clear unused cells. |
Referenced By |
queryTable@growShrinkType (§3.12.2) |
The following XML Schema fragment defines the contents of this simple type:
<simpleType name="ST_GrowShrinkType">
<restriction base="xsd:string">
<enumeration value="insertDelete"/>
<enumeration value="insertClear"/>
<enumeration value="overwriteClear"/>
</restriction>
</simpleType>