1*b1cdbd2cSJim Jagielski/************************************************************** 2*b1cdbd2cSJim Jagielski * 3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski * distributed with this work for additional information 6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski * 11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski * under the License. 19*b1cdbd2cSJim Jagielski * 20*b1cdbd2cSJim Jagielski *************************************************************/ 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim Jagielski 23*b1cdbd2cSJim Jagielski 24*b1cdbd2cSJim Jagielski#ifndef __com_sun_star_sheet_XDatabaseRange_idl__ 25*b1cdbd2cSJim Jagielski#define __com_sun_star_sheet_XDatabaseRange_idl__ 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski#ifndef __com_sun_star_uno_XInterface_idl__ 28*b1cdbd2cSJim Jagielski#include <com/sun/star/uno/XInterface.idl> 29*b1cdbd2cSJim Jagielski#endif 30*b1cdbd2cSJim Jagielski 31*b1cdbd2cSJim Jagielski#ifndef __com_sun_star_table_CellRangeAddress_idl__ 32*b1cdbd2cSJim Jagielski#include <com/sun/star/table/CellRangeAddress.idl> 33*b1cdbd2cSJim Jagielski#endif 34*b1cdbd2cSJim Jagielski 35*b1cdbd2cSJim Jagielski#ifndef __com_sun_star_beans_PropertyValue_idl__ 36*b1cdbd2cSJim Jagielski#include <com/sun/star/beans/PropertyValue.idl> 37*b1cdbd2cSJim Jagielski#endif 38*b1cdbd2cSJim Jagielski 39*b1cdbd2cSJim Jagielski#ifndef __com_sun_star_sheet_XSheetFilterDescriptor_idl__ 40*b1cdbd2cSJim Jagielski#include <com/sun/star/sheet/XSheetFilterDescriptor.idl> 41*b1cdbd2cSJim Jagielski#endif 42*b1cdbd2cSJim Jagielski 43*b1cdbd2cSJim Jagielski#ifndef __com_sun_star_sheet_XSubTotalDescriptor_idl__ 44*b1cdbd2cSJim Jagielski#include <com/sun/star/sheet/XSubTotalDescriptor.idl> 45*b1cdbd2cSJim Jagielski#endif 46*b1cdbd2cSJim Jagielski 47*b1cdbd2cSJim Jagielski//============================================================================= 48*b1cdbd2cSJim Jagielski 49*b1cdbd2cSJim Jagielskimodule com { module sun { module star { module sheet { 50*b1cdbd2cSJim Jagielski 51*b1cdbd2cSJim Jagielski//============================================================================= 52*b1cdbd2cSJim Jagielski 53*b1cdbd2cSJim Jagielski/** provides access to the settings and options of a database range. 54*b1cdbd2cSJim Jagielski 55*b1cdbd2cSJim Jagielski @see com::sun::star::sheet::DatabaseRange 56*b1cdbd2cSJim Jagielski */ 57*b1cdbd2cSJim Jagielskipublished interface XDatabaseRange: com::sun::star::uno::XInterface 58*b1cdbd2cSJim Jagielski{ 59*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 60*b1cdbd2cSJim Jagielski 61*b1cdbd2cSJim Jagielski /** returns the data area of the database range in the 62*b1cdbd2cSJim Jagielski spreadsheet document. 63*b1cdbd2cSJim Jagielski */ 64*b1cdbd2cSJim Jagielski com::sun::star::table::CellRangeAddress getDataArea(); 65*b1cdbd2cSJim Jagielski 66*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 67*b1cdbd2cSJim Jagielski 68*b1cdbd2cSJim Jagielski /** sets the data area of the database range. 69*b1cdbd2cSJim Jagielski */ 70*b1cdbd2cSJim Jagielski void setDataArea( [in] com::sun::star::table::CellRangeAddress aDataArea ); 71*b1cdbd2cSJim Jagielski 72*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 73*b1cdbd2cSJim Jagielski 74*b1cdbd2cSJim Jagielski /** returns the sort descriptor stored with the database range. 75*b1cdbd2cSJim Jagielski 76*b1cdbd2cSJim Jagielski @see SheetSortDescriptor2 77*b1cdbd2cSJim Jagielski */ 78*b1cdbd2cSJim Jagielski sequence< com::sun::star::beans::PropertyValue > getSortDescriptor(); 79*b1cdbd2cSJim Jagielski 80*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 81*b1cdbd2cSJim Jagielski 82*b1cdbd2cSJim Jagielski /** returns the filter descriptor stored with the database range. 83*b1cdbd2cSJim Jagielski 84*b1cdbd2cSJim Jagielski <p>If the filter descriptor is modified, the new filtering is 85*b1cdbd2cSJim Jagielski carried out when <member>XDatabaseRange::refresh()</member> is 86*b1cdbd2cSJim Jagielski called.</p> 87*b1cdbd2cSJim Jagielski 88*b1cdbd2cSJim Jagielski @see SheetFilterDescriptor 89*b1cdbd2cSJim Jagielski */ 90*b1cdbd2cSJim Jagielski XSheetFilterDescriptor getFilterDescriptor(); 91*b1cdbd2cSJim Jagielski 92*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 93*b1cdbd2cSJim Jagielski 94*b1cdbd2cSJim Jagielski /** returns the subtotal descriptor stored with the database range. 95*b1cdbd2cSJim Jagielski 96*b1cdbd2cSJim Jagielski <p>If the subtotal descriptor is modified, the new subtotals are 97*b1cdbd2cSJim Jagielski inserted when <member>XDatabaseRange::refresh()</member> is 98*b1cdbd2cSJim Jagielski called.</p> 99*b1cdbd2cSJim Jagielski 100*b1cdbd2cSJim Jagielski @see SubTotalDescriptor 101*b1cdbd2cSJim Jagielski */ 102*b1cdbd2cSJim Jagielski XSubTotalDescriptor getSubTotalDescriptor(); 103*b1cdbd2cSJim Jagielski 104*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 105*b1cdbd2cSJim Jagielski 106*b1cdbd2cSJim Jagielski /** returns the database import descriptor stored with this database 107*b1cdbd2cSJim Jagielski range. 108*b1cdbd2cSJim Jagielski 109*b1cdbd2cSJim Jagielski @see DatabaseImportDescriptor 110*b1cdbd2cSJim Jagielski */ 111*b1cdbd2cSJim Jagielski sequence< com::sun::star::beans::PropertyValue > getImportDescriptor(); 112*b1cdbd2cSJim Jagielski 113*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 114*b1cdbd2cSJim Jagielski 115*b1cdbd2cSJim Jagielski /** executes the stored import, filter, sorting, and subtotals 116*b1cdbd2cSJim Jagielski descriptors again. 117*b1cdbd2cSJim Jagielski */ 118*b1cdbd2cSJim Jagielski void refresh(); 119*b1cdbd2cSJim Jagielski 120*b1cdbd2cSJim Jagielski}; 121*b1cdbd2cSJim Jagielski 122*b1cdbd2cSJim Jagielski//============================================================================= 123*b1cdbd2cSJim Jagielski 124*b1cdbd2cSJim Jagielski}; }; }; }; 125*b1cdbd2cSJim Jagielski 126*b1cdbd2cSJim Jagielski#endif 127*b1cdbd2cSJim Jagielski 128