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-2893) 6.13.28: NumberValue- text interpretation not defined for all symbols



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

Eike Rathke commented on OFFICE-2893:
-------------------------------------

Referring XML Schema, Part 2, Section 3.2.4.1may work, provided we exclude -INF,INF,Nan, and also say that the integer part of the mantissa may be empty if the decimal part is not, this is to allow ".1" and such to be parsed as 0.1 and the source of the regex allowing +% and +e+10

Regarding rewriting rules:

1) Replace all occurrences of the decimal separator character with the ',' character
I guess that should had been '.' (dot) character instead.

2) Remove all occurrences of the group separator
That doesn't work. The group separator is only to be ignored until a decimal separator is encountered. So this should be instead
2) Remove all occurrences of the group separator left of the (first) decimal separator

3) Remove all whitespace characters.
No, only remove space (left of decimal separator) if given as GroupSeparator argument.
However, we could define that leading and/or trailing whitespace may be consumed.


Interpret a trailing '%' as percentage / "divide by 100".


> 6.13.28: NumberValue - text interpretation not defined for all symbols
> ----------------------------------------------------------------------
>
>                 Key: OFFICE-2893
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2893
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: Needs Discussion, OpenFormula
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Eric Patterson
>            Assignee: Robert Weir 
>             Fix For: ODF 1.2 CD 06
>
>
> The Numbervalue function includes a regular expression of the acceptable text strings, but doesn't specify how to interpret them.  Specifically, the percent sign (%) and exp (eE).  For percent, is everything to the left divided by 100?

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