Share via

2.4.48 BrtBeginDCon

  • Article

The BrtBeginDCon record specifies data consolidation properties and specifies the beginning of a collection of records as defined by the Worksheet (section 2.1.7.62) part ABNF and the Macro Sheet (section 2.1.7.32) part ABNF. The collection of records specifies data consolidation information.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

iiftab

A

B

C

unused

iiftab (1 byte): An IIFtab (section 2.5.79) that specifies the data consolidation function that is used.

A - fLeftCat (1 bit): A bit that specifies whether the values in the left column (1) of the data consolidation range will be treated as labels or data. The following table specifies the meaning of each value.

Value

Meaning

0

Treat the left column (1) of the data consolidation range as data that will be operated on by the data consolidation function specified by iiftab.

1

Treat the left column (1) of the data consolidation range as labels that will be used to identify the rows operated on by the data consolidation function.

B - fTopCat (1 bit): A bit that specifies whether the values in the top row of the data consolidation range will be treated as labels or data. The following table specifies the meaning of each value.

Value

Meaning

0

Treat the top row of the data consolidation range as data that will be operated on by the data consolidation function specified by iiftab.

1

Treat the top row of the data consolidation range as labels that will be used to identify the columns (1) operated on by the data consolidation function.

C - fLinkConsol (1 bit): A bit that specifies whether data consolidation will create references to the source data. The following table specifies the meaning of each value.

Value

Meaning

0

References are not created to the source data.

1

References are created to the source data.

unused (5 bits): Undefined and MUST be ignored.