OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

# office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [OASIS Issue Tracker] Commented: (OFFICE-3492) Undefined units forConvert Function

• From: OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>
• To: office@lists.oasis-open.org
• Date: Wed, 27 Oct 2010 18:41:15 -0400 (EDT)

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

David Wheeler  commented on OFFICE-3492:
----------------------------------------

We should only include exact values in the specification.  That way, no matter what numeric model is used, the result can be accurate within the numeric model.

I don't think some of these values in the proposal are exact. Can you confirm that they are all exact?  In particular, the reciprocal of a value is almost never exact in practice.  In addition, I don't think you need to give the conversion directly to SI.  As long as you give the exact conversion to something that CAN be converted to SI, I think that's fine.

Thus, we should NOT state that "bushel": 1 L = 0.0283775933 bushel, because I believe that is not exact.

Instead, we should just state that:
1 bushel = 2150.42 cubic inch

Implementors can easily use that information to figure out the rest.

Also, regarding "The standard acceleration of gravity in free fall is 9.80665 m/s2.", yes, we do need to state this somewhere.  The acceleration of gravity on Earth actually varies depending on where you are on the Earth.  So for a "standard acceleration" there could be many possible values, and we need to specify one.

> Undefined units for Convert Function
> ------------------------------------
>
>                 Key: OFFICE-3492
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3492
>             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: Eike Rathke
>            Priority: Critical
>             Fix For: ODF 1.2 CD 06
>
>
> There are still a number of units that are undefined and cannot be implemented as described.  These should all be defined with numbers.
> "ly" *	Light-year, the distance light travels, in a vacuum, in a Julian year of 365.25 days
> "parsec" or "pc" *	Distance from sun to a point having heliocentric parallax of one second (used for stellar distance)*
> "PS"	PferdestÃ¤rke (German "horse strength", close but not identical to "HP")
> "bushel"	U.S. bushel (not Imperial bushel), interpreted as volume
> "uk_gal"	U.K. / Imperial gallon
> "uk_qt"	U.K. / Imperial quart
> Also, for "pond", there is a need to specify what to use for acceleration due to gravity
> "pond" *	Pond, gravitational force on a mass of one gram

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