offapi/com/sun/star/sheet/XDataPilotTable2.idl

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   2 /**
   3  * This file is part of the LibreOffice project.
   4  *
   5  * This Source Code Form is subject to the terms of the Mozilla Public
   6  * License, v. 2.0. If a copy of the MPL was not distributed with this
   7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   8  *
   9  * This file incorporates work covered by the following license notice:
  10  *
  11  *   Licensed to the Apache Software Foundation (ASF) under one or more
  12  *   contributor license agreements. See the NOTICE file distributed
  13  *   with this work for additional information regarding copyright
  14  *   ownership. The ASF licenses this file to you under the Apache
  15  *   License, Version 2.0 (the "License"); you may not use this file
  16  *   except in compliance with the License. You may obtain a copy of
  17  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  18  */
  19
  20 #ifndef __com_sun_star_sheet_XDataPilotTable2_idl__
  21 #define __com_sun_star_sheet_XDataPilotTable2_idl__
  22
  23 #include <com/sun/star/uno/XInterface.idl>
  24 #include <com/sun/star/table/CellAddress.idl>
  25 #include <com/sun/star/table/CellRangeAddress.idl>
  26 #include <com/sun/star/sheet/XDataPilotTable.idl>
  27 #include <com/sun/star/sheet/DataPilotOutputRangeType.idl>
  28 #include <com/sun/star/sheet/DataPilotFieldFilter.idl>
  29 #include <com/sun/star/sheet/DataPilotTablePositionData.idl>
  30 #include <com/sun/star/lang/IllegalArgumentException.idl>
  31
  32 module com {  module sun {  module star {  module sheet {
  33
  34 /** additional methods to extend <type scope="com::sun::star::sheet">XDataPilotTable</type>.
  35
  36    <type scope="com::sun::star::sheet">XDataPilotTable2</type> extends the old
  37    <type scope="com::sun::star::sheet">XDataPilotTable</type> interface with
  38    additional methods.
  39
  40    @see com::sun::star::sheet::XDataPilotTable
  41
  42    @since OOo 3.0
  43  */
  44 interface XDataPilotTable2: com::sun::star::sheet::XDataPilotTable
  45 {
  46     /** When the address of a cell within the result area is given,
  47         <method>XDataPilotTable2::getDrillDownData</method> returns its drill-down
  48         output table that includes only those rows that contribute to the value of
  49         that cell.
  50
  51         @param aAddr cell address within the result area of a DataPilot table.
  52
  53         @returns drill-down output as 2-dimensional sequence, including the header row.
  54
  55         @see <method>XDataPilotTable2::insertDrillDownSheet</method>
  56      */
  57     sequence< sequence< any > > getDrillDownData( [in] com::sun::star::table::CellAddress aAddr );
  58
  59     /** Given a cell address, it returns the information about that cell.  The
  60         type of information returned depends upon whether the cell is within
  61         the result area or column/row header area.
  62
  63         @param aAddr address of the cell whose information is to be returned.
  64
  65         @returns <type>DataPilotTablePositionData</type> which contains the
  66         position type and the information for that cell position.
  67
  68         @see com::sun::star::sheet::DataPilotTablePositionData
  69         @see com::sun::star::sheet::DataPilotTableHeaderData
  70         @see com::sun::star::sheet::DataPilotTableResultData
  71      */
  72     DataPilotTablePositionData getPositionData( [in] com::sun::star::table::CellAddress aAddr );
  73
  74     /** <p>This method inserts a new sheet to display the drill-down data for a
  75         specified result cell.  A drill-down data for a result cell consists
  76         of a subset of rows from the original data source that contribute to
  77         the value displayed in that cell.</p>
  78
  79         <p>The new sheet is always inserted to the immediate left of the current
  80         sheet where the DataPilot table is.  Note that when the drill-down data
  81         is empty, no new sheet is inserted.</p>
  82
  83         @param aAddr address of a result cell
  84
  85         @returns <void/>
  86      */
  87     void insertDrillDownSheet( [in] com::sun::star::table::CellAddress aAddr );
  88
  89     /** <p>This method returns a different output range of a DataPilot table
  90         per specified output range type.</p>
  91
  92         @returns <type scope="com::sun::star::table">CellRangeAddress</type> depicting
  93         the range specified.  See <type>DataPilotOutputRangeType</type> for a set
  94         of possible output range types.
  95
  96         @see com::sun::star::sheet::DataPilotOutputRangeType
  97      */
  98     com::sun::star::table::CellRangeAddress getOutputRangeByType( [in] long nType )
  99         raises (com::sun::star::lang::IllegalArgumentException);
 100 };
 101
 102 }; }; }; };
 103
 104 #endif
 105
 106 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */