Difference between revisions of "Documentation/FAQ/Calc/Errors/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
(New page: {{DISPLAYTITLE: Why do I see the formula text and not the result of the formula?}} <section begin=question/> '''Why do I see the formula text and not the result of the formula?''' <sectio...)
 
m
 
Line 9: Line 9:
  
 
If your formula starts with the = character, check that the options are set to not view the formula:
 
If your formula starts with the = character, check that the options are set to not view the formula:
# Select '''Tools - Options''' from the main menu
+
# Select {{menu|Tools|Options}} from the main menu
# Select '''OpenOffice.org Calc - View''' (in OpenOffice.org 1.1.x: Spreadsheet - View)
+
# Select '''OpenOffice Calc - View''' (in OpenOffice.org 1.1.x: Spreadsheet - View)
 
# Make sure that the '''Formulas''' Option under '''Display''' is '''not''' checked  
 
# Make sure that the '''Formulas''' Option under '''Display''' is '''not''' checked  
  

Latest revision as of 13:41, 6 October 2021


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