The Detective
In a long or complicated spreadsheet, color coding becomes less
useful. In these cases, consider using the the submenu under Tools >
Detective. The Detective is a tool for checking which cells are used as
arguments by a formula (precedents) and which other formulas it is
nested in (dependents), and tracking errors. It can also be used for
tracing errors, marking invalid data (that is, information in cells that is
not in the proper format for a function’s argument), or even for
removing precedents and dependents.
To use the Detective, select a cell with a formula, then start the
Detective. On the spreadsheet, you will see lines ending in circles to
indicate precedents, and lines ending in arrows for dependents. The
lines show the flow of information.
Use the Detective to assist in following the precedents referred to in a
formula in a cell. By tracing these precedents, you frequently can find
the source of the errors. Place the cursor in the cell in question and
then choose Tools > Detective > Trace Precedents from the menu
bar or press Shift+F7. Figure 146 shows a simple example of tracing
precedents.
Cursor placed in cell
Figure 146: Tracing precedents using the Detective
208 OpenOffice.org 3.x Calc Guide
Commentaires sur ces manuels