OpenOffice.org Calc: Show Formulas to Verify Your Equations

One mistake that is often made in spreadsheets containing lots of data and formulas, is the accidental placement of numbers in a cell instead of the formula. It is a painful task to examine each and every cell one at a time to verify that the proper cells are using the proper equation. In addition, verifying that the cells referenced in the equations are correct can be equally overwhelming. Fortunately, Calc allows you to show the formulas of the entire spreadsheet so that you can more easily check your work.


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.

To go back to viewing the calculated values, simply repeat the above steps and uncheck the Formulas checkbox.

 

About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.

5 Responses to “OpenOffice.org Calc: Show Formulas to Verify Your Equations”

  1. June 26, 2010 at 12:20 pm, Ihatetellingmyemail_sorry said:

    THANKS! LOADS.

    Reply

  2. September 30, 2010 at 12:43 am, Githlar said:

    Alternately, as with Microsoft Office, you can use the Ctrl+~ shortcut.

    Reply

  3. February 19, 2013 at 1:41 pm, djpython said:

    Glad to have found this thread. I have been interested in this for some time in excel and calc.
    I think it would be nice to do this selectively, too, but I dont suppose you have that one up your sleeve.

    Back on my reason for comment: I have version 3.4.1 of oo.o and I dont have an options submenu in the tools menu. AAMOF I dont have options in any of my menus. I am working on a Macbook pro with osx 10.8.2.

    Seems like everywhere I turn there is something odd like this. What could it be this time.

    dj

    Reply

    • March 06, 2013 at 12:01 am, jc said:

      did you ever find out how because i also have the same issues as well.>

      Reply

  4. May 17, 2013 at 12:07 pm, Michael Mooney said:

    I had the same trouble as djpython and jc, no Tools>Options. Using OO 3.3.0 eventually found this under Open Office.org > Preferences.

    I also tried the Ctrl + ~ shortcut, but that doesn’t seem to work now.

    Reply

Leave a Reply