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-2629) OpenFormula 5.16.18CONVERT Use of Unit Symbol Prefixes and Case-Sensitivity Unclear

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

Dennis Hamilton commented on OFFICE-2629:

OFF TOPIC: Just for fun, it is useful to take a look at Calculator Plus 1.0, a freebie from Microsoft that provides 25-decimal-digit precision for most things, uses pure rationals whenever and as long as it can, and has an amazing set of conversions.  I suspect there are similar open-source packages available.


With this gizmo, PI() = 3.1415926535897932384626433832795

I counted 45 different units for length, including Hungarian fathoms, many Asian units, and lets not forget chains and furlongs.  

They offer up 9460528405000000 as the number of meters in a light year.

For floating currencies, they will go on-line and get the latest exchange rate from the European Central Bank.   They also have the irrevocable exchange rates where a currency was fixed on the Euro.  For example, there is the handy note on Italian Lire to Euro that as of Friday, January 1, 1999, 1 Italian Lira was fixed at 5.1645689908948648690523532358607e-4 Euro.  Of course, nothing was done at 1 Lira any more, and no one made change at that level.  (This impacts how the financial functions work in a given currency too, but we needn't  go into that here.  Are there 0.01 Euro coins or do they start at 0.05 or 0.10 Euro?  There seem to be 45 currencies, including the Euro.)

A command-line counterpart of this instrument or lone like it would be very handy for manufacturing test cases.  Good codefest project.

> OpenFormula 5.16.18 CONVERT Use of Unit Symbol Prefixes and Case-Sensitivity Unclear
> ------------------------------------------------------------------------------------
>                 Key: OFFICE-2629
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2629
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2 Part 2 CD 1
>            Reporter: Dennis Hamilton
>            Assignee: Eike Rathke
>             Fix For: ODF 1.2 Part 2 CD 3
> The ways that unit prefixes are applied to the unit symbols is not specific enough and subject to misinterpretation.
> Also, the case sensitivity of unit symbols, if any, is not specified.
> Finally, the unit symbols in the table should be expressed in a monospace style that clearly differentiates between capital "I" and lower-case "l", etc.

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]