diff -uPr offapi.old/com/sun/star/sheet/XDatabaseRange2.idl offapi.new/com/sun/star/sheet/XDatabaseRange2.idl --- offapi.old/com/sun/star/sheet/XDatabaseRange2.idl 1970-01-01 08:00:00.000000000 +0800 +++ offapi.new/com/sun/star/sheet/XDatabaseRange2.idl 2008-03-11 15:36:44.000000000 +0800 @@ -0,0 +1,135 @@ +/************************************************************************* + * + * OpenOffice.org - a multi-platform office productivity suite + * + * $RCSfile: XDatabaseRange.idl,v $ + * + * $Revision: 1.9 $ + * + * last change: $Author: rt $ $Date: 2005/09/08 05:08:15 $ + * + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. + * + * + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. + * + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA + * + ************************************************************************/ + +#ifndef __com_sun_star_sheet_XDatabaseRange2_idl__ +#define __com_sun_star_sheet_XDatabaseRange2_idl__ + +#ifndef __com_sun_star_uno_XInterface_idl__ +#include +#endif + +#ifndef __com_sun_star_table_CellRangeAddress_idl__ +#include +#endif + +#ifndef __com_sun_star_beans_PropertyValue_idl__ +#include +#endif + +#ifndef __com_sun_star_sheet_XSheetFilterDescriptor2_idl__ +#include +#endif + +#ifndef __com_sun_star_sheet_XSubTotalDescriptor_idl__ +#include +#endif + +//============================================================================= + +module com { module sun { module star { module sheet { + +//============================================================================= + +/** provides access to the settings and options of a database range. + + @see com::sun::star::sheet::DatabaseRange + */ +published interface XDatabaseRange2: com::sun::star::uno::XInterface +{ + //------------------------------------------------------------------------- + + /** returns the data area of the database range in the + spreadsheet document. + */ + com::sun::star::table::CellRangeAddress getDataArea(); + + //------------------------------------------------------------------------- + + /** sets the data area of the database range. + */ + void setDataArea( [in] com::sun::star::table::CellRangeAddress aDataArea ); + + //------------------------------------------------------------------------- + + /** returns the sort descriptor stored with the database range. + + @see com::sun::star::sheet::SheetSortDescriptor2 + */ + sequence< com::sun::star::beans::PropertyValue > getSortDescriptor(); + + //------------------------------------------------------------------------- + + /** returns the filter descriptor stored with the database range. + +

If the filter descriptor is modified, the new filtering is + carried out when XDatabaseRange2::refresh() is + called.

+ */ + com::sun::star::sheet::XSheetFilterDescriptor2 getFilterDescriptor2(); + + //------------------------------------------------------------------------- + + /** returns the subtotal descriptor stored with the database range. + +

If the subtotal descriptor is modified, the new subtotals are + inserted when XDatabaseRange::refresh() is + called.

