[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-formula] DECIMAL function and spaces
Hi David, On Tuesday, 2007-01-23 12:22:26 -0500, David A. Wheeler wrote: > I didn't reply earlier because I agree with you. It's leading spaces > that should be ignored. I can easily imagine an extended version of > decimal that accepted fractions (e.g., "1 1/2"), and obviously spaces > should NOT be ignored. I don't think such an extension should be > mandated by the standard (that's a fairly exotic extension), but we > should PERMIT it. Not in that function. DECIMAL's functionality is conversion from other bases, the "1 1/2" case doesn't fit there. Actually it's input related and VALUE should be able to parse it. Eike -- Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.