[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@growShrinkType3.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>