<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> <dt><b>See also</b></dt> <dd><a href="SheetFilterDescriptor.html">SheetFilterDescriptor</a></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> <dt><b>See also</b></dt> <dd><a href="SubTotalDescriptor.html">SubTotalDescriptor</a></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 © 2000, 2012 LibreOffice contributors and/or their affiliates. All rights reserved.</p><p class="copyright" align="center">LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.</p><p class="copyright" align="center">The Document Foundation acknowledges all community members, please find more info <a href="http://www.libreoffice.org/about-us/credits/" target="_blank">at our website</a>.<p> </p><p class="copyright" align="center"><a href="http://www.libreoffice.org/privacy" target="_blank">Privacy Policy</a> | <a href="http://www.libreoffice.org/imprint" target="_blank">Impressum (Legal Info)</a> | Copyright information: The source code of LibreOffice is licensed under the GNU Lesser General Public License (<a href="http://www.libreoffice.org/download/license/" target="_blank">LGPLv3</a>). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our <a href="http://wiki.documentfoundation.org/TradeMark_Policy" target="_blank">trademark policy</a>.</p> </div> <!-- id="adc-idlref" --> </body> </html>
