An ARRAY record describes a formula that was array-entered into a range of cells. The range of cells in which the array is entered is defined by the rwFirst, rwLast, colFirst, and colLast fields.
The ARRAY record occurs directly after the FORMULA record for the cell in the upper-left corner of the array — that is, the cell defined by the rwFirst and colFirst fields.
The parsed expression is the array formula, stored in the Microsoft Excel internal format. For an explanation of the parsed format, see "Microsoft Excel Formulas" on page 444.
Record Data
|
Offset |
Name |
Size |
Contents |
|
4 |
rwFirst |
2 |
First row of the array |
|
6 |
rwLast |
2 |
Last row of the array |
|
8 |
colFirst |
1 |
First column of the array |
|
9 |
colLast |
1 |
Last column of the array |
|
10 |
grbit |
2 |
Option flags |
|
12 |
chn |
4 |
(See text) |
|
16 |
cce |
2 |
Length of the parsed expression |
|
18 |
rgce |
var |
Parsed expression |
You should ignore the chn field when you read the BIFF file. If you write a BIFF file, the chn field must be 00000000h.
The grbit field contains the option flags listed in the following table.
|
Offset |
Bits |
Mask |
Name |
Contents |
|
0 |
0 |
01h |
fAlwaysCalc |
Always calculate the formula. |
|
1 |
02h |
fCalcOnLoad |
Calculate the formula when the file is opened. | |
|
7–2 |
FCh |
(unused) | ||
|
1 |
7–0 |
FFh |
(unused) | |