showing the formulas but not the values in Open Office Calc

Question

Normally a spreadsheet hides the formulas you enter and displays the values. I'm looking for a way to display the formulas but hide the values, so I can print it out and show people how my spreadsheet actually does what it does. Any ideas?

Answer 1

Found it!

http://www.tech-recipes.com/rx/2350/openoffice%5Forg%5Fcalc%5Fshow%5Fformulas/

1. Click Tools and select Options.

2. In the left pane of the Options window, expand OpenOffice.org Calc.

3. Select View.

4. In the Display section, check the Formulas checkbox.

5. Click OK.