[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 - NEEDS-DISCUSSION
[ http://tools.oasis-open.org/issues/browse/OFFICE-3492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=23153#action_23153 ]
David Wheeler commented on OFFICE-3492:
----------------------------------------
Andreas Guelzow, thanks for pointing out that:
http://laws.justice.gc.ca/PDF/Statute/W/W-6.pdf
gives 1 gallon = 454 609/100 000 000 cubic metre (.454609 L).
That is an official source for UK gallons, the problem is that we have competing sources.
Looking at existing implementations is even more confusing.
Excel 2007 doesn't have uk_gallon, but it does have uk_pt, and:
=CONVERT(1,"uk_pt","l")*8
produces:
4.546085585
=CONVERT_ADD(1; "uk_gal"; "l")
produces the bizarre value:
3.78623545651745000000
> Undefined units for Convert Function - NEEDS-DISCUSSION
> -------------------------------------------------------
>
> 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: Needs Discussion, OpenFormula
> Affects Versions: ODF 1.2 CD 05
> Reporter: Eric Patterson
> Assignee: David Wheeler
> 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
-
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]