LibreOffice
LibreOffice 6.4 SDK API Reference
Public Member Functions | List of all members
XMultipleOperation Interface Referencepublished

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"). 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
Spreadsheets - 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
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 file: