Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.4 released

Developer's Guide

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 and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.