provides a method to apply a Multiple Operations Table to the cell range. More...
import"XMultipleOperation.idl";
Inheritance diagram for XMultipleOperation:
Public Member Functions | |
| void | setTableOperation ([in] com::sun::star::table::CellRangeAddress aFormulaRange, [in] com::sun::star::sheet::TableOperationMode nMode, [in] com::sun::star::table::CellAddress aColumnCell, [in] com::sun::star::table::CellAddress aRowCell) |
| creates a table of formulas (a "Multiple Operations Table"). More... | |
 Public Member Functions inherited from XInterface | |
| any | queryInterface ([in] type aType) |
| queries for a new interface to an existing UNO object. More... | |
| void | acquire () |
| increases the reference counter by one. More... | |
| void | release () |
| decreases the reference counter by one. More... | |
Detailed Description
provides a method to apply a Multiple Operations Table to the cell range.
- Developers Guide
- Spreadsheet Documents - Multiple Operations
Member Function Documentation
◆ setTableOperation()
| void setTableOperation | ( | [in] com::sun::star::table::CellRangeAddress | aFormulaRange, |
| [in] com::sun::star::sheet::TableOperationMode | nMode, | ||
| [in] com::sun::star::table::CellAddress | aColumnCell, | ||
| [in] com::sun::star::table::CellAddress | aRowCell | ||
| ) |
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.
- Parameters
-
aFormulaRange the range that contains formula cells (modes TableOperationMode::ROW or TableOperationMode::COLUMN) or a single formula cell (mode TableOperationMode::BOTH). nMode specifies the calculation mode to fill the cells. 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. 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.
The documentation for this interface was generated from the following file:
- com/sun/star/sheet/XMultipleOperation.idl
