RevisionAutoFormat Class

Revision AutoFormat.When the object is serialized out as xml, its qualified name is x:raf.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlLeafElement
      DocumentFormat.OpenXml.Spreadsheet.RevisionAutoFormat

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

Syntax

'Declaration
Public Class RevisionAutoFormat _
    Inherits OpenXmlLeafElement
'Usage
Dim instance As RevisionAutoFormat
public class RevisionAutoFormat : OpenXmlLeafElement

Remarks

[ISO/IEC 29500-1 1st Edition]

18.11.1.8 raf (Revision AutoFormat)

This element represents a revision record of auto formatting change information for a table.

Parent Elements

revisions (§18.11.1.16)

Attributes

Description

applyAlignmentFormats (Apply Alignment Formats)

If true apply legacy table autoformat alignment properties.

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

applyBorderFormats (Apply Border Formats)

If true apply legacy table autoformat border properties.

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

applyFontFormats (Apply Font Formats)

If true apply legacy table autoformat font properties.

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

applyNumberFormats (Apply Number Formats)

If true apply legacy table autoformat number format properties.

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

applyPatternFormats (Apply Pattern Formats)

If true apply legacy table autoformat pattern properties.

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

applyWidthHeightFormats (Apply Width / Height Formats)

If true apply legacy table autoformat width/height properties.

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

autoFormatId (Auto Format Id)

Identifies which legacy table autoformat to apply.

Annex D contains a listing of the supported PivotTable AutoFormats, example formatting, and a sample workbook with each of those AutoFormats applied.

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

ref (Reference)

A-1 style reference to the location where the formatting was applied

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

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

[Note: The W3C XML Schema definition of this element’s content model (CT_RevisionAutoFormatting) 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

RevisionAutoFormat Members

DocumentFormat.OpenXml.Spreadsheet Namespace