BOOLERR: Cell Value, Boolean or Error (205h)

A BOOLERR record describes a cell that contains a constant Boolean or error value. The rw field contains the 0-based row number. The col field contains the 0-based column number.

Record Data

Offset

Name

Size

Contents

4

rw

2

Row

6

col

2

Column

8

ixfe

2

Index to the XF record

10

bBoolErr

1

Boolean value or error value

11

fError

1

Boolean/error flag


The bBoolErr field contains the Boolean or error value, as determined by the fError field. If the fError field contains a 0 (zero), the bBoolErr field contains a Boolean value; if the fError field contains a 1, the bBoolErr field contains an error value.

Boolean values are 1 for true and 0 for false.

Error values are listed in the following table.

Error value

Value (hex)

Value (dec.)

#NULL!

00h

0

#DIV/0!

07h

7

#VALUE!

0Fh

15

#REF!

17h

23

#NAME?

1Dh

29

#NUM!

24h

36

#N/A

2Ah

42