On Aug 15, 2013 3:06 PM, "Rob Weir" <robw...@apache.org> wrote: > > 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 dont understand why we cannot do both, most programming languages interpret falase==0 and true==1, that allows the use of boolean functions in calculations. rgds jan i > > 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 >
