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 © 2011, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.