2.4.5 BrtAFilterDateGroupItem
The BrtAFilterDateGroupItem record specifies information about a criterion for a date AutoFilter.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
yr |
mon |
||||||||||||||||||||||||||||||
|
dom |
|||||||||||||||||||||||||||||||
|
hour |
min |
||||||||||||||||||||||||||||||
|
sec |
unused1 |
||||||||||||||||||||||||||||||
|
unused2 |
|||||||||||||||||||||||||||||||
|
dntChecked |
|||||||||||||||||||||||||||||||
yr (2 bytes): An unsigned integer that specifies the year for the AutoFilter. This value MUST be greater than or equal to 1000 and less than or equal to 9999.
mon (2 bytes): An unsigned integer that specifies the month for the AutoFilter. If dntChecked is greater than or equal to 0x00000001, this value MUST be greater than or equal to 1 and less than or equal to 12.
dom (4 bytes): An unsigned integer that specifies the day of the month for the AutoFilter. If dntChecked is greater than or equal to 0x00000002, this value MUST be greater than or equal to 1 and less than or equal to 31.
hour (2 bytes): An unsigned integer that specifies the hour for the AutoFilter. If dntChecked is greater than or equal to 0x00000003, this value MUST be less than or equal to 23.
min (2 bytes): An unsigned integer that specifies the minute for the AutoFilter. If dntChecked is greater than or equal to 0x00000004, this value MUST be less than or equal to 59.
sec (2 bytes): An unsigned integer that specifies the second for the AutoFilter. If dntChecked is equal to 0x00000005, this value MUST be less than or equal to 59.
unused1 (2 bytes): Undefined, and MUST be ignored.
unused2 (4 bytes): Undefined, and MUST be ignored.
dntChecked (4 bytes): An unsigned integer that specifies what comparisons are made to determine if a cell is displayed. For example, if this value is equal to DNTMONTH, only cells with the same year and month specified in this record are displayed. dntChecked MUST be equal to a value from the following table.
|
Name |
Value |
Meaning |
|---|---|---|
|
DNTYEAR |
0x00000000 |
Group by year |
|
DNTMONTH |
0x00000001 |
Group by month and year |
|
DNTDAY |
0x00000002 |
Group by day, month, and year |
|
DNTHOUR |
0x00000003 |
Group by hour, day, month, and year |
|
DNTMINUTE |
0x00000004 |
Group by minute, hour, day, month, and year |
|
DNTSECOND |
0x00000005 |
Group by second, minute, hour, day, month, and year |