ARRAY: Array-Entered Formula (221h)

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)