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


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

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