Export (0) Print
Expand All

PivotOptions class

Defines the PivotOptions Class.This class is available in Office2010 or above. When the object is serialized out as xml, its qualified name is c14:pivotOptions.

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Office2010.Drawing.Charts.PivotOptions

Namespace:  DocumentFormat.OpenXml.Office2010.Drawing.Charts
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(DropZoneFilter), FileFormatVersions.None|FileFormatVersions.Office2010|FileFormatVersions.Office2013)]
[ChildElementInfoAttribute(typeof(DropZoneCategories), FileFormatVersions.None|FileFormatVersions.Office2010|FileFormatVersions.Office2013)]
[ChildElementInfoAttribute(typeof(DropZoneData), FileFormatVersions.None|FileFormatVersions.Office2010|FileFormatVersions.Office2013)]
[ChildElementInfoAttribute(typeof(DropZoneSeries), FileFormatVersions.None|FileFormatVersions.Office2010|FileFormatVersions.Office2013)]
[ChildElementInfoAttribute(typeof(DropZonesVisible), FileFormatVersions.None|FileFormatVersions.Office2010|FileFormatVersions.Office2013)]
public class PivotOptions : OpenXmlCompositeElement

2.3.11 pivotOptions

Target namespace: http://schemas.microsoft.com/office/drawing/2007/8/2/chart

A CT_PivotOptions element that specifies the pivot controls that appear on the chart ([ISO/IEC-29500-1] section 21.2).

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.

<xsd:element name="pivotOptions" type="CT_PivotOptions"/>

See section 5.10 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.5.57 CT_PivotOptions

Target namespace: http://schemas.microsoft.com/office/drawing/2007/8/2/chart

Referenced by: pivotOptions

A complex type that specifies the pivot controls that appear on the chart ([ISO/IEC-29500-1] section 21.2).

Child Elements:

dropZoneFilter: A CT_BooleanFalse element that specifies whether a control for each PivotTable field ([ISO/IEC-29500-1] section 18.10) on the PivotTable page axis ([ISO/IEC-29500-1] section 18.10) of the source PivotTable appears on the chart when dropZonesVisible is set to TRUE. MUST NOT exist if the parent CT_ChartSpace element ([ISO/IEC-29500-4] section A.5.1) does not have a child CT_PivotSource element ([ISO/IEC-29500-4] section A.5.1).

dropZoneCategories: A CT_BooleanFalse element that specifies whether a control for each PivotTable field on the PivotTable row axis of the source PivotTable appears on the chart when dropZonesVisible is set to TRUE. MUST NOT exist if the parent CT_ChartSpace element does not have a child CT_PivotSource element.

dropZoneData: A CT_BooleanFalse element that specifies whether a control for each PivotTable field on the PivotTable data axis of the source PivotTable appears on the chart when dropZonesVisible is set to TRUE. MUST NOT exist if the parent CT_ChartSpace element does not have a child CT_PivotSource element.

dropZoneSeries: A CT_BooleanFalse element that specifies whether a control for each PivotTable field on the PivotTable column axis of the source PivotTable appears on the chart when dropZonesVisible is set to TRUE. MUST NOT exist if the parent CT_ChartSpace element does not have a child CT_PivotSource element.

dropZonesVisible: A CT_BooleanFalse element that specifies whether any pivot controls can appear on the pivot chart. For example, if dropZoneFilter and dropZoneCategories are set to TRUE and dropZoneData and dropZoneSeries are set to FALSE, if dropZonesVisible is set to TRUE, controls corresponding to PivotTable fields on the PivotTable page axis and PivotTable row axis appear on the chart, and if dropZonesVisible is set to FALSE, no controls appears on the chart. MUST NOT exist if the parent CT_ChartSpace element does not have a child CT_PivotSource element.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

<xsd:complexType name="CT_PivotOptions">

<xsd:sequence>

<xsd:element name="dropZoneFilter" type="CT_BooleanFalse" minOccurs="0" maxOccurs="1"/>

<xsd:element name="dropZoneCategories" type="CT_BooleanFalse" minOccurs="0" maxOccurs="1"/>

<xsd:element name="dropZoneData" type="CT_BooleanFalse" minOccurs="0" maxOccurs="1"/>

<xsd:element name="dropZoneSeries" type="CT_BooleanFalse" minOccurs="0" maxOccurs="1"/>

<xsd:element name="dropZonesVisible" type="CT_BooleanFalse" minOccurs="0" maxOccurs="1"/>

</xsd:sequence>

</xsd:complexType>

See section 5.10 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

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

Community Additions

ADD
Show:
© 2014 Microsoft