Why do I see the formula text and not the result of the formula?
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Errors
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:
- Select Tools → Options from the main menu
- Select OpenOffice Calc - View (in OpenOffice.org 1.1.x: Spreadsheet - View)
- Make sure that the Formulas Option under Display is not checked