openoffice-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From J├╝rgen Schmidt <>
Subject Re: Issue 122927 -- spreadsheet formula compatibility
Date Thu, 15 Aug 2013 13:34:02 GMT
On 8/15/13 3:06 PM, Rob Weir wrote:
> 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.

I tend to agree because the current behaviour is correct according the
specification and behaves as Excel which increase the interoperability
as well.

We should explain it and why we keep the change, the affected users
won't be happy but hopefully understand that long term the change is
better for all the current and future users ...


> Regards,
> -Rob
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message