2.4.831 BrtTable
The BrtTable record specifies properties of a data table and specifies the beginning of a collection of records as defined by the Worksheet part ABNF (section 2.1.7.62) and the Macro Sheet (section 2.1.7.32) part ABNF. The collection of records specifies a one-variable data table or a two-variable data table.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
rfx (16 bytes) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
rwInput1 |
|||||||||||||||||||||||||||||||
|
colInput1 |
|||||||||||||||||||||||||||||||
|
rwInput2 |
|||||||||||||||||||||||||||||||
|
colInput2 |
|||||||||||||||||||||||||||||||
|
A |
B |
C |
D |
E |
F |
||||||||||||||||||||||||||
rfx (16 bytes): An RfX (section 2.5.118) that specifies the row and column (1) bounds of the cells in the data table. Every cell in the range specified by rfx MUST be a data table member. rfx.rwFirst MUST be greater than 0, and rfx.ColFirst MUST be greater than 0.
rwInput1 (4 bytes): An UncheckedRw (section 2.5.155) that specifies the row of the first input cell for the data table.
-
This field MUST be ignored if fDeleted1 is 1.
-
If fTable2 is 1, then rwInput1 and colInput1 MUST specify a cell outside the bounds specified by rfx.rwFirst – 1, rfx.rwLast, rfx.colFirst – 1, and rfx.colLast.
-
If fTable2 is 0, then exactly one of the following statements applies:
rwInput1 and colInput1 MUST specify a cell outside the bounds specified by rfx.rwFirst – 1, rfx.rwLast, rfx.colFirst – 1, and rfx.colLast.
rwInput1 and colInput1 MUST be equal to rfx.rwFirst -1 and rfx.colFirst – 1 respectively.
colInput1 (4 bytes): An UncheckedCol (section 2.5.153) that specifies the column (1) of the first input cell for the data table. This field MUST be ignored if fDeleted1 is 1.
rwInput2 (4 bytes): An UncheckedRw that specifies the row of the second input cell for a two-variable data table. rwInput2 and colInput2 MUST specify a cell outside the bounds specified by rfx.rwFirst – 1, rfx.rwLast, rfx.colFirst – 1, and rfx.colLast. This field MUST be ignored if fDeleted2 is 1 or if fTable2 is 0.
colInput2 (4 bytes): An UncheckedCol that specifies the column (1) of the second input cell for a two-variable data table. This field MUST be ignored if fDeleted2 is 1 or if fTable2 is 0.
A - fRow (1 bit): A bit that specifies whether the first input cell is a row input cell or a column (1) input cell. The value of this field MUST be one of the values specified in the following table.
-
Value
Meaning
0
The input cell is a column (1) input cell.
1
The input cell is a row input cell.
-
This value MUST be 1 if fTable2 is 1.
B - fTable2 (1 bit): A bit that specifies if the data table is a two-variable data table or a one-variable data table. This field MUST be one of the values specified in the following table.
-
Value
Meaning
0
This is a one-variable data table.
1
This is a two-variable data table.
C - fDeleted1 (1 bit): A bit that specifies whether the first input cell for the data table has been deleted.
D - fDeleted2 (1 bit): A bit that specifies whether the second input cell for a two-variable data table has been deleted. This value MUST be 0 if fTable2 is 0.
E - fAlwaysCalc (1 bit): A bit that specifies whether the data table formula (section 2.2.2) needs to be calculated as part of the next recalculation. This field MUST be one of the values from the following table.
-
Value
Meaning
0
The data table formula does not need to be calculated as part of the next recalculation.
1
The data table formula needs to be calculated as part of the next recalculation.
F - reserved (3 bits): This value MUST be 0 and MUST be ignored.