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 ]

Robert Weir  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. Starting from the left, replace the first occurrence of the decimal separator character with the FULL STOP (U+002E) character
2. Remove all occurrences of the group separator
3. Remove all whitespace characters.
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

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, reduce the value of the returned number by a factor of 1/100 for each percent sign removed.

If, however, the string ends in a percent sign, remove the % and return 1/100th of the number corresponding to that string, according to the definition provided in XML Schema, Part 2, Section 3.2.4 .

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]