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.

-Rob

"David A. Wheeler" <>
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.

>