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] Updated: (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:all-tabpanel ]

David Wheeler  updated OFFICE-2893:
-----------------------------------

    Proposal: 
Section 6.13.28 NUMBERVALUE

Replace semantics with the following:

Converts given Text value X into Number. If X is a Reference, it is first dereferenced.

X is transformed according to the following rules:

1. Remove all occurrences of the group separator before any decimal separator
2. Starting from the left, replace the first occurrence of the decimal separator character with the FULL STOP (U+002E) character
3. Remove all whitespace characters (See 5.14).
4.  If the first character of the resulting string is a period FULL STOP (U+002E) then prepend a zero
5. If the string ends in one or more instances of PERCENT SIGN (U+0025) , remove the percent sign(s)

If the resulting string is a valid xsd:float, then return the number corresponding to that string, according to the definition provided in XML Schema, Part 2, Section 3.2.4.  If percent signs were removed in step 5, divide the value of the returned number by 100 for each percent sign removed.

If the string is not a valid xsd:float then return an error. 

[Note for Editor -- We should also add a normative reference for XML Schema, Part 2.  We can just copy the reference used in Part 1]

  was:
Section 6.13.28 NUMBERVALUE

Replace semantics with the following:

Converts given Text value X into Number. If X is a Reference, it is first dereferenced.

X is transformed according to the following rules:

1. Remove all occurrences of the group separator
2. Starting from the left, replace the first occurrence of the decimal separator character with the FULL STOP (U+002E) character
3. Remove all whitespace characters (See 5.14).
4.  If the first character of the resulting string is a period FULL STOP (U+002E) then prepend a zero
5. If the string ends in one or more instances of PERCENT SIGN (U+0025) , remove the percent sign(s)

If the resulting string is a valid xsd:float, then return the number corresponding to that string, according to the definition provided in XML Schema, Part 2, Section 3.2.4.  If percent signs were removed in step 5, divide the value of the returned number by 100 for each percent sign removed.

If the string is not a valid xsd:float then return an error. 

[Note for Editor -- We should also add a normative reference for XML Schema, Part 2.  We can just copy the reference used in Part 1]


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