2.4.84 BrtBeginFilterColumn
The BrtBeginFilterColumn record specifies properties of an AutoFilter column (1) and specifies the beginning of a collection of records as defined by the Macro Sheet (section 2.1.7.32) part ABNF, the PivotTable (section 2.1.7.40) part ABNF, the Table (section 2.1.7.51) part ABNF, and the Worksheet (section 2.1.7.62) part ABNF. The collection of records specifies an AutoFilter column (1).
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
dwCol |
|||||||||||||||||||||||||||||||
|
A |
B |
reserved |
|||||||||||||||||||||||||||||
dwCol (4 bytes): An UncheckedCol (section 2.5.153) that specifies a zero-based index to the column (1) in the AutoFilter range to which this filter information applies. This value MUST be greater than or equal to 0 and less than or equal to the number of columns (1) in the region described by the rfx value in the BrtBeginAFilter (section 2.4.8) record associated with this BrtBeginFilterColumn record.
A - fHideArrow (1 bit): A bit that specifies whether the AutoFilter button for this column (1) is hidden.
B - fNoBtn (1 bit): A bit that specifies whether the AutoFilter button for this column (1) will appear in the next column (1) after this one. This value MUST be one of the values listed in the following table:
|
Value |
Meaning |
|---|---|
|
0 |
The AutoFilter button for this column (1) will not appear in the next column (1) after this one |
|
1 |
The AutoFilter button for this column (1) will appear in the next column (1) after this one, replacing any filter button in that cell. If the value in the fHideArrow field is equal to 1, the button will appear in the next column (1) but the user will not be able to interact with it. |
reserved (14 bits): This value MUST be 0, and MUST be ignored.