RevisionRowColumn Class

Revision Row Column Insert Delete.When the object is serialized out as xml, its qualified name is x:rrc.

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

[ChildElementInfoAttribute(typeof(RevisionCellChange))]
[ChildElementInfoAttribute(typeof(RevisionFormat))]
[ChildElementInfoAttribute(typeof(Undo))]
public class RevisionRowColumn : OpenXmlCompositeElement

The following table lists the possible child types:

  • Undo <x:undo>

  • RevisionCellChange <x:rcc>

  • RevisionFormat <x:rfmt>


[ISO/IEC 29500-1 1st Edition]

18.11.1.21 rrc (Revision Row Column Insert Delete)

This element represents a revision record of a row/column insert/delete action.

Parent Elements

revisions (§18.11.1.16)

Child Elements

Subclause

rcc (Revision Cell Change)

§18.11.1.9

rfmt (Revision Format)

§18.11.1.17

undo (Undo)

§18.11.1.25

Attributes

Description

action (User Action)

Indicates the action most recently performed on the row or column.

The possible values for this attribute are defined by the ST_rwColActionType simple type (§18.18.66).

edge (Edge Deleted)

A Boolean flag indicating that a row or column is being deleted at the edge of a sorted range (only applicable to a Delete Row/Column revision types).

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.

eol (End Of List)

A Boolean flag indicating that a row or a column is being inserted at the end of a list of data.

List in this context does not mean table, rather it refers to the feature where the spreadsheet application automatically creates an internal structure for making data input more consistent on adjacent rows or columns. For instance, if 3 cells in a row are entered with the same format, then when entering data into the 4th adjacent cell, the spreadsheet application might automatically apply that same format. In this case, those cells are treated as a list.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.

ra (Revision Undo Rejected)

A Boolean flag which indicates that this revision was due to a previous undo (ua) revision being rejected.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.

ref (Reference)

A reference to the location of the rows/columns that were inserted or deleted.

[Note: A reference to a whole column or row must include both the column and row components. For example, column A is referenced by "A1:A1048576", and row 1 is referenced by "A1:XFD1". However, because this attribute value is occurring in the context of an entire row or column insert, the column component of a row reference can be ignored, and the row component of a column reference can be ignored. end note]

The possible values for this attribute are defined by the ST_Ref simple type (§18.18.62).

rId (Revision Id)

An integer representing the number of this revision. This id shall apply to reviewable revision types only.

The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype.

sId (Sheet Id)

An integer representing the internal id of the sheet on which the revision occurred.

The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype.

ua (Revision From Rejection)

A Boolean flag indicating that this revision occurred because another revision was rejected and therefore undone.

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_RevisionRowColumn) 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: