OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

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

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

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

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


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