Cell Records

The term "cell records" refers to the BIFF record types that actually contain cell data. Cell records that appear in BIFF5/BIFF7/BIFF8 files are shown in the following table.

Record

Contents

ARRAY

An array-entered formula

BLANK

An empty cell

BOOLERR

A Boolean or error value

FORMULA

A cell formula, stored as parse tokens

LABEL

A string constant

LABELSST

String constant that uses BIFF8 shared string table (new to BIFF8)

NUMBER

An IEEE floating-point number

MULBLANK

Multiple empty cells (new to BIFF5)

MULRK

Multiple RK numbers (new to BIFF5)

RK

An RK number

RSTRING

Cell with character formatting

SHRFMLA

A shared formula (new to BIFF5)

STRING

A string that represents the result of a formula


Microsoft Excel stores cell records in blocks that have at most 32 rows. Each row that contains cell records has a corresponding ROW record in the block, and each block contains a DBCELL record at the end of the block. For more information about row blocks and about optimizing your code when searching for cell records, see "Finding Cell Records in BIFF Files" on page 440.