Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous

Overview Module Use Devguide Index
Methods' Summary Attributes' Summary Methods' Details Attributes' Details

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

interface XDatabaseRange
Description
provides access to the settings and options of a database range.
See also
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
SheetSortDescriptor2
getFilterDescriptor
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 XDatabaseRange::refresh() is called.

See also
SheetFilterDescriptor
getSubTotalDescriptor
XSubTotalDescriptor
getSubTotalDescriptor();
Description
returns the subtotal descriptor stored with the database range.

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

See also
SubTotalDescriptor
getImportDescriptor
sequence< ::com::sun::star::beans::PropertyValue >
getImportDescriptor();
Description
returns the database import descriptor stored with this database range.
See also
DatabaseImportDescriptor
refresh
void
refresh();
Description
executes the stored import, filter, sorting, and subtotals descriptors again.
Top of Page

Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.

The ASF

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The ASF logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.