[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

rm (Revision Cell Move)

This element represents a revision record on a cell(s) that moved.

Parent Elements

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

destination (Destination)

New A1 style location of the cell(s) that were moved

 

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

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.

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.

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

source (Source)

The original A1 style location of the cell(s) that were moved

 

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

sourceSheetId (Source Sheet Id)

An integer representing the internal id of the sheet where the cell(s) originally resided.

 

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_RevisionMove">

   <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="sheetId" type="xsd:unsignedInt" use="required"/>

   <attribute name="source" type="ST_Ref" use="required"/>

   <attribute name="destination" type="ST_Ref" use="required"/>

   <attribute name="sourceSheetId" type="xsd:unsignedInt" use="optional" default="0"/>

</complexType>