|
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 |
| specifies whether the AutoFilter is enabled or not.
|
boolean | UseFilterCriteriaSource |
| specifies whether the filter criteria should be taken from a CellRange.
|
com::sun::star::table::CellRangeAddress | FilterCriteriaSource |
| specifies the range where the filter can find the filter criteria.
|
long | RefreshPeriod |
| specifies the time between two refresh actions in seconds.
|
boolean | FromSelection |
| specifies whether the imported data is only a selection of the database.
|
long | TokenIndex |
| returns the index used to refer to this range in token arrays.
|
boolean | TotalsRow |
| specifies whether this range includes a bottom row of totals.
|
boolean | ContainsHeader |
| specifies whether this range includes a top row of headers.
|
|
com::sun::star::table::CellRangeAddress | getDataArea () |
| returns the data area of the database range in the spreadsheet document.
|
void | setDataArea ([in] com::sun::star::table::CellRangeAddress aDataArea) |
| sets the data area of the database range.
|
sequence< com::sun::star::beans::PropertyValue > | getSortDescriptor () |
| returns the sort descriptor stored with the database range.
|
XSheetFilterDescriptor | getFilterDescriptor () |
| returns the filter descriptor stored with the database range.
|
XSubTotalDescriptor | getSubTotalDescriptor () |
| returns the subtotal descriptor stored with the database range.
|
sequence< com::sun::star::beans::PropertyValue > | getImportDescriptor () |
| returns the database import descriptor stored with this database range.
|
void | refresh () |
| executes the stored import, filter, sorting, and subtotals descriptors again.
|
any | queryInterface ([in] type aType) |
| queries for a new interface to an existing UNO object.
|
void | acquire () |
| increases the reference counter by one.
|
void | release () |
| decreases the reference counter by one.
|
com::sun::star::table::XCellRange | getReferredCells () |
| returns the cell range object that is represented.
|
com::sun::star::beans::XPropertySetInfo | getPropertySetInfo () |
void | setPropertyValue ([in] string aPropertyName, [in] any aValue) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::beans::PropertyVetoException, com::sun::star::lang::IllegalArgumentException, com::sun::star::lang::WrappedTargetException ) |
| sets the value of the property with the specified name.
|
any | getPropertyValue ([in] string PropertyName) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
void | addPropertyChangeListener ([in] string aPropertyName, [in] com::sun::star::beans::XPropertyChangeListener xListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| adds an XPropertyChangeListener to the specified property.
|
void | removePropertyChangeListener ([in] string aPropertyName, [in] com::sun::star::beans::XPropertyChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| removes an XPropertyChangeListener from the listener list.
|
void | addVetoableChangeListener ([in] string PropertyName, [in] com::sun::star::beans::XVetoableChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| adds an XVetoableChangeListener to the specified property with the name PropertyName.
|
void | removeVetoableChangeListener ([in] string PropertyName, [in] com::sun::star::beans::XVetoableChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| removes an XVetoableChangeListener from the listener list.
|
string | getName () |
void | setName ([in] string aName) |
| sets the programmatic name of the object.
|
void | refresh () |
| refreshes the data of the object from the connected data source.
|
void | addRefreshListener ([in] com::sun::star::util::XRefreshListener l) |
| adds the specified listener to receive the event "refreshed."
|
void | removeRefreshListener ([in] com::sun::star::util::XRefreshListener l) |
| removes the specified listener.
|
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
- Spreadsheet Documents - Database Operations