#100469#; add AutoFilter and FilterCriteriaSource support

1 files changed, 56 insertions, 27 deletions

diff --git a/offapi/com/sun/star/sheet/DatabaseRange.idl b/offapi/com/sun/star/sheet/DatabaseRange.idl
index 43d9e3cde372..fabf815ba7b3 100644
--- a/offapi/com/sun/star/sheet/DatabaseRange.idl
+++ b/offapi/com/sun/star/sheet/DatabaseRange.idl
@@ -2,9 +2,9 @@
  *
  *  $RCSfile: DatabaseRange.idl,v $
  *
- *  $Revision: 1.4 $
+ *  $Revision: 1.5 $
  *
- *  last change: $Author: mi $ $Date: 2002-10-03 13:07:49 $
+ *  last change: $Author: sab $ $Date: 2002-10-11 07:50:35 $
  *
  *  The Contents of this file are made available subject to the terms of
  *  either of the following licenses
@@ -58,7 +58,6 @@
  *
  *
  ************************************************************************/
-
 #ifndef __com_sun_star_sheet_DatabaseRange_idl__
 #define __com_sun_star_sheet_DatabaseRange_idl__
 
@@ -78,9 +77,14 @@
 #include <com/sun/star/container/XNamed.idl>
 #endif
 
+#ifndef __com_sun_star_table_CellRangeAddress_idl__
+#include <com/sun/star/table/CellRangeAddress.idl>
+#endif
+
+
 //=============================================================================
 
-module com {  module sun {  module star {  module sheet {
+ module com {  module sun {  module star {  module sheet {
 
 //=============================================================================
 
@@ -93,51 +97,60 @@ module com {  module sun {  module star {  module sheet {
  */
 service DatabaseRange
 {
-    //-------------------------------------------------------------------------
-
-    /** provides access to the settings of the database range.
-     */
+    // DocMerge: empty anyway
     interface com::sun::star::sheet::XDatabaseRange;
 
+    // DocMerge: empty anyway
+    interface com::sun::star::sheet::XCellRangeReferrer;
+
+    // DocMerge: empty anyway
+    interface com::sun::star::beans::XPropertySet;
+
+    // DocMerge: empty anyway
+    interface com::sun::star::container::XNamed;
+
     //-------------------------------------------------------------------------
 
-    /** provides access to the cell range object referred by this named range.
+    // DocMerge from xml: property com::sun::star::sheet::DatabaseRange::MoveCells
+    /** if this property is set, columns or rows are inserted or deleted
+        when the size of the range is changed by an update operation.
      */
-    interface com::sun::star::sheet::XCellRangeReferrer;
+    [property] boolean MoveCells;
 
     //-------------------------------------------------------------------------
 
-//! service PropertySet
-    /** provides access to the properties.
+    // DocMerge from xml: property com::sun::star::sheet::DatabaseRange::KeepFormats
+    /** if this property is set, cell formats are extended
+        when the size of the range is changed by an update operation.
      */
-    interface com::sun::star::beans::XPropertySet;
+    [property] boolean KeepFormats;
 
     //-------------------------------------------------------------------------
 
-    /** provides access to the name of the database range.
-      */
-    interface com::sun::star::container::XNamed;
+    // DocMerge from xml: property com::sun::star::sheet::DatabaseRange::StripData
+    /** if this property is set, the cell contents within the database
+        range are left out when the document is saved.
+     */
+    [property] boolean StripData;
 
-    //=========================================================================
+    //-------------------------------------------------------------------------
 
-    /** specifies whether columns or rows are inserted or deleted when the
-        size of the range is changed by an update operation.
+    /** specifies whether the AutoFilter is enabled or not.
      */
-    [property] boolean MoveCells;
+    [property] boolean AutoFilter;
 
     //-------------------------------------------------------------------------
 
-    /** specifies whether cell formats are extended when the size of the
-        range is changed by an update operation.
+    /** specifies whether the filter criteria should be taken from a CellRange
      */
-    [property] boolean KeepFormats;
+    [property] boolean UseFilterCriteriaSource;
 
     //-------------------------------------------------------------------------
 
-    /** specifies whether cell contents within the database range are left
-        out when the document is saved.
+    /** specifies the range where the filter can find the filter criterias.
+        <p>This is only used if <member>SheetFilterDescriptor::UseFilterCriteriaSource</member> is <TRUE/>.</p>
      */
-    [property] boolean StripData;
+    [property] com::sun::star::table::CellRangeAddress FilterCriteriaSource;
 
 };
 
@@ -145,5 +158,21 @@ service DatabaseRange
 
 }; }; }; };
 
-#endif
+/*=============================================================================
+
+    $Log: not supported by cvs2svn $
+    Revision 1.3  2000/11/08 12:43:46  mi
+    moved from api
+
+    Revision 1.1.1.1  2000/09/18 23:35:47  hjs
+    initial import
+
+    Revision 1.3  2000/09/11 11:52:48  mi
+    documentation merged from XML
 
+    Revision 1.1.1.1  1999/11/11 09:48:45  jsc
+    new
+
+
+=============================================================================*/
+#endif