https://issues.apache.org/ooo/show_bug.cgi?id=122927
It boils down to how an IF() statements are evaluated. Remember, the typical form is IF(Condition;X;Y) where you give a return value for the case where Condition is TRUE and another value when Condition is FALSE. But it is also possible to leave out the last parameter and have a formula like this: IF(Condition;X) So what does the formula evaluate to if Condition is FALSE? The behavior in 4.0.0, returning FALSE, is correct according to the ODF 1.2 specification and is the same as what Excel does. However, it is different than what earlier versions of OpenOffice did, namely returning 0.0. We obviously cannot do both. I think the AOO 4.0.0 behavior is correct and should remain. I'd like to close the issue as NOTABUG. But I'd like to get a few more thoughts on this first. Regards, -Rob --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
