2.4.35 ST_enmAutoFilterItemCriteriaType
Referenced by: CT_item
This enumeration defines a set of filters. Each set of filters can be applied to either dates or numbers. It is applied to the CriteriaType attribute (2) in an item.
The following table shows the enumeration values for this type.
Value |
Meaning |
---|---|
Nil |
|
AboveAverage |
Number filter in which all worksheet cell values except those above the average of the worksheet cell values being filtered are filtered out. |
BelowAverage |
Number filter in which all worksheet cell values except those below the average of the worksheet cell values being filtered are filtered out. |
Tomorrow |
Date filter in which all worksheet cell values except those with the date for the following day are filtered out. |
Today |
Date filter in which all worksheet cell values except those with the date for today are filtered out. |
Yesterday |
Date filter in which all worksheet cell values except those with the date for the previous day are filtered out. |
NextWeek |
Date filter in which all worksheet cell values except those in the following week are filtered out. |
ThisWeek |
Date filter in which all worksheet cell values except those in the current week are filtered out. |
LastWeek |
Date filter in which all worksheet cell values except those in the previous week are filtered out. |
NextMonth |
Date filter in which all worksheet cell values except those in the following month are filtered out. |
ThisMonth |
Date filter in which all worksheet cell values except those in the current month are filtered out. |
LastMonth |
Date filter in which all worksheet cell values except those in the previous month are filtered out. |
NextQuarter |
Date filter in which all worksheet cell values except those in the following quarter are filtered out. |
ThisQuarter |
Date filter in which all worksheet cell values except those in the current quarter are filtered out. |
LastQuarter |
Date filter in which all worksheet cell values except those in the previous quarter are filtered out. |
NextYear |
Date filter in which all worksheet cell values except those in the following year are filtered out. |
ThisYear |
Date filter in which all worksheet cell values except those in the current year are filtered out. |
LastYear |
Date filter in which all worksheet cell values except those in the previous year are filtered out. |
YearToDate |
Date filter in which all worksheet cell values except those in the current year up to and inclusive of the current date are filtered out. |
Q1 |
Date filter in which all worksheet cell values except those in the first quarter of the current year are filtered out. |
Q2 |
Date filter in which all worksheet cell values except those in the second quarter of the current year are filtered out. |
Q3 |
Date filter in which all worksheet cell values except those in the third quarter of the current year are filtered out. |
Q4 |
Date filter in which all worksheet cell values except those in the fourth quarter of the current year are filtered out. |
M1 |
Date filter in which all worksheet cell values except those in the month of January are filtered out. |
M2 |
Date filter in which all worksheet cell values except those in the month of February are filtered out. |
M3 |
Date filter in which all worksheet cell values except those in the month of March are filtered out. |
M4 |
Date filter in which all worksheet cell values except those in the month of April are filtered out. |
M5 |
Date filter in which all worksheet cell values except those in the month of May are filtered out. |
M6 |
Date filter in which all worksheet cell values except those in the month of June are filtered out. |
M7 |
Date filter in which all worksheet cell values except those in the month of July are filtered out. |
M8 |
Date filter in which all worksheet cell values except those in the month of August are filtered out. |
M9 |
Date filter in which all worksheet cell values except those in the month of September are filtered out. |
M10 |
Date filter in which all worksheet cell values except those in the month of October are filtered out. |
M11 |
Date filter in which all worksheet cell values except those in the month of November are filtered out. |
M12 |
Date filter in which all worksheet cell values except those in the month of December are filtered out. |
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this simple type.
-
<xs:simpleType name="ST_enmAutoFilterItemCriteriaType"> <xs:restriction base="xs:string"> <xs:enumeration value="Nil"/> <xs:enumeration value="AboveAverage"/> <xs:enumeration value="BelowAverage"/> <xs:enumeration value="Tomorrow"/> <xs:enumeration value="Today"/> <xs:enumeration value="Yesterday"/> <xs:enumeration value="NextWeek"/> <xs:enumeration value="ThisWeek"/> <xs:enumeration value="LastWeek"/> <xs:enumeration value="NextMonth"/> <xs:enumeration value="ThisMonth"/> <xs:enumeration value="LastMonth"/> <xs:enumeration value="NextQuarter"/> <xs:enumeration value="ThisQuarter"/> <xs:enumeration value="LastQuarter"/> <xs:enumeration value="NextYear"/> <xs:enumeration value="ThisYear"/> <xs:enumeration value="LastYear"/> <xs:enumeration value="YearToDate"/> <xs:enumeration value="Q1"/> <xs:enumeration value="Q2"/> <xs:enumeration value="Q3"/> <xs:enumeration value="Q4"/> <xs:enumeration value="M1"/> <xs:enumeration value="M2"/> <xs:enumeration value="M3"/> <xs:enumeration value="M4"/> <xs:enumeration value="M5"/> <xs:enumeration value="M6"/> <xs:enumeration value="M7"/> <xs:enumeration value="M8"/> <xs:enumeration value="M9"/> <xs:enumeration value="M10"/> <xs:enumeration value="M11"/> <xs:enumeration value="M12"/> </xs:restriction> </xs:simpleType>
See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).