Undo Class

Undo.When the object is serialized out as xml, its qualified name is x:undo.

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

public class Undo : OpenXmlLeafElement

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

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

ADD
Show:
© 2014 Microsoft