Bug#504604: bug, same but the conditions are different.

[Leonardo Boselli <leo@dicea.unifi.it>]

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