office-formula message
[Date Prev]
| [Thread Prev]
| [Thread Next]
| [Date Next]
--
[Date Index]
| [Thread Index]
| [List Home]
Subject: Re: [office-formula] A few miscellania
- From: robert_weir@us.ibm.com
- To: office-formula@lists.oasis-open.org
- Date: Fri, 14 Jul 2006 16:23:20 -0400
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" <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]