<html> <head> <title>Interface XFormulaQuery</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="XFormulaQuery-xref.html" class="navimain">Use</a></td> <td class="navimain"><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Querying_for_Cells_with_Specific_Properties" class="navimain">Devguide</a></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 XFormulaQuery</td> </tr> <tr> <td/></tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides methods to query cells for dependencies in formulas. </dd> <dd><p>All methods return a collection of cell ranges.</p> </dd> <dt><b>See also</b></dt> <dd><a href="SheetRangesQuery.html">SheetRangesQuery</a>, <a href="SheetCellRanges.html">SheetCellRanges</a></dd> </dl> <a name="devmanual"> </a><dl> <dt><b>Developers Guide</b></dt> <dd><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Querying_for_Cells_with_Specific_Properties">Spreadsheets - Querying for Cells with Specific Properties</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="#queryDependents">queryDependents</a></td> <td class="imsum_right">queries all dependent formula cells. </td> </tr> <tr> <td class="imsum_left"><a href="#queryPrecedents">queryPrecedents</a></td> <td class="imsum_right">queries all precedent cells. </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="queryDependents" class="membertitle">queryDependents</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="XSheetCellRanges.html">XSheetCellRanges</a></td> </tr> <tr> <td valign="top"><b>queryDependents</b>(</td> <td valign="top">[in] boolean</td> <td valign="bottom"> bRecursive );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>queries all dependent formula cells. </dd> <dd><p>Dependent cells are cells containing formulas with references to the original cell.</p> </dd> <dt><b>Parameter bRecursive</b></dt> <dd><b>false</b> = queries cells dependent from the original range(s), <b>true</b> = repeats query with all found cells (finds dependents of dependents, and so on). </dd> <dt><b>Returns</b></dt> <dd>all dependent cells of any formula cell of the current cell range(s). </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="queryPrecedents" class="membertitle">queryPrecedents</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="XSheetCellRanges.html">XSheetCellRanges</a></td> </tr> <tr> <td valign="top"><b>queryPrecedents</b>(</td> <td valign="top">[in] boolean</td> <td valign="bottom"> bRecursive );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>queries all precedent cells. </dd> <dd><p>Precedent cells are cells which are referenced from a formula cell.</p> </dd> <dt><b>Parameter bRecursive</b></dt> <dd><b>false</b> = queries precedent cells of the original range(s), <b>true</b> = repeats query with all found cells (finds precedents of precedents, and so on). </dd> <dt><b>Returns</b></dt> <dd>all precedent cells of any formula cell of the current cell range(s). </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>