+ */ + com::sun::star::sheet::XSubTotalDescriptor getSubTotalDescriptor(); + + //------------------------------------------------------------------------- + + /** returns the database import descriptor stored with this database + range. + + @see com::sun::star::sheet::DatabaseImportDescriptor + */ + sequence< com::sun::star::beans::PropertyValue > getImportDescriptor(); + + //------------------------------------------------------------------------- + + /** executes the stored import, filter, sorting, and subtotals + descriptors again. + */ + void refresh(); + +}; + +//============================================================================= + +}; }; }; }; + +#endif + diff -uPr offapi.old/com/sun/star/sheet/XSheetFilterable2.idl offapi.new/com/sun/star/sheet/XSheetFilterable2.idl --- offapi.old/com/sun/star/sheet/XSheetFilterable2.idl 1970-01-01 08:00:00.000000000 +0800 +++ offapi.new/com/sun/star/sheet/XSheetFilterable2.idl 2008-03-11 15:35:36.000000000 +0800 @@ -0,0 +1,89 @@ +/************************************************************************* + * + * OpenOffice.org - a multi-platform office productivity suite + * + * $RCSfile: XSheetFilterable.idl,v $ + * + * $Revision: 1.7 $ + * + * last change: $Author: rt $ $Date: 2005/09/08 05:20:01 $ + * + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. + * + * + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. + * + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA + * + ************************************************************************/ + +#ifndef __com_sun_star_sheet_XSheetFilterable2_idl__ +#define __com_sun_star_sheet_XSheetFilterable2_idl__ + +#ifndef __com_sun_star_uno_XInterface_idl__ +#include +#endif + +#ifndef __com_sun_star_sheet_XSheetFilterDescriptor2_idl__ +#include +#endif + +//============================================================================= + +module com { module sun { module star { module sheet { + +//============================================================================= + +/** represents something that can be filtered using an XSheetFilterDesriptor2. + + @see com::sun::star::sheet::XSheetFilterableEx2 + */ +published interface XSheetFilterable2: com::sun::star::uno::XInterface +{ + //------------------------------------------------------------------------- + + /** creates a filter descriptor. + + @param bEmpty + if set to , creates an empty filter descriptor. If set to + , fills the filter descriptor with previous settings of + the current object (i.e. a database range). + */ + com::sun::star::sheet::XSheetFilterDescriptor2 + createFilterDescriptor( [in] boolean bEmpty ); + + //------------------------------------------------------------------------- + + /** performa a filter operation, using the settings of the passed filter + descriptor. + + @param xDescriptor + the settings for the filter operation. + */ + void filter( + [in] com::sun::star::sheet::XSheetFilterDescriptor2 xDescriptor ); + +}; + +//============================================================================= + +}; }; }; }; + +#endif + diff -uPr offapi.old/com/sun/star/sheet/XSheetFilterableEx2.idl offapi.new/com/sun/star/sheet/XSheetFilterableEx2.idl --- offapi.old/com/sun/star/sheet/XSheetFilterableEx2.idl 1970-01-01 08:00:00.000000000 +0800 +++ offapi.new/com/sun/star/sheet/XSheetFilterableEx2.idl 2008-03-10 15:53:04.000000000 +0800 @@ -0,0 +1,79 @@ +/************************************************************************* + * + * OpenOffice.org - a multi-platform office productivity suite + * + * $RCSfile: XSheetFilterableEx.idl,v $ + * + * $Revision: 1.7 $ + * + * last change: $Author: rt $ $Date: 2005/09/08 05:20:15 $ + * + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. + * + * + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. + * + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA + * + ************************************************************************/ +#ifndef __com_sun_star_sheet_XSheetFilterableEx2_idl__ +#define __com_sun_star_sheet_XSheetFilterableEx2_idl__ + +#ifndef __com_sun_star_sheet_XSheetFilterable2_idl__ +#include +#endif + +#ifndef __com_sun_star_sheet_XSheetFilterDescriptor2_idl__ +#include +#endif + + +//============================================================================= + +module com { module sun { module star { module sheet { + +//============================================================================= + +/** represents something from which criteria for filtering can be read. + +

In general the current object will be used only to create the + descriptor to filter another object, i.e. the advanced filter feature + in a spreadsheet.

+ + @see com::sun::star::sheet::SheetCellRange + */ +published interface XSheetFilterableEx2: com::sun::star::sheet::XSheetFilterable2 +{ + //------------------------------------------------------------------------- + + /** creates a filter descriptor for the specified filterable object from + the contents of this object. + */ + com::sun::star::sheet::XSheetFilterDescriptor2 + createFilterDescriptorByObject( + [in] com::sun::star::sheet::XSheetFilterable2 xObject ); + +}; + +//============================================================================= + +}; }; }; }; + +#endif + diff -uPr offapi.old/com/sun/star/sheet/makefile.mk offapi.new/com/sun/star/sheet/makefile.mk --- offapi.old/com/sun/star/sheet/makefile.mk 2008-01-10 20:43:34.000000000 +0800 +++ offapi.new/com/sun/star/sheet/makefile.mk 2008-03-11 16:14:32.000000000 +0800 @@ -247,6 +247,7 @@ XDataPilotTables.idl\ XDataPilotTablesSupplier.idl\ XDatabaseRange.idl\ + XDatabaseRange2.idl\ XDatabaseRanges.idl\ XDimensionsSupplier.idl\ XDocumentAuditing.idl\ @@ -295,7 +296,9 @@ XSheetConditionalEntry.idl\ XSheetFilterDescriptor.idl\ XSheetFilterable.idl\ + XSheetFilterable2.idl\ XSheetFilterableEx.idl\ + XSheetFilterableEx2.idl\ XSheetLinkable.idl\ XSheetOperation.idl\ XSheetOutline.idl\