<html> <head> <title>Interface XDatabaseRange</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../module-ix.html" class="navimain">Overview</a></td> <td class="navimain"><a href="module-ix.html" class="navimain">Module</a></td> <td class="navimain"><a href="XDatabaseRange-xref.html" class="navimain">Use</a></td> <td class="navimainnone">Devguide</td> <td class="navimain"><a href="../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub"><a href="#MethodsSummary" class="navisub">Methods' Summary</a></td> <td class="navisub">Attributes' Summary</td> <td class="navisub"><a href="#MethodsDetails" class="navisub">Methods' Details</a></td> <td class="navisub">Attributes' Details</td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../module-ix.html" class="namechain">::</a> <a href="../../../module-ix.html" class="namechain">com</a> :: <a href="../../module-ix.html" class="namechain">sun</a> :: <a href="../module-ix.html" class="namechain">star</a> :: <a href="module-ix.html" class="namechain">sheet</a> :: </p> </td> </tr> <tr> <td class="title">interface XDatabaseRange</td> </tr> <tr> <td/></tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides access to the settings and options of a database range. </dd> <dt><b>See also</b></dt> <dd><a href="DatabaseRange.html">DatabaseRange</a></dd> </dl> </td> </tr> </table> <hr> <a name="MethodsSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Methods' Summary</td> </tr> <tr> <td class="imsum_left"><a href="#getDataArea">getDataArea</a></td> <td class="imsum_right">returns the data area of the database range in the spreadsheet document. </td> </tr> <tr> <td class="imsum_left"><a href="#setDataArea">setDataArea</a></td> <td class="imsum_right">sets the data area of the database range. </td> </tr> <tr> <td class="imsum_left"><a href="#getSortDescriptor">getSortDescriptor</a></td> <td class="imsum_right">returns the sort descriptor stored with the database range. </td> </tr> <tr> <td class="imsum_left"><a href="#getFilterDescriptor">getFilterDescriptor</a></td> <td class="imsum_right">returns the filter descriptor stored with the database range. </td> </tr> <tr> <td class="imsum_left"><a href="#getSubTotalDescriptor">getSubTotalDescriptor</a></td> <td class="imsum_right">returns the subtotal descriptor stored with the database range. </td> </tr> <tr> <td class="imsum_left"><a href="#getImportDescriptor">getImportDescriptor</a></td> <td class="imsum_right">returns the database import descriptor stored with this database range. </td> </tr> <tr> <td class="imsum_left"><a href="#refresh">refresh</a></td> <td class="imsum_right">executes the stored import, filter, sorting, and subtotals descriptors again. </td> </tr> </table> <a name="MethodsDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Methods' Details</td> </tr> <tr> <td class="imdetail"><a name="getDataArea" class="membertitle">getDataArea</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellRangeAddress.html">CellRangeAddress</a></td> </tr> <tr> <td valign="top"><b>getDataArea</b>();</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>returns the data area of the database range in the spreadsheet document. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="setDataArea" class="membertitle">setDataArea</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">void</td> </tr> <tr> <td valign="top"><b>setDataArea</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellRangeAddress.html">CellRangeAddress</a></td> <td valign="bottom"> aDataArea );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>sets the data area of the database range. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="getSortDescriptor" class="membertitle">getSortDescriptor</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">sequence< ::com::sun::star::<a href="../beans/module-ix.html">beans</a>::<a href="../beans/PropertyValue.html">PropertyValue</a> ></td> </tr> <tr> <td valign="top"><b>getSortDescriptor</b>();</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>returns the sort descriptor stored with the database range. </dd> <dt><b>See also</b></dt> <dd><a href="SheetSortDescriptor2.html">SheetSortDescriptor2</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="getFilterDescriptor" class="membertitle">getFilterDescriptor</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3"><a href="XSheetFilterDescriptor.html">XSheetFilterDescriptor</a></td> </tr> <tr> <td valign="top"><b>getFilterDescriptor</b>();</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>returns the filter descriptor stored with the database range. </dd> <dd><p>If the filter descriptor is modified, the new filtering is carried out when <a href="XDatabaseRange.html">XDatabaseRange</a>::<a href="XDatabaseRange.html#refresh">refresh()</a> is called.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="getSubTotalDescriptor" class="membertitle">getSubTotalDescriptor</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3"><a href="XSubTotalDescriptor.html">XSubTotalDescriptor</a></td> </tr> <tr> <td valign="top"><b>getSubTotalDescriptor</b>();</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>returns the subtotal descriptor stored with the database range. </dd> <dd><p>If the subtotal descriptor is modified, the new subtotals are inserted when <a href="XDatabaseRange.html">XDatabaseRange</a>::<a href="XDatabaseRange.html#refresh">refresh()</a> is called.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="getImportDescriptor" class="membertitle">getImportDescriptor</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">sequence< ::com::sun::star::<a href="../beans/module-ix.html">beans</a>::<a href="../beans/PropertyValue.html">PropertyValue</a> ></td> </tr> <tr> <td valign="top"><b>getImportDescriptor</b>();</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>returns the database import descriptor stored with this database range. </dd> <dt><b>See also</b></dt> <dd><a href="DatabaseImportDescriptor.html">DatabaseImportDescriptor</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="refresh" class="membertitle">refresh</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">void</td> </tr> <tr> <td valign="top"><b>refresh</b>();</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>executes the stored import, filter, sorting, and subtotals descriptors again. </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.</p> </div> <!-- id="adc-idlref" --> </body> </html>