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]

Reply via email to