LibreOffice
LibreOffice 24.2 SDK API Reference
Loading...
Searching...
No Matches
XMultipleOperation Interface Reference

provides a method to apply a Multiple Operations Table to the cell range. More...

import <XMultipleOperation.idl;

Inheritance diagram for XMultipleOperation:
XInterface SheetCellRange SheetCellCursor Spreadsheet

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").
 
- Public Member Functions inherited from XInterface
any queryInterface ([in] type aType)
 queries for a new interface to an existing UNO object.
 
void acquire ()
 increases the reference counter by one.
 
void release ()
 decreases the reference counter by one.
 

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()

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
aFormulaRangethe range that contains formula cells (modes TableOperationMode::ROW or TableOperationMode::COLUMN) or a single formula cell (mode TableOperationMode::BOTH).
nModespecifies the calculation mode to fill the cells.
aColumnCellcontains 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.
aRowCellcontains 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 files: