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] Our next adventure: Types and conversions

Hi robert_weir,

On Mon, May 22, 2006 at 17:08:27 -0400, robert_weir@us.ibm.com 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.


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommitee's list.

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