<undo>
(Undo)
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.
Attributes |
Description |
---|---|
|
Flag indicating that the affected formula was array-entered. The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
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. |
|
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). |
|
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). |
|
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 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. |
|
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. |
|
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). |
|
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. |
|
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. |
|
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>