Hi robert_weir,
On Mon, May 22, 2006 at 17:08:27 -0400, wrote:
> > A. Logical is REQUIRED to be distinct from Number.
>
> How about A, but allow automatic conversion to Number type? I believe
> this is different from C, in that the conversion from Number to Logical
> would not be automatic.
Which basically is the same I suggested.
> > Next up: how do they interact? In particular: if a function
> > expects a Number but gets a Text value, then what?
>
> Generally I'd rather give an error than to do something which has a good
> chance of being wrong.
> [...]
> So, auto-conversion to text in the general case is dangerous,
See .sig ;-)
> So, I think I'm suggesting E, without A1 and without A2. So, an error for
> a naked use of text in the context of a number, but allow
> Value(text;locale) and value(text) to avoid the error.
Again we made the same suggestion.
Eike
--
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets. --Robert Weir on the OpenDocument formula subcommitee's list.
