[OASIS Issue Tracker] Commented: (OFFICE-2641) [NEEDS-DISCUSSION]Redefine ill-defined NUMBERVALUE

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ http://tools.oasis-open.org/issues/browse/OFFICE-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18802#action_18802 ] 

Eike Rathke commented on OFFICE-2641:
-------------------------------------

We need a constraint that DecimalSeparator shall not occur in GroupSeparator. Otherwise 1.000 could be either 1 or 1000 with DecimalSeparator="." and GroupSeparator=".", for example.

Regarding the space character, U+0020 SPACE and U+00A0 NO-BREAK SPACE should be treated equivalent, as many numbers come formatted with NBSP as the group separator but authors would want to input SPACE instead as argument.

I also suggest to rename GroupSeparator to GroupSeparators for clarity.

If we say "skip any characters of GroupSeparators", does  that include leading and trailing GroupSeparators as in ",123" or "123," and multiple GroupSeparators as in "1,,,2", and text like "12,.34" if DecimalSeparator was "."? I'd say GroupSeparators shall be ignored only between digits.

Add that if T can not be parsed into a Number an Error shall be returned.

Not sure about fractions, I tend to not accept them.

> [NEEDS-DISCUSSION] Redefine ill-defined NUMBERVALUE
> ---------------------------------------------------
>
>                 Key: OFFICE-2641
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2641
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Improvement
>          Components: OpenFormula
>            Reporter: Eike Rathke
>            Assignee: Eike Rathke
>             Fix For: ODF 1.2 Part 2 CD 3
>
>
> The current definition of 5.13.28 NUMBERVALUE is not sufficient.
> Initial idea at http://lists.oasis-open.org/archives/office-formula/200901/msg00011.html
> See also http://lists.oasis-open.org/archives/office-formula/200703/msg00104.html

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira