Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.11

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: com :: sun :: star :: sheet ::

interface XMultipleOperation
Description
provides a method to apply a Multiple Operations Table to the cell range.
Developers Guide
Spreadsheets - Multiple Operations

Methods' Summary
setTableOperation creates a table of formulas (a "Multiple Operations Table").  
Methods' Details
setTableOperation
void
setTableOperation( [in] ::com::sun::star::table::CellRangeAddress  aFormulaRange,
[in] TableOperationMode  nMode,
[in] ::com::sun::star::table::CellAddress  aColumnCell,
[in] ::com::sun::star::table::CellAddress  aRowCell );

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

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.