RevisionCellChange Class

Revision Cell Change.When the object is serialized out as xml, its qualified name is x:rcc.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Spreadsheet.RevisionCellChange

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

Syntax

'Declaration
<ChildElementInfoAttribute(GetType(NewCell))> _
<ChildElementInfoAttribute(GetType(ExtensionList))> _
<ChildElementInfoAttribute(GetType(NewDifferentialFormat))> _
<ChildElementInfoAttribute(GetType(OldCell))> _
<ChildElementInfoAttribute(GetType(OldDifferentialFormat))> _
Public Class RevisionCellChange _
    Inherits OpenXmlCompositeElement
'Usage
Dim instance As RevisionCellChange
[ChildElementInfoAttribute(typeof(NewCell))]
[ChildElementInfoAttribute(typeof(ExtensionList))]
[ChildElementInfoAttribute(typeof(NewDifferentialFormat))]
[ChildElementInfoAttribute(typeof(OldCell))]
[ChildElementInfoAttribute(typeof(OldDifferentialFormat))]
public class RevisionCellChange : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

  • OldCell <x:oc>

  • NewCell <x:nc>

  • OldDifferentialFormat <x:odxf>

  • NewDifferentialFormat <x:ndxf>

  • ExtensionList <x:extLst>

[ISO/IEC 29500-1 1st Edition]

18.11.1.9 rcc (Revision Cell Change)

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

Parent Elements

revisions (§18.11.1.16); rm (§18.11.1.19); rrc (§18.11.1.21)

Child Elements

Subclause

extLst (Future Feature Data Storage Area)

§18.2.10

nc (New Cell Data)

§18.11.1.3

ndxf (New Formatting Information)

§18.11.1.4

oc (Old Cell Data)

§18.11.1.5

odxf (Old Formatting Information)

§18.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 W3C 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.

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.

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 (§18.18.47).

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

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.

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

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

[Note: The W3C XML Schema definition of this element’s content model (CT_RevisionCellChange) is located in §A.2. end note]

© ISO/IEC29500: 2008.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

RevisionCellChange Members

DocumentFormat.OpenXml.Spreadsheet Namespace