:: com :: sun :: star :: sheet ::

interface XDatabaseRange
Description
provides access to the settings and options of a database range.
See also
::com::sun::star::sheet::DatabaseRange

Methods' Summary
getDataArea returns the data area of the database range in the spreadsheet document.  
setDataArea sets the data area of the database range.  
getSortDescriptor returns the sort descriptor stored with the database range.  
getFilterDescriptor returns the filter descriptor stored with the database range.  
getSubTotalDescriptor returns the subtotal descriptor stored with the database range.  
getImportDescriptor returns the database import descriptor stored with this database range.  
refresh executes the stored import, filter, sorting, and subtotals descriptors again.  
Methods' Details
getDataArea
::com::sun::star::table::CellRangeAddress
getDataArea();

Description
returns the data area of the database range in the spreadsheet document.
setDataArea
void
setDataArea( [in] ::com::sun::star::table::CellRangeAddress  aDataArea );

Description
sets the data area of the database range.
getSortDescriptor
sequence< ::com::sun::star::beans::PropertyValue >
getSortDescriptor();

Description
returns the sort descriptor stored with the database range.
See also
::com::sun::star::sheet::SheetSortDescriptor2
getFilterDescriptor
::com::sun::star::sheet::XSheetFilterDescriptor
getFilterDescriptor();

Description
returns the filter descriptor stored with the database range.

If the filter descriptor is modified, the new filtering is carried out when ::com::sun::star::sheet::XDatabaseRange::refresh() is called.

getSubTotalDescriptor
::com::sun::star::sheet::XSubTotalDescriptor
getSubTotalDescriptor();

Description
returns the subtotal descriptor stored with the database range.

If the subtotal descriptor is modified, the new subtotals are inserted when ::com::sun::star::sheet::XDatabaseRange::refresh() is called.

getImportDescriptor
sequence< ::com::sun::star::beans::PropertyValue >
getImportDescriptor();

Description
returns the database import descriptor stored with this database range.
See also
::com::sun::star::sheet::DatabaseImportDescriptor
refresh
void
refresh();

Description
executes the stored import, filter, sorting, and subtotals descriptors again.
Top of Page