PivotField Members

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
	PivotField()	Initializes a new instance of the PivotField class.
	PivotField(String)	Initializes a new instance of the PivotField class from outer XML.
	PivotField(array<OpenXmlElement[])	Initializes a new instance of the PivotField class with the specified child elements.
	PivotField(IEnumerable<OpenXmlElement>)	Initializes a new instance of the PivotField class with the specified child elements.

Top

Properties

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

Top

Methods

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

Top

Explicit Interface Implementations

	Name	Description
	IEnumerable.GetEnumerator	(Inherited from OpenXmlElement.)

Top

See Also

Reference

PivotField Class

DocumentFormat.OpenXml.Spreadsheet Namespace