Use the EditTableCell command to insert formulas
and change the data type of
cells.
To insert
formulas using the EditTableCell command:
-
Type
EditTableCell at the command prompt.
-
In the graphics area, specify a table.
-
At the command prompt, specify the cell in which to insert the
formula in the format:
An, where A stands for the
column indicator(s) and n stands for row number(s).
-
Specify the Formula option.
-
Use the following options to insert a formula in the specified
cell:
- Sum,
Average, or Count
inserts a formula in a specified cell.
To specify
a cell range:
- In the graphics area, click inside the
first cell of the range. Then click in the last cell of
the range.
The formula appears
containing the specified range as its
argument.
- Press Enter to
calculate its result.
- Cell. Inserts the selected
cell identifier in the formula cell.
- Specify the Cell
option.
- In the graphics area, click inside a cell.
The identifier of the specified cell
appears in the formula cell.
- Press Enter to
calculate the result.
Use the
Cell option to select a cell
in another table within the same drawing.
- Equation. Switches the
formula cell to editing mode and the equal (=) sign appears.
- Type the equation
- Press Enter to
calculate the result.
- Exit. Exits formula
options.
-
Repeat step 5 as needed.
-
Specify Exit to close the command.
-
To change the data type of cells:
-
Type
EditTableCell at the command prompt.
-
In the graphics area, specify a table.
-
At the command prompt, specify the cell in which to
insert the formula in the format:
An, where A stands for
the column indicator(s) and n stands for row
number(s).
-
Specify the Datatype option.
Then specify a data type such as Angle,
Currency, Date,
Decimal number,
General, Note,
Percentage, Point, and
Whole Number.
-
Specify Exit to exit the data
type selection and specify Exit again to close
the command.