[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

rfmt (Revision Format)

This element represents a revision record of information about a formatting change.

Parent Elements

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

 

Child Elements

Subclause

dxf (Formatting)

§3.8.14

extLst (Future Feature Data Storage Area)

§3.2.10

 

Attributes

Description

length (Length)

The number of characters that were affected by a string change, counting from start.

 

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

s (Style)

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

 

The possible values for this attribute are defined by the XML Schema boolean 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.

sqref (Sequence Of References)

A worksheet range to which this formatting was applied. [Note: For applications supporting the default grid size (see §3.17.5), full column and row references shall explicitly state the row and column components, e.g., "A1:A1048576" For column "A", and A1:XFD1 for row "1". Applications with larger grid sizes shall interpret these to mean "column A" and "row 1" respectively, for their larger grid size. end note]

 

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

start (Start index)

An integer representing an index showing which character a string change starts at within the string in the cell.

 

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

xfDxf (Row or Column Formatting Change)

A Boolean flag indicating that this formatting change had an affect on the formatting of an entire row or column that an affected cell(s) 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_RevisionFormatting">

   <sequence>

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

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

   </sequence>

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

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

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

   <attribute name="sqref" type="ST_Sqref" use="required"/>

   <attribute name="start" type="xsd:unsignedInt" use="optional"/>

   <attribute name="length" type="xsd:unsignedInt" use="optional"/>

</complexType>