/text/scalc/guide/formula_value.xhp Sun Microsystems, Inc. formulas; displaying in cells values; displaying in tables tables; displaying formulas/values results display vs. formulas display displaying; formulas instead of results mw inserted "displaying;..." entry from shared/optionen/01060100.xhp. Adding (Calc) is no longer necessary in this file. mw made "results;..." a two level entry. Displaying Formulas or Values If you want to display the formulas in the cells, for example in the form =SUM(A1:B5), proceed as follows: Choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc - View. In the Display area mark the Formulas box. Click OK. If you want to view the calculation results instead of the formula, do not mark the Formulas box.

%PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc - View