On Thursday March 16 2006 10:36 am, Robin Laing wrote:
> 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.
Here is some questions and another possibility.
You have A1 = .55 and B1 = $10,00. Why are you using a period for the
decimal point in A1 and a coma for the decimal point in B1? Should both
decimal points be a comma or period based upon what your locality uses?
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
