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.
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.
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.
Parameter aAddr
cell address within the result area of a DataPilot table.
Returns
drill-down output as 2-dimensional sequence, including the header row.
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.
Parameter aAddr
address of the cell whose information is to be returned.
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.
