Overview | Module | Use | Devguide | Index

Included Services | Exported Interfaces | Properties' Summary | Properties' Details

:: 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 DatabaseRanges Developers Guide 8.3.5 Spreadsheet Documents - Working with Spreadsheet Documents - Database Operations

Exported Interfaces
XDatabaseRange | provides access to the settings and options of a database range.
XCellRangeReferrer | 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 | provides information about and access to the properties from an implementation.
::com::sun::star::container::XNamed | specifies the name of the object.

Properties' Summary
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.
KeepFormats | if this property is set, cell formats are extended when the size of the range is changed by an update operation.
StripData | if this property is set, the cell contents within the database range are left out when the document is saved.
AutoFilter | [ OPTIONAL ] specifies whether the AutoFilter is enabled or not.
UseFilterCriteriaSource | [ OPTIONAL ] specifies whether the filter criteria should be taken from a CellRange.
FilterCriteriaSource | [ OPTIONAL ] specifies the range where the filter can find the filter criterias.

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; [ OPTIONAL ] Description specifies whether the AutoFilter is enabled or not. Since version OpenOffice.org 1.1.1
UseFilterCriteriaSource
boolean UseFilterCriteriaSource; [ OPTIONAL ] Description specifies whether the filter criteria should be taken from a CellRange. Since version OpenOffice.org 1.1.1
FilterCriteriaSource
::com::sun::star::table::CellRangeAddress FilterCriteriaSource; [ OPTIONAL ] Description specifies the range where the filter can find the filter criterias. This is only used if SheetFilterDescriptor::UseFilterCriteriaSource is true . Since version OpenOffice.org 1.1.1

Top of Page

Copyright © 2003 Sun Microsystems, Inc.