Hi Eike,
Eike Rathke wrote (22-7-2008 17:23)
On Monday, 2008-07-21 22:30:49 +0200, Cor Nouws wrote:
In some cases, if in Excel a formula has a non-numeric argument,
"#VALUE!" is returned.
In Calc this is simply neglected.
(Apologies if I over simplify).
Erm.. care to elaborate? On which occasions non-numeric arguments are
neglected but should not?
Did I say "should" ;-)
Example:
A1 = '1.5
B1 = A1-1
Result Excel #VALUE!
Result OOo -1
I did not make a study of those kind of differences, so pls don't ask
other examples.
Thanks,
Cor
--
"The Year of 3" -2008- "Het jaar van 3"
Cor Nouws - Arnhem - Netherlands
> marketing contact - http://nl.OpenOffice.org
> Zeker van OpenOffice.org - www.nouenoff.nl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
