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

service DatabaseRange
Description
represents a database range in a spreadsheet document.

A database range is a name for a cell range that also stores filtering, sorting, subtotal and data import settings and options.

See also
::com::sun::star::sheet::DatabaseRanges
Developers Guide
Exported Interfaces
::com::sun::star::sheet::XDatabaseRange
(referenced entity's summary:)
provides access to the settings and options of a database range.
::com::sun::star::sheet::XCellRangeReferrer
(referenced entity's summary:)
allows direct access to the cells in a named range or to the cells which are visible in a view, without the need to get the document object first.
::com::sun::star::beans::XPropertySet
(referenced entity's summary:)
provides information about and access to the properties from an implementation.
::com::sun::star::container::XNamed
(referenced entity's summary:)
specifies the name of the object.
::com::sun::star::util::XRefreshable
Usage Restrictions
optional
Properties' Summary
boolean
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.  
boolean
KeepFormats
if this property is set, cell formats are extended when the size of the range is changed by an update operation.  
boolean
StripData
if this property is set, the cell contents within the database range are left out when the document is saved.  
boolean
AutoFilter
[ OPTIONAL ]
specifies whether the AutoFilter is enabled or not.  
boolean
UseFilterCriteriaSource
[ OPTIONAL ]
specifies whether the filter criteria should be taken from a CellRange.  
::com::sun::star::table::CellRangeAddress
FilterCriteriaSource
[ OPTIONAL ]
specifies the range where the filter can find the filter criterias.  
long
RefreshPeriod
[ OPTIONAL ]
specifies the time between two refresh actions in seconds.  
boolean
FromSelection
[ OPTIONAL ]
specifies whether the imported data is only a selection of the database.  
Properties' Details
MoveCells
boolean MoveCells;
Description
if this property is set, columns or rows are inserted or deleted when the size of the range is changed by an update operation.
KeepFormats
boolean KeepFormats;
Description
if this property is set, cell formats are extended when the size of the range is changed by an update operation.
StripData
boolean StripData;
Description
if this property is set, the cell contents within the database range are left out when the document is saved.
AutoFilter
boolean AutoFilter;
Usage Restrictions
optional
Description
specifies whether the AutoFilter is enabled or not.
Since
OpenOffice 1.1.2
UseFilterCriteriaSource
boolean UseFilterCriteriaSource;
Usage Restrictions
optional
Description
specifies whether the filter criteria should be taken from a CellRange.
Since
OpenOffice 1.1.2
FilterCriteriaSource
::com::sun::star::table::CellRangeAddress FilterCriteriaSource;
Usage Restrictions
optional
Description
specifies the range where the filter can find the filter criterias.

This is only used if ::com::sun::star::sheet::SheetFilterDescriptor::UseFilterCriteriaSource is true .

Since
OpenOffice 1.1.2
RefreshPeriod
long RefreshPeriod;
Usage Restrictions
optional
Description
specifies the time between two refresh actions in seconds.
Since
OpenOffice 2.0.0
FromSelection
boolean FromSelection;
Usage Restrictions
optional
Description
specifies whether the imported data is only a selection of the database.
Since
OpenOffice 2.0.0

 
Top of Page