Export (0) Print
Expand All

PivotFilter class

Office 2013

Defines the PivotFilter Class.This class is only available in Office2013. When the object is serialized out as xml, its qualified name is x15:pivotFilter.

Namespace:  DocumentFormat.OpenXml.Office2013.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

[OfficeAvailabilityAttribute(FileFormatVersions.Office2013)]
public class PivotFilter : OpenXmlLeafElement

2.4.46 pivotFilter

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

A CT_PivotFilter element that specifies the extended properties of a filter (PivotTable Advanced Filter), as specified in ([ISO/IEC-29500-1] section 18.10.1.33).<23> See section 2.2.4.4 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC-29500-1].

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

<xsd:element name="pivotFilter" type="CT_PivotFilter"/>

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

2.6.95 CT_PivotFilter

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: pivotFilter

A complex type that specifies the extended properties of a CT_PivotFilter ([ISO/IEC-29500-4] section A.2) element.<71>

Attributes:

useWholeDay: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the filter ([ISO/IEC-29500-1] section 18.10.1.33) element extended by this type uses whole days in its filtering criteria. MUST be false for filters for which the value of the attribute type ([ISO/IEC-29500-1] section 18.10.1.33) is not one of the values mentioned in the table below. MUST be true if the value of the name attribute of the containing CT_PivotTableDefinition ([ISO/IEC-29500-4] section A.2) element is equal to the value of the name (section 2.6.114) attribute of at least one CT_ TimelineCachePivotTable (section 2.6.114) element in the Timeline cache (section 2.1.7) and the value of the attribute type of the containing filter element is one of the following.

Enumeration Value

dateBetween (Date Between)

dateEqual (Date Equals)

dateNewerThan (Date Newer Than)

dateNewerThanOrEqual (Date Newer Than or Equal To)

dateNotBetween (Date Not Between)

dateNotEqual (Date Does Not Equal)

dateOlderThan (Date Older Than)

dateOlderThanOrEqual (Date Older Than Or Equal)

lastMonth (Last Month)

lastQuarter (Last Quarter)

lastWeek (Last Week)

lastYear (Last Year)

M1 (Dates in January)

M10 (Dates in October)

M11 (Dates in November)

M12 (Dates in December)

M2 (Dates in February)

M3 (Dates in March)

M4 (Dates in April)

M5 (Dates in May)

M6 (Dates in June)

M7 (Dates in July)

M8 (Dates in August)

M9 (Dates in September)

nextMonth (Next Month)

nextQuarter (Next Quarter)

nextWeek (Next Week)

nextYear (Next Year)

percent (Percent)

Q1 (First Quarter)

Q2 (Second Quarter)

Q3 (Third Quarter)

Q4 (Fourth Quarter)

sum (Sum)

thisMonth (This Month)

thisQuarter (This Quarter)

thisWeek (This Week)

thisYear (This Year)

today (Today)

tomorrow (Tomorrow)

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

<xsd:complexType name="CT_PivotFilter">

<xsd:attribute name="useWholeDay" type="xsd:boolean" use="required"/>

</xsd:complexType>

See section 5.3 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.
Show:
© 2015 Microsoft