- Description
- provides a method to apply a Multiple Operations Table to the
cell range.
- Developers Guide
Methods' Summary |
setTableOperation |
creates a table of formulas (a "Multiple Operations Table").
|
Methods' Details |
setTableOperation
- 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 .
|
|
Top of Page
Copyright © 2003 Sun Microsystems, Inc.
|