Parent Elements

revisions (§3.11.1.16)

Child Elements

Subclause

rcc (Revision Cell Change)

§3.11.1.9

rfmt (Revision Format)

§3.11.1.17

undo (Undo)

§3.11.1.25

Attributes

Description

action (User Action)

Indicates what type of action the user just performed on the row or column.

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

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

Note: 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 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 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 shall 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 (§3.18.64).

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 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 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 XML Schema boolean datatype.