2011

TABLE
Creates an empty table object.
TABLEDIT
Edits text in a table cell.
TABLEEXPORT
Exports data from a table object in CSV file format.
TABLESTYLE
Creates, modifies, or specifies table styles.
UPDATEFIELD
CTABLESTYLE
Sets the name of the current table style.
FIELDDISPLAY
Controls whether fields are displayed with a gray background.
FIELDEVAL
Controls how fields are updated.
Use Formulas in Table Cells
Table cells can contain formulas that do calculations using the values in other
table cells.
With a table cell selected, you can insert formulas from the Table toolbar as
well as the shortcut menu. You can also open the In-Place Text Editor and
enter a formula in a table cell manually.
Insert a Formula
In formulas, cells are referred to by their column letter and row number. For
example, the cell at top left in the table is A1. Merged cells use the number
of what would be the top-left cell. A range of cells is defined by the first and
last cells, with a colon between them. For example, the range A5:C10 includes
cells in rows 5 through 10 in columns A, B, and C.
A formula must start with an equal sign (=). The formulas for sum, average,
and count ignore empty cells and cells that do not resolve to a numeric value.
Other formulas display an error (#) if any cell in the arithmetic expression is
empty or contains nonnumeric data.
Use Formulas in Table Cells | 949