PivotFilters Class
Filters.When the object is serialized out as xml, its qualified name is x:filters.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.PivotFilters
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(PivotFilter))> _
Public Class PivotFilters _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As PivotFilters
[ChildElementInfoAttribute(typeof(PivotFilter))]
public class PivotFilters : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
- PivotFilter <x:filter>
[ISO/IEC 29500-1 1st Edition]
18.10.1.34 filters (Filters)
Represents the collection of filters that apply to this PivotTable.
[Example:
<sh:filters count="1">
<sh:filter fld="3" type="count" id="1" iMeasureHier="187">
<sh:autoFilter ref="A1">
<sh:filterColumn colId="0">
<sh:top10 val="5"/>
</sh:filterColumn>
</sh:autoFilter>
</sh:filter>
</sh:filters>
end example]
Parent Elements |
|---|
pivotTableDefinition (§18.10.1.73) |
Child Elements |
Subclause |
|---|---|
filter (PivotTable Advanced Filter) |
§18.10.1.33 |
Attributes |
Description |
|---|---|
count (Pivot Filter Count) |
Specifies the number of pivot filters in the collection. 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_PivotFilters) 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.