Re: Issue 122927 -- spreadsheet formula compatibility

2013-08-15 Thread Rob Weir
On Thu, Aug 15, 2013 at 10:35 AM, sebb wrote: > On 15 August 2013 15:21, Rob Weir wrote: >> On Thu, Aug 15, 2013 at 10:07 AM, sebb wrote: >>> On 15 August 2013 14:47, Rob Weir wrote: On Thu, Aug 15, 2013 at 9:41 AM, janI wrote: > On Aug 15, 2013 3:06 PM, "Rob Weir" wrote: >>

Re: Issue 122927 -- spreadsheet formula compatibility

2013-08-15 Thread sebb
On 15 August 2013 15:21, Rob Weir wrote: > On Thu, Aug 15, 2013 at 10:07 AM, sebb wrote: >> On 15 August 2013 14:47, Rob Weir wrote: >>> On Thu, Aug 15, 2013 at 9:41 AM, janI wrote: On Aug 15, 2013 3:06 PM, "Rob Weir" wrote: > > https://issues.apache.org/ooo/show_bug.cgi?id=122927

Re: Issue 122927 -- spreadsheet formula compatibility

2013-08-15 Thread Rob Weir
On Thu, Aug 15, 2013 at 10:07 AM, sebb wrote: > On 15 August 2013 14:47, Rob Weir wrote: >> On Thu, Aug 15, 2013 at 9:41 AM, janI wrote: >>> On Aug 15, 2013 3:06 PM, "Rob Weir" wrote: https://issues.apache.org/ooo/show_bug.cgi?id=122927 It boils down to how an IF() statement

Re: Issue 122927 -- spreadsheet formula compatibility

2013-08-15 Thread sebb
On 15 August 2013 14:47, Rob Weir wrote: > On Thu, Aug 15, 2013 at 9:41 AM, janI wrote: >> On Aug 15, 2013 3:06 PM, "Rob Weir" 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

Re: Issue 122927 -- spreadsheet formula compatibility

2013-08-15 Thread Rob Weir
On Thu, Aug 15, 2013 at 9:47 AM, Rob Weir wrote: > On Thu, Aug 15, 2013 at 9:41 AM, janI wrote: >> On Aug 15, 2013 3:06 PM, "Rob Weir" wrote: >>> >>> https://issues.apache.org/ooo/show_bug.cgi?id=122927 >>> >>> It boils down to how an IF() statements are evaluated. >>> >>> Remember, the typical

Re: Issue 122927 -- spreadsheet formula compatibility

2013-08-15 Thread Rob Weir
On Thu, Aug 15, 2013 at 9:41 AM, janI wrote: > On Aug 15, 2013 3:06 PM, "Rob Weir" 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

Re: Issue 122927 -- spreadsheet formula compatibility

2013-08-15 Thread janI
On Aug 15, 2013 3:06 PM, "Rob Weir" 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

Re: Issue 122927 -- spreadsheet formula compatibility

2013-08-15 Thread Jürgen Schmidt
On 8/15/13 3:06 PM, Rob Weir 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 C

Issue 122927 -- spreadsheet formula compatibility

2013-08-15 Thread Rob Weir
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 lea