StarOffice™ 5.2 Calc Handbook

Checking Functions with the AutoPilot

You saw in the previous chapter how the Detective could be used to trace precedents and dependents to help troubleshoot formulas. However, you will find that the Function AutoPilot can provide you with a better debugging tool when you are trying to troubleshoot a function that is proving to be problematic.

To troubleshoot a function with the AutoPilot:

1.	Select the cell that holds the function.
2.	Select Insert, then select Function. The Function AutoPilot will appear (see Figure 6.15). The AutoPilot's Structure tab provides a diagram of the function where function names and operators are represented by folders. Cell references or values related to each function name or operator are listed under the appropriate ...