20 #ifndef __com_sun_star_sheet_XConsolidationDescriptor_idl__
21 #define __com_sun_star_sheet_XConsolidationDescriptor_idl__
29 module
com { module sun { module star { module sheet {
53 sequence< com::sun::star::table::CellRangeAddress >
getSources();
59 [in] sequence< com::sun::star::table::CellRangeAddress > aSources );
provides access to the settings of a consolidation descriptor.
Definition: XConsolidationDescriptor.idl:39
boolean getUseRowHeaders()
returns, whether row headers from the cell ranges are used to find matching data or not.
boolean getUseColumnHeaders()
returns, whether column headers from the cell ranges are used to find matching data or not.
void setSources([in] sequence< com::sun::star::table::CellRangeAddress > aSources)
sets the cell ranges which are consolidated.
void setStartOutputPosition([in] com::sun::star::table::CellAddress aStartOutputPosition)
sets the position of the top left cell of the cell range where the consolidated data are copied.
void setFunction([in] com::sun::star::sheet::GeneralFunction nFunction)
sets the function by which the ranges are consolidated.
com::sun::star::sheet::GeneralFunction getFunction()
returns the function by which the ranges are consolidated.
void setInsertLinks([in] boolean bInsertLinks)
specifies if links to the original data are inserted in the output area.
void setUseColumnHeaders([in] boolean bUseColumnHeaders)
specifies if column headers from the cell ranges are used to find matching data.
sequence< com::sun::star::table::CellRangeAddress > getSources()
returns the cell ranges which are consolidated.
com::sun::star::table::CellAddress getStartOutputPosition()
returns the position of the top left cell of the cell range where the consolidated data are copied.
void setUseRowHeaders([in] boolean bUseRowHeaders)
specifies if row headers from the cell ranges are used to find matching data.
boolean getInsertLinks()
returns, whether links to the original data are inserted in the output area or not.
base interface of all UNO interfaces
Definition: XInterface.idl:48
GeneralFunction
used to specify a function to be calculated from values.
Definition: GeneralFunction.idl:30
Definition: Ambiguous.idl:22
contains a cell address within a spreadsheet document.
Definition: CellAddress.idl:30