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

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Errors
Revision as of 13:41, 6 October 2021 by DiGro (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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


Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/FAQ/Calc/Errors/Why_do_I_see_the_formula_text_and_not_the_result_of_the_formula%3F&oldid=249262"
Personal tools