Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Displaying Formulae or Values

If you want to display the formulae in the cells, for example in the form =SUM(A1:B5), proceed as follows:

  1. Choose Tools - Options - Office Calc - View.

  2. In the Display area mark the Formulae check box. Click OK.

If you want to view the calculation results instead of the formula, do not mark the Formulae check box.