Undo Class
Undo.When the object is serialized out as xml, its qualified name is x:undo.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.Spreadsheet.Undo
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
Public Class Undo _
Inherits OpenXmlLeafElement
'Usage
Dim instance As Undo
public class Undo : OpenXmlLeafElement
Remarks
[ISO/IEC 29500-1 1st Edition]
18.11.1.25 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.
Parent Elements |
|---|
rm (§18.11.1.19); rrc (§18.11.1.21) |
Attributes |
Description |
|---|---|
array (Array Formula) |
Flag indicating that the affected formula is an array formula. The possible values for this attribute are defined by the W3C 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 W3C 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 (§22.9.2.19). |
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 (§18.18.63). |
exp (Expression) |
Identifies the expression that should be adjusted in the corresponding formula. The possible values for this attribute are defined by the ST_FormulaExpression simple type (§18.18.36). |
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 W3C 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 W3C 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 (§18.18.7). |
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 W3C 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 W3C 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 W3C XML Schema boolean datatype. |
[Note: The W3C XML Schema definition of this element’s content model (CT_UndoInfo) is located in §A.2. end note]
© ISO/IEC29500: 2008.
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.