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=22296#action_22296 ] 

David Wheeler  commented on OFFICE-2893:

Thanks, everyone, for helping address this.

To answer Robert Weir's question: This is one of the EXTREMELY rare cases where the committee invented a function. As noted above, Gnumeric then went and implemented it, so it's no longer an unimplemented function.  The issue was that there was no function that could take text and convert it reliably into a number without locale issues.  Given that the language is designed to process numbers, that seemed to be a problem, and it was an internationalization issue (and the committee has tried to be very sensitive to internationalization issues).  This text-to-string need is especially an issue when the text values come from external sources.  Early proposals proposed to take a text to convert and a locale value, but that turned out to be extremely complex.  In practice, what you really need to do is to say if "." or "," is the decimal separator, and possibly handle a group separator, which is easy to implement and greatly improves the formula language's internationalization.

> 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: OpenFormula
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Eric Patterson
>            Assignee: David Wheeler 
>             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]