[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. Eike -- 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]