Mike Masse wrote:
HI all,
Just installed OO and am really intrigued. However, when
I opened my usual excel sheet in calc the formulas do not seem to
work correctly.... I have poked through the FAQ, and didn't come
up with an answer ... the formulas? They are there ... and the
format seems correct (; instead of ,) etc.
It might be a setting or something like that....
Col A has .55
Col B gets an entry like $10,00 (formatted for currency)
Col C has a formula =A1*B1 and returns $0.00
I seem to have many (all) formulas that are not working as they
should .... is that possible? WHere should I look to start
correcting this?
TIA
Mike
Works for me. I cannot recreate the problem.
Is Tools > Cell Contents > AutoCalculate turned off (unchecked)?
What happens if you press F9?
My spread sheets start to function the same as you describe as soon as
I turn off the AutoCalculate.
--
Robin Laing
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
