(incubating) | The Free and Open Productivity Suite

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous

Content for OpenOffice.org version 3.3.
Overview Module Use Devguide Index
Methods' Summary Attributes' Summary Methods' Details Attributes' Details

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

interface XSheetAuditing
Description
provides methods to access auditing (detective) features in a spreadsheet.
Developers Guide
Spreadsheets - Detective
Methods' Summary
hideDependents removes arrows for one level of dependents of a formula cell.  
hidePrecedents removes arrows for one level of precedents of a formula cell.  
showDependents draws arrows between a formula cell and its dependents.  
showPrecedents draws arrows between a formula cell and its precedents.  
showErrors draws arrows between a formula cell containing an error and the cells causing the error.  
showInvalid marks all cells containing invalid values.  
clearArrows removes all auditing arrows from the spreadsheet.  
Methods' Details
hideDependents
boolean
hideDependents( [in] ::com::sun::star::table::CellAddress  aPosition );
Description
removes arrows for one level of dependents of a formula cell.

If the method is executed again for the same cell, the previous level of dependent cells is removed.

Parameter aPosition
the address of the formula cell.
hidePrecedents
boolean
hidePrecedents( [in] ::com::sun::star::table::CellAddress  aPosition );
Description
removes arrows for one level of precedents of a formula cell.

If the method is executed again for the same cell, the previous level of dependent cells is removed.

Parameter aPosition
the address of the formula cell.
showDependents
boolean
showDependents( [in] ::com::sun::star::table::CellAddress  aPosition );
Description
draws arrows between a formula cell and its dependents.

If the method is executed again for the same cell, the next level of dependent cells is marked.

Parameter aPosition
the address of the formula cell.
showPrecedents
boolean
showPrecedents( [in] ::com::sun::star::table::CellAddress  aPosition );
Description
draws arrows between a formula cell and its precedents.

If the method is executed again for the same cell, the next level of dependent cells is marked.

Parameter aPosition
the address of the formula cell.
showErrors
boolean
showErrors( [in] ::com::sun::star::table::CellAddress  aPosition );
Description
draws arrows between a formula cell containing an error and the cells causing the error.
showInvalid
boolean
showInvalid();
Description
marks all cells containing invalid values.
clearArrows
void
clearArrows();
Description
removes all auditing arrows from the spreadsheet.
Top of Page

Copyright © 1995, 2010, 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.

Apache OpenOffice is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.

Copyright & License
Apache and the Apache feather logos are trademarks of The Apache Software Foundation. OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.