TABLE: Data Table (236h)

A TABLE record describes a data table created with the Table command (Data menu).

Record Data

Offset

Name

Size

Contents

4

rwFirst

2

First row of the table

6

rwLast

2

Last row of the table

8

colFirst

1

First column of the table

9

colLast

1

Last column of the table

10

grbit

2

Option flags

12

rwInpRw

2

Row of the row input cell

14

colInpRw

2

Column of the row input cell

16

rwInpCol

2

Row of the column input cell

18

colInpCol

2

Column of the column input cell


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.

2

04h

fRw

= 1 input cell is a row input cell.
= 0 input cell is a column input cell.

3

08h

fTbl2

= 1 if two-input data table.
= 0 if one-input data table.

7–4

F0h

(Unused)

1

7–0

FFh

(Unused)


The area (range of cells) in which the table is entered is defined by the rwFirst, rwLast, colFirst, and colLast fields. This area is the interior of the table and does not include the outer row or column (these contain the table formulas and/or input values).

In cases where the input cell is a deleted reference (the cell displays #REF!), the rwInp field is –1. The colInp field is not used in this case.