- Description
- creates a table of formulas (a "Multiple Operations Table").
The specified formulas are repeated, with references to the
specified cells replaced by references to values in the first
column and/or row of the range.
- Parameter aFormulaRange
- the range that contains formula cells (modes
TableOperationMode::ROW or
TableOperationMode::COLUMN) or a single formula
cell (mode TableOperationMode::BOTH).
- Parameter nMode
- specifies the calculation mode to fill the cells.
- Parameter aColumnCell
- contains the address of the cell that is referenced by
formulas in a row (mode TableOperationMode::ROW)
or by the formula cell used for two value series (mode
TableOperationMode::BOTH). This parameter is not
used if mode is TableOperationMode::COLUMN.
- Parameter aRowCell
- contains the address of the cell that is referenced by
formulas in a column (mode TableOperationMode::COLUMN)
or by the formula cell used for two value series (mode
TableOperationMode::BOTH). This parameter is not
used if mode is TableOperationMode::ROW.
|