LibreOffice
LibreOffice 24.2 SDK API Reference
|
additional methods to extend com::sun::star::sheet::XDataPilotTable. More...
import"XDataPilotTable2.idl";
Public Member Functions | |
sequence< sequence< any > > | getDrillDownData ([in] com::sun::star::table::CellAddress aAddr) |
When the address of a cell within the result area is given, XDataPilotTable2::getDrillDownData() returns its drill-down output table that includes only those rows that contribute to the value of that cell. More... | |
DataPilotTablePositionData | getPositionData ([in] com::sun::star::table::CellAddress aAddr) |
Given a cell address, it returns the information about that cell. More... | |
void | insertDrillDownSheet ([in] com::sun::star::table::CellAddress aAddr) |
com::sun::star::table::CellRangeAddress | getOutputRangeByType ([in] long nType) raises (com::sun::star::lang::IllegalArgumentException) |
Public Member Functions inherited from XDataPilotTable | |
com::sun::star::table::CellRangeAddress | getOutputRange () |
returns the address of the cell range that contains the data pilot table. More... | |
void | refresh () |
recreates the data pilot table with current data from the source cell range. 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... | |
additional methods to extend com::sun::star::sheet::XDataPilotTable.
com::sun::star::sheet::XDataPilotTable2 extends the old com::sun::star::sheet::XDataPilotTable interface with additional methods.
sequence< sequence< any > > getDrillDownData | ( | [in] com::sun::star::table::CellAddress | aAddr | ) |
When the address of a cell within the result area is given, XDataPilotTable2::getDrillDownData() returns its drill-down output table that includes only those rows that contribute to the value of that cell.
aAddr | cell address within the result area of a DataPilot table. |
com::sun::star::table::CellRangeAddress getOutputRangeByType | ( | [in] long | nType | ) | |
raises | ( | com::sun::star::lang::IllegalArgumentException | |||
) |
This method returns a different output range of a DataPilot table per specified output range type.
DataPilotTablePositionData getPositionData | ( | [in] com::sun::star::table::CellAddress | aAddr | ) |
Given a cell address, it returns the information about that cell.
The type of information returned depends upon whether the cell is within the result area or column/row header area.
aAddr | address of the cell whose information is to be returned. |
void insertDrillDownSheet | ( | [in] com::sun::star::table::CellAddress | aAddr | ) |
This method inserts a new sheet to display the drill-down data for a specified result cell. A drill-down data for a result cell consists of a subset of rows from the original data source that contribute to the value displayed in that cell.
The new sheet is always inserted to the immediate left of the current sheet where the DataPilot table is. Note that when the drill-down data is empty, no new sheet is inserted.
aAddr | address of a result cell |