PivotField Members

  • Article

Include Protected Members
Include Inherited Members

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

The PivotField type exposes the following members.

Constructors

  Name Description
Public method PivotField() Initializes a new instance of the PivotField class.
Public method PivotField(String) Initializes a new instance of the PivotField class from outer XML.
Public method PivotField(array<OpenXmlElement[]) Initializes a new instance of the PivotField class with the specified child elements.
Public method PivotField(IEnumerable<OpenXmlElement>) Initializes a new instance of the PivotField class with the specified child elements.

Top

Properties

  Name Description
Public property AllDrilled All Items Expanded.Represents the attribte in schema: allDrilled
Public property ApplyProductInSubtotal Product Subtotal.Represents the attribte in schema: productSubtotal
Public property ApplyStandardDeviationInSubtotal StdDev Subtotal.Represents the attribte in schema: stdDevSubtotal
Public property ApplyStandardDeviationPInSubtotal StdDevP Subtotal.Represents the attribte in schema: stdDevPSubtotal
Public property ApplyVarianceInSubtotal Variance Subtotal.Represents the attribte in schema: varSubtotal
Public property ApplyVariancePInSubtotal VarP Subtotal.Represents the attribte in schema: varPSubtotal
Public property AutoShow Auto Show.Represents the attribte in schema: autoShow
Public property AutoSortScope AutoSort Scope.Represents the element tag in schema: x:autoSortScope
Public property AverageSubTotal Average.Represents the attribte in schema: avgSubtotal
Public property Axis Axis.Represents the attribte in schema: axis
Public property ChildElements Gets all the child nodes of this element. (Inherited from OpenXmlElement.)
Public property Compact Compact.Represents the attribte in schema: compact
Public property CountASubtotal CountA.Represents the attribte in schema: countASubtotal
Public property CountSubtotal Count.Represents the attribte in schema: countSubtotal
Public property DataField Data Field.Represents the attribte in schema: dataField
Public property DataSourceSort Data Source Sort.Represents the attribte in schema: dataSourceSort
Public property DefaultAttributeDrillState Drill State.Represents the attribte in schema: defaultAttributeDrillState
Public property DefaultSubtotal Show Default Subtotal.Represents the attribte in schema: defaultSubtotal
Public property DragOff Drag Off.Represents the attribte in schema: dragOff
Public property DragToColumn Drag To Column.Represents the attribte in schema: dragToCol
Public property DragToData Field Can Drag to Data.Represents the attribte in schema: dragToData
Public property DragToPage Drag Field to Page.Represents the attribte in schema: dragToPage
Public property DragToRow Drag To Row.Represents the attribte in schema: dragToRow
Public property ExtendedAttributes Gets all extended attributes (attributes not defined in schema) of the element. (Inherited from OpenXmlElement.)
Public property FirstChild Gets the first child of the OpenXmlElement. If there is no such OpenXmlElement, a null reference (Nothing in Visual Basic) is returned. (Inherited from OpenXmlCompositeElement.)
Public property HasAttributes Gets a boolean value indicating whether the current element has any attributes. (Inherited from OpenXmlElement.)
Public property HasChildren Gets a value indicating whether this element has any child elements. (Inherited from OpenXmlCompositeElement.)
Public property HiddenLevel Hidden Level.Represents the attribte in schema: hiddenLevel
Public property HideNewItems Hide New Items.Represents the attribte in schema: hideNewItems
Public property IncludeNewItemsInFilter Inclusive Manual Filter.Represents the attribte in schema: includeNewItemsInFilter
Public property InnerText Gets or sets the concatenated values of the node and all its children. (Inherited from OpenXmlCompositeElement.)
Public property InnerXml Gets or sets the markup representing only the child nodes of this node. (Inherited from OpenXmlCompositeElement.)
Public property InsertBlankRow Insert Blank Row.Represents the attribte in schema: insertBlankRow
Public property InsertPageBreak Insert Item Page Break.Represents the attribte in schema: insertPageBreak
Public property ItemPageCount Items Per Page Count.Represents the attribte in schema: itemPageCount
Public property Items Field Items.Represents the element tag in schema: x:items
Public property LastChild Gets the last child of the OpenXmlElement. If there is no such OpenXmlElement, a null reference (Nothing in Visual Basic) is returned. (Inherited from OpenXmlCompositeElement.)
Public property LocalName Gets the local name of the element. (Overrides OpenXmlElement.LocalName.)
Public property MaxSubtotal Max Subtotal.Represents the attribte in schema: maxSubtotal
Public property MCAttributes Markup Compatibility Attributes Set. Return null if there is no Markup Compatibility Attribute defined in this element. (Inherited from OpenXmlElement.)
Public property MeasureFilter Measure Filter.Represents the attribte in schema: measureFilter
Public property MinSubtotal Min Subtotal.Represents the attribte in schema: minSubtotal
Public property MultipleItemSelectionAllowed Multiple Field Filters.Represents the attribte in schema: multipleItemSelectionAllowed
Public property Name Field Name.Represents the attribte in schema: name
Public property NamespaceDeclarations Gets all the namespace declarations defined in the current element. Return an empty enumerator if there is no namespace declaration. (Inherited from OpenXmlElement.)
Public property NamespaceUri Gets the namespace URI of this node. (Inherited from OpenXmlElement.)
Public property NonAutoSortDefault Auto Sort.Represents the attribte in schema: nonAutoSortDefault
Public property NumberFormatId Number Format Id.Represents the attribte in schema: numFmtId
Public property OpenXmlElementContext Gets the OpenXmlEementContext. (Inherited from OpenXmlElement.)
Public property OuterXml Gets the markup representing this element and all its child elements. (Inherited from OpenXmlElement.)
Public property Outline Outline Items.Represents the attribte in schema: outline
Public property Parent Gets the parent of this element. (Inherited from OpenXmlElement.)
Public property PivotFieldExtensionList Future Feature Data Storage Area.Represents the element tag in schema: x:extLst
Public property Prefix Gets the namespace prefix of this node. (Inherited from OpenXmlElement.)
Public property RankBy Auto Show Rank By.Represents the attribte in schema: rankBy
Public property ServerField Server-based Page Field.Represents the attribte in schema: serverField
Public property ShowAll Show All Items.Represents the attribte in schema: showAll
Public property ShowDropDowns Show PivotField Header Drop Downs.Represents the attribte in schema: showDropDowns
Public property ShowPropAsCaption Show As Caption.Represents the attribte in schema: showPropAsCaption
Public property ShowPropCell Show Member Property in Cell.Represents the attribte in schema: showPropCell
Public property ShowPropertyTooltip Show Member Property ToolTip.Represents the attribte in schema: showPropTip
Public property SortType Auto Sort Type.Represents the attribte in schema: sortType
Public property SubtotalCaption Custom Subtotal Caption.Represents the attribte in schema: subtotalCaption
Public property SubtotalTop Subtotals At Top.Represents the attribte in schema: subtotalTop
Public property SumSubtotal Sum Subtotal.Represents the attribte in schema: sumSubtotal
Public property TopAutoShow Top Auto Show.Represents the attribte in schema: topAutoShow
Public property UniqueMemberProperty Unique Member Property.Represents the attribte in schema: uniqueMemberProperty
Public property XmlQualifiedName Gets the qualified name of the node. (Inherited from OpenXmlElement.)

