[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
This element represents undo information for row/column deletion when there are functions in the spreadsheet that reference the deleted rows/columns. This element is not applicable for insert revisions.
|
Parent Elements |
|
Attributes |
Description |
|
array (Array Entered) |
Flag indicating that the affected formula was array-entered.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
cs (Cross Sheet Move) |
A Boolean flag indicating this was a cross-sheet move. True if it was a cross sheet move, false otherwise.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
dn (Defined Name) |
Identifies the named range that referenced the deleted cell range. Mutually exclusive with the cell reference attribute.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
dr (Range) |
The range which was deleted that is referenced by the affected formula.
The possible values for this attribute are defined by the ST_RefA simple type (§3.18.65). |
|
exp (Expression) |
Identifies the type of the expression that should be adjusted in the corresponding formula.
The possible values for this attribute are defined by the ST_FormulaExpression simple type (§3.18.37). |
|
index (Index) |
Index of the expression within the corresponding formula that was affected by this change.
The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
|
nf (Defined Name Formula) |
A Boolean flag indicating that the corresponding formula is part of a defined name. True if this formula is part of a defined name, false otherwise.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
r (Cell Reference) |
Location of the cell whose formula referenced the deleted cell range. Mutually exclusive with the defined name attribute
The possible values for this attribute are defined by the ST_CellRef simple type (§3.18.8). |
|
ref3D (Reference 3D) |
A Boolean flag indicating that the expression contained the sheet name in addition to the cell reference. True if it contained the sheet name, false otherwise.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
sId (Sheet Id) |
Internal Id of the worksheet that contained the formula that referenced the deleted cell range. Mutually exclusive with the defined name attribute.
The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
|
v (Value Needed) |
A Boolean flag indicating the formula needs the actual value of the cell(s) it's referencing. True if the formula requires the value of the cell it references, false otherwise.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_UndoInfo">
<attribute name="index" type="xsd:unsignedInt" use="required"/>
<attribute name="exp" type="ST_FormulaExpression" use="required"/>
<attribute name="ref3D" type="xsd:boolean" use="optional" default="false"/>
<attribute name="array" type="xsd:boolean" use="optional" default="false"/>
<attribute name="v" type="xsd:boolean" use="optional" default="false"/>
<attribute name="nf" type="xsd:boolean" use="optional" default="false"/>
<attribute name="cs" type="xsd:boolean" use="optional" default="false"/>
<attribute name="dr" type="ST_RefA" use="required"/>
<attribute name="dn" type="ST_Xstring" use="optional"/>
<attribute name="r" type="ST_CellRef" use="optional"/>
<attribute name="sId" type="xsd:unsignedInt" use="optional"/>
</complexType>