<rrc> (Revision Row Column Insert Delete)

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

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:

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.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_RevisionRowColumn">
	<choice minOccurs="0" maxOccurs="unbounded">
	<element name="undo" type="CT_UndoInfo" minOccurs="0" maxOccurs="unbounded"/>
	<element name="rcc" type="CT_RevisionCellChange" minOccurs="0" maxOccurs="unbounded"/>
	<element name="rfmt" type="CT_RevisionFormatting" minOccurs="0" maxOccurs="unbounded"/>
	</choice>
	<attributeGroup ref="AG_RevData"/>
	<attribute name="sId" type="xsd:unsignedInt" use="required"/>
	<attribute name="eol" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="ref" type="ST_Ref" use="required"/>
	<attribute name="action" type="ST_rwColActionType" use="required"/>
	<attribute name="edge" type="xsd:boolean" use="optional" default="false"/>
</complexType>