Top

Methods

  Name Description
Public method AddAnnotation Adds an object to the annotation list of this OpenXmlElement. (Inherited from OpenXmlElement.)
Public method AddNamespaceDeclaration Adds a namepace declaration to the current node. (Inherited from OpenXmlElement.)
Public method Ancestors() Enumerate all the ancestor nodes of this element. (Inherited from OpenXmlElement.)
Public method Annotation(Type) Get the first annotation object of the specified type from this OpenXmlElement. (Inherited from OpenXmlElement.)
Public method Annotation<T>() Get the first annotation object of the specified type from this OpenXmlElement. (Inherited from OpenXmlElement.)
Public method Annotations(Type) Gets a collection of annotations of the specified type for this OpenXmlElement. (Inherited from OpenXmlElement.)
Public method Annotations<T>() Gets a collection of annotations of the specified type for this OpenXmlElement. (Inherited from OpenXmlElement.)
Public method Append(array<OpenXmlElement[]) Adds the elements to the end of the list of child nodes, of this element. (Inherited from OpenXmlElement.)
Public method Append(IEnumerable<OpenXmlElement>) Adds the elements to the end of the list of child nodes, of this element. (Inherited from OpenXmlElement.)
Public method AppendChild<T>(T) Adds the specified element to the end of the list of child nodes, of this element. (Inherited from OpenXmlCompositeElement.)
Public method AppendChild<T>(T) Adds the specified element to the end of the list of child nodes, of this element. (Inherited from OpenXmlElement.)
Public method ClearAllAttributes Clear all the attributes ( known attributes + extended attributes ) (Inherited from OpenXmlElement.)
Public method Clone Creates a duplicate of this node. (Inherited from OpenXmlElement.)
Public method CloneNode Creates a duplicate of this node. (Overrides OpenXmlElement.CloneNode(Boolean).)
Public method Descendants<T>() Enumerate all the descendants elements (which type is T) of this element. Preorder traversering. (Inherited from OpenXmlElement.)
Public method Elements<T>() Enumerate for specific type of elements in child elements (Inherited from OpenXmlElement.)
Public method ElementsAfter Enumerate all the sibling elements after this element in same parent. (Inherited from OpenXmlElement.)
Public method ElementsBefore Enumerate all the sibling elements before this element in same parent. (Inherited from OpenXmlElement.)
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Public method GetAttribute Gets a Open XML attribute with the specifed tag name and namespace URI. (Inherited from OpenXmlElement.)
Public method GetAttributes Get a copy of all the attributes (Inherited from OpenXmlElement.)
Public method GetEnumerator Returns an enumerator that iterates through the child collection. (Inherited from OpenXmlElement.)
Public method GetFirstChild<T> Find the first child element in type T (Inherited from OpenXmlElement.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Public method InsertAfter<T>(T, OpenXmlElement) Inserts the specified element immediately after the specified reference element. (Inherited from OpenXmlCompositeElement.)
Public method InsertAfter<T>(T, OpenXmlElement) Inserts the specified element immediately after the specified reference element. (Inherited from OpenXmlElement.)
Public method InsertAfterSelf<T> Inserts the specified element immediately after this element. (Inherited from OpenXmlElement.)
Public method InsertAt<T>(T, Int32) Inserts the specified element at the specified index in children. (Inherited from OpenXmlCompositeElement.)
Public method InsertAt<T>(T, Int32) Inserts the specified element at the specified index in children. (Inherited from OpenXmlElement.)
Public method InsertBefore<T>(T, OpenXmlElement) Inserts the specified element immediately before the specified reference element. (Inherited from OpenXmlCompositeElement.)
Public method InsertBefore<T>(T, OpenXmlElement) Inserts the specified element immediately before the specified reference element. (Inherited from OpenXmlElement.)
Public method InsertBeforeSelf<T> Inserts the specified element immediately before this element. (Inherited from OpenXmlElement.)
Public method IsAfter Determines if the current element appears after a specified element in document order. (Inherited from OpenXmlElement.)
Public method IsBefore Determines if the current element appears before a specified element in document order. (Inherited from OpenXmlElement.)
Public method LookupNamespace Resolve the namespace prefix in the context of current node (Inherited from OpenXmlElement.)
Public method LookupPrefix Finds the corresponding prefix for a namespace uri in the current element scope. (Inherited from OpenXmlElement.)
Protected method MemberwiseClone (Inherited from Object.)
Public method NextSibling() Gets the OpenXmlElement immediately following this OpenXmlElement. If there is no next OpenXmlElement, a null reference (Nothing in Visual Basic) is returned. (Inherited from OpenXmlElement.)
Public method PrependChild<T>(T) Adds the specified element to the beginning of the list of child nodes for this element. (Inherited from OpenXmlCompositeElement.)
Public method PrependChild<T>(T) Adds the specified element to the beginning of the list of child nodes for this element. (Inherited from OpenXmlElement.)
Public method PreviousSibling() Gets the OpenXmlElement immediately preceding this OpenXmlElement. If there is no such preceding OpenXmlElement, a null reference (Nothing in Visual Basic) is returned. (Inherited from OpenXmlElement.)
Public method Remove Removes this element from its parent. (Inherited from OpenXmlElement.)
Public method RemoveAllChildren Remove all the child elements (Inherited from OpenXmlCompositeElement.)
Public method RemoveAnnotations(Type) Removes the annotations of the specified type from this OpenXmlElement. (Inherited from OpenXmlElement.)
Public method RemoveAnnotations<T>() Removes the annotations of the specified type from this OpenXmlElement. (Inherited from OpenXmlElement.)
Public method RemoveAttribute Remove the attribute from the element. (Inherited from OpenXmlElement.)
Public method RemoveChild<T>(T) Removes specified child element. (Inherited from OpenXmlCompositeElement.)
Public method RemoveChild<T>(T) Removes specified child element. (Inherited from OpenXmlElement.)
Public method RemoveNamespaceDeclaration Removes namespace declaration for a specific prefix. do nothing if the prefix is not existed. (Inherited from OpenXmlElement.)
Public method ReplaceChild<T>(OpenXmlElement, T) Replaces the child OpenXmlElement oldChild with newChild OpenXmlElement. (Inherited from OpenXmlCompositeElement.)
Public method ReplaceChild<T>(OpenXmlElement, T) Replaces the child OpenXmlElement oldChild with newChild OpenXmlElement. (Inherited from OpenXmlElement.)
Public method SetAttribute Set an attribute to the element. If the attribute is a known attribute, the value of the attribute is set. If the attribute is an extended attribute, the 'openxmlAttribute' is added to the extended attributes list. (Inherited from OpenXmlElement.)
Public method SetAttributes Set a bunch of attributes to the element. If a attribute is a known attribute, the value of the attribute is set. If a attribute is an extended attribute, the 'openxmlAttribute' is added to the extended attributes list. (Inherited from OpenXmlElement.)
Public method ToString (Inherited from Object.)
Public method WriteTo Saves the current node to the specified XmlWriter. (Inherited from OpenXmlElement.)

Top

Explicit Interface Implementations

  Name Description
Explicit interface implemetationPrivate method IEnumerable.GetEnumerator (Inherited from OpenXmlElement.)

Top

See Also

Reference

PivotField Class

DocumentFormat.OpenXml.Spreadsheet Namespace