2.4.760 BrtRichFilterDateGroupItem
The BrtRichFilterDateGroupItem record specifies information about a criterion for a date filter associated with rich values.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
yr |
mon |
||||||||||||||||||||||||||||||
|
dom |
|||||||||||||||||||||||||||||||
|
hour |
min |
||||||||||||||||||||||||||||||
|
sec |
unused1 |
||||||||||||||||||||||||||||||
|
unused2 |
|||||||||||||||||||||||||||||||
|
dntChecked |
|||||||||||||||||||||||||||||||
|
key (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
yr (2 bytes): An unsigned integer that specifies the year for the filter. 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 filter. 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 filter. 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 filter. 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 filter. 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 filter. 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 values 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
key (variable): An XLWideString (section 2.5.169) that specifies the rich value key for which the filter is defined. This string MUST be less than or equal to 255 characters in length.