O'Reilly logo

StarOffice™ 5.2 Calc Handbook by Joe Habraken

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required