Why do I see the formula text and not the result of the formula?

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Errors
Jump to: navigation, search


Why do I see the formula text and not the result of the formula?


  • Make sure that all formulas will start with the equal sign (=)

If your formula starts with the = character, check that the options are set to not view the formula:

  1. Select Tools → Options from the main menu
  2. Select OpenOffice Calc - View (in OpenOffice.org 1.1.x: Spreadsheet - View)
  3. Make sure that the Formulas Option under Display is not checked


Personal tools