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 © 2012, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.