[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=18747#action_18747 ] 

David Wheeler  commented on OFFICE-2641:
----------------------------------------

Also, I think GroupSeparator (type Text) should be a text entry with 0 or more characters.  All characters in this parameter should be simply ignored from the input.  That way, if someone is dealing with data that has "1,000.00" and "1 000.00", with "." as the decimal separator, they could work if ", " (comma space) was the groupseparator.

We need to make it clear that exponential values, e.g., "1E10", are fine.

Should we also accept fractions, e.g., "1 1/3" or "5/6"?



> [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