[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

rcc (Revision Cell Change)

This element stores information about the contents of the cell that was replaced.

Parent Elements

revisions3.11.1.16); rm3.11.1.19); rrc3.11.1.21)

 

Child Elements

Subclause

extLst (Future Feature Data Storage Area)

§3.2.10

nc (New Cell Data)

§3.11.1.3

ndxf (New Formatting Information)

§3.11.1.4

oc (Old Cell Data)

§3.11.1.5

odxf (Old Formatting Information)

§3.11.1.6

 

Attributes

Description

dxf (Formatting)

A Boolean flag indicating that there was a differential formatting change for this cell - true if there was a formatting change, false otherwise.

 

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

endOfListFormulaUpdate (End of List Formula Update)

A Boolean flag indicating that indicates that the formula used at the end of a list has been updated. True if the formula was updated, false otherwise.

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.

numFmtId (Number Format Id)

Zero-based index of the number format (Fmt) record used by this cell format (XF).

 

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

odxf (Old Formatting)

Flag indicating that there is old formatting information available for this cell.

 

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

oldPh (Old Phonetic Text)

A Boolean flag indicating whether there is old phonetic text information available. True when there is old phonetic text information available, false otherwise.

 

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

oldQuotePrefix (Old Quote Prefix)

A Boolean value indicating if a single quote prefix is was used on this cell previously. Single quote prefixes are used to cause a formula to be evaluated as a string. True if a single quote prefix was used previously, false otherwise

 

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

ph (Phonetic Text)

A Boolean flag indicating whether this cell contains phonetic text or not. True when the cell contains phonetic text, false otherwise.

 

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

quotePrefix (Quote Prefix)

A Boolean value indicating if a single quote prefix is used. Single quote prefixes are used to cause a formula to be evaluated as a string. True if a single quote prefix is used, false otherwise.

 

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.

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.

s (Style Revision)

Flag indicating that formatting change for this cell affected the cell's style. (Only applicable for Undo operations)

 

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

sId (Sheet Id)

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

xfDxf (Row Column Formatting Change)

Flag indicating that the formatting change had an effect on the formatting of the entire row or column that this cell belongs to. (Only applicable for Undo operations).

 

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

   <sequence>

   <element name="oc" type="CT_Cell" minOccurs="0" maxOccurs="1"/>

   <element name="nc" type="CT_Cell" minOccurs="1" maxOccurs="1"/>

   <element name="odxf" type="CT_Dxf" minOccurs="0" maxOccurs="1"/>

   <element name="ndxf" type="CT_Dxf" minOccurs="0" maxOccurs="1"/>

   <element name="extLst" minOccurs="0" type="CT_ExtensionList"/>

   </sequence>

   <attributeGroup ref="AG_RevData"/>

   <attribute name="sId" type="xsd:unsignedInt" use="required"/>

   <attribute name="odxf" type="xsd:boolean" default="false"/>

   <attribute name="xfDxf" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="s" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="dxf" type="xsd:boolean" default="false"/>

   <attribute name="numFmtId" type="ST_NumFmtId" use="optional"/>

   <attribute name="quotePrefix" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="oldQuotePrefix" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="ph" type="xsd:boolean" default="false"/>

   <attribute name="oldPh" type="xsd:boolean" default="false"/>

   <attribute name="endOfListFormulaUpdate" type="xsd:boolean" default="false"/>

</complexType>