Using the Calc Detective
When you create formulas and functions for your spreadsheets it is essential that you reference the correct cells in them. No matter how good a formula or how well chosen a function, you won't get the correct answer if the formula is not looking at the appropriate values on the Calc sheet.
A tool that will help you troubleshoot your formulas (and your functions) is the Detective. The Detective allows you to view two entities related to formulas. You can have Calc display the cells that are referenced by a particular formula. These cells containing data are called precedents. Calc can also show you the cells (those containing formulas) that rely on a cell for a particular value. Cells containing formulas or functions are ...
Get StarOffice™ 5.2 Calc Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
