Overview | Module | Use | Devguide | Index

Methods' Summary | Methods' Details | Attributes' Summary | Attributes' Details

:: com :: sun :: star :: sheet ::
interface XSheetAuditing
  Base Hierarchy
      ::com::sun::star::uno::XInterface
       |
       +-XSheetAuditing
Description provides methods to access auditing (detective) features in a spreadsheet. Developers Guide 8.3.10 Spreadsheet Documents - Working with Spreadsheet Documents - 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 © 2003 Sun Microsystems, Inc.