English:

The Free and Open Productivity Suite
New: Apache OpenOffice 4.1.1 released!

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous


:: 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

Logo ApacheCon Europe 2014

Apache Feather

Copyright & License | Privacy | Website Feedback | Contact Us | Donate | Thanks

Apache, the Apache feather logo, and OpenOffice 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.