2.4.818 BrtSxFilter15
The BrtSxFilter15 record specifies additional information about a PivotTable (section 2.2.5) advanced filter (section 2.2.5.3.6.1) as specified by the SXFILTER rule (defined in section 2.1.7.40).
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
reserved |
||||||||||||||||||||||||||||||
A - fWholeDay (1 bit): A bit that specifies whether the PivotTable (section 2.2.5) advanced filter (section 2.2.5.3.6.1) extended by this record uses whole days in its filtering criteria. MUST be false if the value of the sxft field of the preceding BrtBeginSXFILTER (section 2.4.247) record is not equal to any of the values specified in Value column of the table that follows. MUST be true if the value of the irstName field of the preceding BrtBeginSXView (section 2.4.275) record is equal to the value of the name ([MS-XLSX] section 2.6.114) attribute of at least one CT_TimelineCachePivotTable ([MS-XLSX] section 2.6.114) element in the Timeline cache ([MS-XLSX] section 2.1.7) and the value of the sxft field of the preceding BrtBeginSXFILTER record is one of the values specified in Value column of the following table.
|
Category |
Value |
Meaning |
|---|---|---|
|
Date Filter |
0x0000001A |
"equals" filter for date values |
|
Date Filter |
0x0000001B |
"older than" filter for date values |
|
Date Filter |
0x0000001C |
"newer than" filter for date values |
|
Date Filter |
0x0000001D |
"between" filter for date values |
|
Date Filter |
0x0000001E |
"tomorrow" filter for date values |
|
Date Filter |
0x0000001F |
"today" filter for date values |
|
Date Filter |
0x00000020 |
"yesterday" filter for date values |
|
Date Filter |
0x00000021 |
"next week" filter for date values |
|
Date Filter |
0x00000022 |
"this week" filter for date values |
|
Date Filter |
0x00000023 |
"last week" filter for date values |
|
Date Filter |
0x00000024 |
"next month" filter for date values |
|
Date Filter |
0x00000025 |
"this month" filter for date values |
|
Date Filter |
0x00000026 |
"last month" filter for date values |
|
Date Filter |
0x00000027 |
"next quarter" filter for date values |
|
Date Filter |
0x00000028 |
"this quarter" filter for date values |
|
Date Filter |
0x00000029 |
"last quarter" filter for date values |
|
Date Filter |
0x0000002A |
"next year" filter for date values |
|
Date Filter |
0x0000002B |
"this year" filter for date values |
|
Date Filter |
0x0000002C |
"last year" filter for date values |
|
Date Filter |
0x0000002D |
"year-to-date" filter for date values |
|
Date Filter |
0x0000002E |
"first quarter" filter for date values |
|
Date Filter |
0x0000002F |
"second quarter" filter for date values |
|
Date Filter |
0x00000030 |
"third quarter" filter for date values |
|
Date Filter |
0x00000031 |
"fourth quarter" filter for date values |
|
Date Filter |
0x00000032 |
"January" filter for date values |
|
Date Filter |
0x00000033 |
"February" filter for date values |
|
Date Filter |
0x00000034 |
"March" filter for date values |
|
Date Filter |
0x00000035 |
"April" filter for date values |
|
Date Filter |
0x00000036 |
"May" filter for date values |
|
Date Filter |
0x00000037 |
"June" filter for date values |
|
Date Filter |
0x00000038 |
"July" filter for date values |
|
Date Filter |
0x00000039 |
"August" filter for date values |
|
Date Filter |
0x0000003A |
"September" filter for date values |
|
Date Filter |
0x0000003B |
"October" filter for date values |
|
Date Filter |
0x0000003C |
"November" filter for date values |
|
Date Filter |
0x0000003D |
"December" filter for date values |
|
Date Filter |
0x0000003E |
"not equal" filter for date values |
|
Date Filter |
0x0000003F |
"older than or equal to" filter for date values |
|
Date Filter |
0x00000040 |
"newer than or equal to" filter for date values |
|
Date Filter |
0x00000041 |
"not between" filter for date values |
reserved (7 bits): This value MUST be 0, and MUST be ignored.