Yes, it ist bug https://bugs.launchpad.net/openoffice/+bug/210153
but you miss one row in my line:
To simplify this, I think you are saying that in v2.4, you see that a
formula like this
=if(A1-B1<>0;1;C1) returns an error 529 when C1 contains "" and A1 and
B1 are empty
no, it is ok, but when C1 is used as part of an arithmetic operation here
come the error.
It is very annoying not only due the difference from other programs, but
even for the difference between the same release of debian version and the
ooo versions !
My suggestion woyld be to have an option where the user can choose that
string values when present in an arithmetic formula are
a. evaluated as real ( so "1.2"+3 equals 4.2)
b. evaluated as integer ( so "1.2"+3 equals 4 )
c. evaluated as zero so ( so "1.2"+3 equals 3 )
d. evaluated as an error
Since excel has one of these behaviour it would be sensibble that when
loading an .xls file is automatically set the compatibility mode, and
when loading and .ods file not.
personally all my files consider option c.
--
Leonardo Boselli
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
