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] REGEX for Value and NumberValue functions

Hi Eric,

Sorry, this went unanswered..

On Friday, 2010-04-09 23:49:20 +0000, Eric Patterson wrote:

> The REGEX for the VALUE and NUMBERVALUE functions appear to allow text
> like "$1%"

That would result in 0.01, I don't see a problem with that one.

> and in the case of NUMBERVALUE, strings like "1,2,,,,,1" or
> ",,,".
> Is the normative text: " If the supplied text X cannot be converted
> into a number, an error is returned." enough here, or do we need to
> update the schema?

The schema can't represent the group separator exactly, as also the
grouping, not only the group separator, is locale dependent, i.e. in
en-US 123,456,789.01 is a valid number, in hi-IN it would be

We could only provide different schemas as an example.

However, this reminds me of a proposal I wrote a year ago that never was
picked up for discussion. I herewith revive that, please investigate

I created http://tools.oasis-open.org/issues/browse/OFFICE-2641 for


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

PGP signature

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