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 |