Language

The Free and Open Productivity Suite
Apache OpenOffice 4.1.9 released

This page is outdated. You will be redirected to http://wiki.services.openoffice.org /wiki/Documentation/FAQ shortly.

Documentation / User FAQ / Calc / Previous-Next

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

In OOo Calc all formulas must start with the equal sign (=).*

If your formula does start with an = character, then check that the options are set to not view the formula. Go to Tools > Options; then, in Spreadsheet > View verify that there is no "tick mark" in the box beside the Formulas selection.

*This is a difference between Calc and MS-Excel(R).

Documentation / User FAQ / Calc / Previous-Next

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.