<html> <head> <title>Interface XSheetAuditing</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="XSheetAuditing-xref.html" class="navimain">Use</a></td> <td class="navimain"><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Detective" 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 XSheetAuditing</td> </tr> <tr> <td/></tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides methods to access auditing (detective) features in a spreadsheet. </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/Detective">Spreadsheets - Detective</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="#hideDependents">hideDependents</a></td> <td class="imsum_right">removes arrows for one level of dependents of a formula cell. </td> </tr> <tr> <td class="imsum_left"><a href="#hidePrecedents">hidePrecedents</a></td> <td class="imsum_right">removes arrows for one level of precedents of a formula cell. </td> </tr> <tr> <td class="imsum_left"><a href="#showDependents">showDependents</a></td> <td class="imsum_right">draws arrows between a formula cell and its dependents. </td> </tr> <tr> <td class="imsum_left"><a href="#showPrecedents">showPrecedents</a></td> <td class="imsum_right">draws arrows between a formula cell and its precedents. </td> </tr> <tr> <td class="imsum_left"><a href="#showErrors">showErrors</a></td> <td class="imsum_right">draws arrows between a formula cell containing an error and the cells causing the error. </td> </tr> <tr> <td class="imsum_left"><a href="#showInvalid">showInvalid</a></td> <td class="imsum_right">marks all cells containing invalid values. </td> </tr> <tr> <td class="imsum_left"><a href="#clearArrows">clearArrows</a></td> <td class="imsum_right">removes all auditing arrows from the spreadsheet. </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="hideDependents" class="membertitle">hideDependents</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">boolean</td> </tr> <tr> <td valign="top"><b>hideDependents</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellAddress.html">CellAddress</a></td> <td valign="bottom"> aPosition );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>removes arrows for one level of dependents of a formula cell. </dd> <dd><p>If the method is executed again for the same cell, the previous level of dependent cells is removed.</p> </dd> <dt><b>Parameter aPosition</b></dt> <dd>the address of the formula cell. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="hidePrecedents" class="membertitle">hidePrecedents</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">boolean</td> </tr> <tr> <td valign="top"><b>hidePrecedents</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellAddress.html">CellAddress</a></td> <td valign="bottom"> aPosition );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>removes arrows for one level of precedents of a formula cell. </dd> <dd><p>If the method is executed again for the same cell, the previous level of dependent cells is removed.</p> </dd> <dt><b>Parameter aPosition</b></dt> <dd>the address of the formula cell. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="showDependents" class="membertitle">showDependents</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">boolean</td> </tr> <tr> <td valign="top"><b>showDependents</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellAddress.html">CellAddress</a></td> <td valign="bottom"> aPosition );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>draws arrows between a formula cell and its dependents. </dd> <dd><p>If the method is executed again for the same cell, the next level of dependent cells is marked.</p> </dd> <dt><b>Parameter aPosition</b></dt> <dd>the address of the formula cell. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="showPrecedents" class="membertitle">showPrecedents</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">boolean</td> </tr> <tr> <td valign="top"><b>showPrecedents</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellAddress.html">CellAddress</a></td> <td valign="bottom"> aPosition );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>draws arrows between a formula cell and its precedents. </dd> <dd><p>If the method is executed again for the same cell, the next level of dependent cells is marked.</p> </dd> <dt><b>Parameter aPosition</b></dt> <dd>the address of the formula cell. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="showErrors" class="membertitle">showErrors</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">boolean</td> </tr> <tr> <td valign="top"><b>showErrors</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellAddress.html">CellAddress</a></td> <td valign="bottom"> aPosition );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>draws arrows between a formula cell containing an error and the cells causing the error. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="showInvalid" class="membertitle">showInvalid</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">boolean</td> </tr> <tr> <td valign="top"><b>showInvalid</b>();</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>marks all cells containing invalid values. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="clearArrows" class="membertitle">clearArrows</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>clearArrows</b>();</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>removes all auditing arrows from the spreadsheet. </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>
