Thanks Brian - it works On Tue, Jul 1, 2008 at 9:55 PM, Brian Barker <[EMAIL PROTECTED]> wrote:
> At 21:49 01/07/2008 +0200, Smokie Smoker wrote: > >> When using CALC, I get two responses on two different machines. Both run >> Windows XP and I installed the same OpenOffice.org 2.4.1 download on both >> machines. >> >> On the one machine the spreadsheet calculates correctly as expected, but >> on the second machine, the formula does not calculate. Instead the formula >> is simply displayed as text. >> >> I have looked for a setting to enable the calculation of formulas, but >> have not been able to find it. >> The sheet is really simple: >> A1 1 >> A2 2 >> A3 3 >> A4 =A1+A2+A3 >> On the one machine the result is displayed in A4 6 and the second machine >> displays =A1+A2+A3 >> >> Any advice? >> > > Go to Tools | Options... | OpenOffice.org Calc | View | Display, and remove > the tick from Formulas. > > I trust this helps. > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
