Share via


Format Class

PivotTable Format.When the object is serialized out as xml, its qualified name is x:format.

Inheritance Hierarchy

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

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

Syntax

'宣言
<ChildElementInfoAttribute(GetType(PivotArea))> _
<ChildElementInfoAttribute(GetType(ExtensionList))> _
Public Class Format _
    Inherits OpenXmlCompositeElement
'使用
Dim instance As Format
[ChildElementInfoAttribute(typeof(PivotArea))]
[ChildElementInfoAttribute(typeof(ExtensionList))]
public class Format : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

  • PivotArea <x:pivotArea>

  • ExtensionList <x:extLst>

[ISO/IEC 29500-1 初版]

18.10.1.35 format (PivotTable Format)

Represents the format defined in the PivotTable.

Parent Elements

formats (§18.10.1.36)

Child Elements

Subclause

extLst (Future Feature Data Storage Area)

§18.2.10

pivotArea (Pivot Area)

§18.3.1.68

Attributes

Description

action (Format Action)

Specifies the formatting behavior for the area indicated in the pivotArea element. The default value for this attribute is "formatting," which indicates that the specified cells have some formatting applied. The format is specified in the dxfId attribute. If the formatting is cleared from the cells, then the value of this attribute becomes "blank."

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

dxfId (Format Id)

Specifies the identifier of the format the application is currently using for the PivotTable. Formatting information is written to the styles part. See the Styles section (§18.8) for more information on formats.

Formatting information provided by cell table and by PivotTable need not agree. If the two formats differ, the cell-level formatting takes precedence. If you change the layout the PivotTable, the PivotTable formatting will then take precedence.

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

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

© ISO/IEC29500: 2008. 上記の引用はマイクロソフト (またはその代理) によって英語から日本語に翻訳されたものであり、ISO はこうした翻訳に対する責任を一切負いません。

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

Format Members

DocumentFormat.OpenXml.Spreadsheet Namespace