OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office-formula] A few miscellania

Since custom functions could have side-effects (unless we forbid it) we may want to nail down the behavior of this.  If all implementations agree on not short-circuiting, and at one of them (Excel) allows custom functions, then that would be my choice.

Optional param on LOG() makes sense.


"David A. Wheeler" <dwheeler@dwheeler.com> wrote on 07/13/2006 09:51:48 PM:

> Okay, here are some odd things:
> * On all spreadsheets I've tried, AND() and OR() do NOT short-circuit.
>    Should we PERMIT short-circuiting (implementation-defined), or FORBID it?
>    We could define ANDSC() and ORSC() for short-circuiting
> operations, I supposed,
>    but I hate to do that.
> * I plan to require handling one-arg AND() and OR(), as they're
> cheap "convert to logical"
>    functions, but say that zero-arg AND() and OR() can be Error or Logical
>    (most, maybe all spreadsheets produce an Error on zero-parameters)
> * I plan to change LOG() so that the second parameter is optional
> (default=10);
>    any objections?  Excel does that, as do many others.  OOo will
> have to change.
>    Interestingly, this is one of the differences that was
> highlighted in a long-ago
>    (and now obsolete) paper examining KOffice/OOo spreadsheet
> interoperability.

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]