Details

    • Type: Bug Bug
    • Status: Applied
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 CD 05
    • Fix Version/s: ODF 1.2 CD 06
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide
      Here are the proposed changes to CONVERT. (Editor: This includes citations for some non-obvious values, if you need to change the citation format feel free. None of these citations are normative.)

      In row "ly" (light-year), append this to the Description:
        , exactly (299792458 m/s) (3600 s/hr) (24 hr/day) (365.25 day).
        (Source: International Astronomical Union (IAU),
        "Measuring the Universe: The IAU and astronomical units", http://www.iau.org/public/measuring/).

      In row "bushel", append this to the Description:
       , exactly 2150.42 cubic international inches.
        (Source:
         National Institute of Standards and Technology (NIST),
         Appendix C of NIST Handbook 44, "Specifications, Tolerances, and Other Technical Requirements for Weighing and Measuring Devices",
          http://ts.nist.gov/WeightsAndMeasures/Publications/appxc.cfm)

      In row "parsec" or "pc", append this to the Description:
       , exactly AU/tan(1/3600 degree) where an AU is exactly 149,597,870.691 kilometers.
        (Source: International Astronomical Union (IAU),
        "Measuring the Universe: The IAU and astronomical units", http://www.iau.org/public/measuring/).
        A parsec is approximately 3.085677581E+16 m.

      In row "HP" (horsepower), REPLACE the old Description:
        Horsepower. The unit "h" is deprecated and should be replaced with "HP".
      with this Description:
        Mechanical horsepower aka Imperial horsepower.
        Exactly 550 foot-pounds per second.
        (SOURCE:
       National Institute of Standards and Technology (NIST),
        "The NIST Guide for the Use of the International System of Units", section B.9,
         http://physics.nist.gov/Pubs/SP811/appenB9.html).
        A horsepower is approximately 745.699871582 W.
        ("Unit Conversion Utility", http://www.metas.ch/metasweb/Themen/Masseinheiten/calculation/en_calculation_frame_umrechnungen.html)
       The unit "h" is deprecated and should be replaced with "HP".

      {NOTE: Wikipedia has a better description of horsepower, and we could cite a specific dated version, but some
      people have a Wikipedia allergy so I'm not citing http://en.wikipedia.org/wiki/Horsepower even though it is
      a far better source of information.).

      In row "PS" (horsepower), append this to the Description:
      , the amount of power to lift a mass of 75 kilograms in one second against the earth gravitation between a distance of one meter, approximately 735.49875 W
      (SOURCE: "Die gesetzlichen Einheiten in Deutschland" http://www.ptb.de/de/publikationen/download/pdf/einheiten.pdf ).

      {I can't read German, but I think this is accurate. Again, the Wikipedia article is more substantive:
      http://en.wikipedia.org/wiki/Horsepower
      but Wikipedia then cites this German document, so I'm trying to cite the authoritative source.}

      In row "uk_gal" (UK/Imperial gallon), append this to the Description:
       , 4.54609 liters.

      {I'm having trouble getting an authoritative source, so let's
      just use this. This can be computed from the existing text.
      This page: http://en.wikipedia.org/wiki/Imperial_units
      claims that "The Weights and Measures Act of 1985 switched to a gallon of exactly 4.54609 l"
      Unfortunately, later versions have removed that definition, so I didn't find its definition here:
      http://www.statutelaw.gov.uk/content.aspx?activeTextDocId=2191980
      }

      In row "uk_qt" (UK/Imperial quart), append this to the Description:
       , exactly 1/4 of a UK gallon.

      In row "uk_pt" (UK/Imperial pint), append this to the Description:
       , exactly 1/8 of a UK gallon.

      In row "pond", append this to the Description:
       , 9.80665E-3 N.

      {The most complete source of information on "pond" that I found was: http://en.wikipedia.org/wiki/Kilopond - I'm sure there are better sources, please assist if you can. However, this is completely consistent with the OOo value of "pond", where 1 N = 101.9716 pond, so I take this as confirmed.
      This is consistent with the official value of the Earth's gravitational force as defined by the third CGPM (1901, CR 70) definition of standard gravity, gn=9.80665 m/s2.}

      After the end of the first table in CONVERT, state:
      "If a conversion factor (as listed above) is not exact, an implementation may use a more accurate conversion factor instead."

      Also, in the first table (listing the function arguments) add the following sentence to the Description for to-unit and from-unit. "Additionally, unit names containing a 'FULL STOP' (U+002E) character may be used for implement-defined units"

      In row "gal" (Gallon (U.S. customary liquid measure)), append this to the Description:
       , 3.785411784 liters.
      Show
      Here are the proposed changes to CONVERT. (Editor: This includes citations for some non-obvious values, if you need to change the citation format feel free. None of these citations are normative.) In row "ly" (light-year), append this to the Description:   , exactly (299792458 m/s) (3600 s/hr) (24 hr/day) (365.25 day).   (Source: International Astronomical Union (IAU),   "Measuring the Universe: The IAU and astronomical units", http://www.iau.org/public/measuring/) . In row "bushel", append this to the Description:  , exactly 2150.42 cubic international inches.   (Source:    National Institute of Standards and Technology (NIST),    Appendix C of NIST Handbook 44, "Specifications, Tolerances, and Other Technical Requirements for Weighing and Measuring Devices",      http://ts.nist.gov/WeightsAndMeasures/Publications/appxc.cfm) In row "parsec" or "pc", append this to the Description:  , exactly AU/tan(1/3600 degree) where an AU is exactly 149,597,870.691 kilometers.   (Source: International Astronomical Union (IAU),   "Measuring the Universe: The IAU and astronomical units", http://www.iau.org/public/measuring/) .   A parsec is approximately 3.085677581E+16 m. In row "HP" (horsepower), REPLACE the old Description:   Horsepower. The unit "h" is deprecated and should be replaced with "HP". with this Description:   Mechanical horsepower aka Imperial horsepower.   Exactly 550 foot-pounds per second.   (SOURCE:  National Institute of Standards and Technology (NIST),   "The NIST Guide for the Use of the International System of Units", section B.9,     http://physics.nist.gov/Pubs/SP811/appenB9.html) .   A horsepower is approximately 745.699871582 W.   ("Unit Conversion Utility", http://www.metas.ch/metasweb/Themen/Masseinheiten/calculation/en_calculation_frame_umrechnungen.html)  The unit "h" is deprecated and should be replaced with "HP". {NOTE: Wikipedia has a better description of horsepower, and we could cite a specific dated version, but some people have a Wikipedia allergy so I'm not citing http://en.wikipedia.org/wiki/Horsepower even though it is a far better source of information.). In row "PS" (horsepower), append this to the Description: , the amount of power to lift a mass of 75 kilograms in one second against the earth gravitation between a distance of one meter, approximately 735.49875 W (SOURCE: "Die gesetzlichen Einheiten in Deutschland" http://www.ptb.de/de/publikationen/download/pdf/einheiten.pdf ). {I can't read German, but I think this is accurate. Again, the Wikipedia article is more substantive: http://en.wikipedia.org/wiki/Horsepower but Wikipedia then cites this German document, so I'm trying to cite the authoritative source.} In row "uk_gal" (UK/Imperial gallon), append this to the Description:  , 4.54609 liters. {I'm having trouble getting an authoritative source, so let's just use this. This can be computed from the existing text. This page: http://en.wikipedia.org/wiki/Imperial_units claims that "The Weights and Measures Act of 1985 switched to a gallon of exactly 4.54609 l" Unfortunately, later versions have removed that definition, so I didn't find its definition here: http://www.statutelaw.gov.uk/content.aspx?activeTextDocId=2191980 } In row "uk_qt" (UK/Imperial quart), append this to the Description:  , exactly 1/4 of a UK gallon. In row "uk_pt" (UK/Imperial pint), append this to the Description:  , exactly 1/8 of a UK gallon. In row "pond", append this to the Description:  , 9.80665E-3 N. {The most complete source of information on "pond" that I found was: http://en.wikipedia.org/wiki/Kilopond - I'm sure there are better sources, please assist if you can. However, this is completely consistent with the OOo value of "pond", where 1 N = 101.9716 pond, so I take this as confirmed. This is consistent with the official value of the Earth's gravitational force as defined by the third CGPM (1901, CR 70) definition of standard gravity, gn=9.80665 m/s2.} After the end of the first table in CONVERT, state: "If a conversion factor (as listed above) is not exact, an implementation may use a more accurate conversion factor instead." Also, in the first table (listing the function arguments) add the following sentence to the Description for to-unit and from-unit. "Additionally, unit names containing a 'FULL STOP' (U+002E) character may be used for implement-defined units" In row "gal" (Gallon (U.S. customary liquid measure)), append this to the Description:  , 3.785411784 liters.

      Description

      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

        Activity

        Hide
        Eike Rathke added a comment -
        With OOo
        > =CONVERT_ADD(1; "uk_gal"; "l")
        > produces the bizarre value:
        > 3.78623545651745000000
        is a bug, OOo3.3rc produces 4.5460855847
        Show
        Eike Rathke added a comment - With OOo > =CONVERT_ADD(1; "uk_gal"; "l") > produces the bizarre value: > 3.78623545651745000000 is a bug, OOo3.3rc produces 4.5460855847
        Hide
        Andreas Guelzow added a comment -
        Eike, obviously 3.78623545651745000000 is a bug but it is not that bizarre. That number is the same as =CONVERT_ADD(1; "gal"; "l") .

        Now, Gnumeric claims that 1 US gallon is 3.786235392 liters which is slightly different from OOo's conversion. I note that the OpenFormula draft is apparently mute on the exact value.

        I note that both Gnumeric's and OOo's value differ from the value given by Wikipedia and any other sites I can find: 3.785411784 liters
        Show
        Andreas Guelzow added a comment - Eike, obviously 3.78623545651745000000 is a bug but it is not that bizarre. That number is the same as =CONVERT_ADD(1; "gal"; "l") . Now, Gnumeric claims that 1 US gallon is 3.786235392 liters which is slightly different from OOo's conversion. I note that the OpenFormula draft is apparently mute on the exact value. I note that both Gnumeric's and OOo's value differ from the value given by Wikipedia and any other sites I can find: 3.785411784 liters
        Hide
        Patrick Durusau added a comment -
        OpenDocument-v1.2-cd05-part2-editor-revision-04.odt

        I did not apply:

        "Additionally, unit names containing a 'FULL STOP' (U+002E) character may be used for implement-defined units"

        None of our unit names have "FULL STOP" so it makes no sense.
        Show
        Patrick Durusau added a comment - OpenDocument-v1.2-cd05-part2-editor-revision-04.odt I did not apply: "Additionally, unit names containing a 'FULL STOP' (U+002E) character may be used for implement-defined units" None of our unit names have "FULL STOP" so it makes no sense.
        Hide
        Eike Rathke added a comment -
        Setting to "Edits rejected" for two reasons:

        1. Of course we do not define implementation-defined unit names, hence we wanted to provide a mechanism how implementations may define such unit names without interfering with existing names, i.e. such names shall contain a full stop character.

        2. the US gallon indeed is 3.785411784 liters according to several sources that say "One US gallon is 231 cubic inches which equals exactly to 3.785411784 liters.", so
        In row "gal" (Gallon (U.S. customary liquid measure)), append this to the Description:
         , 3.785411784 liters.
        Show
        Eike Rathke added a comment - Setting to "Edits rejected" for two reasons: 1. Of course we do not define implementation-defined unit names, hence we wanted to provide a mechanism how implementations may define such unit names without interfering with existing names, i.e. such names shall contain a full stop character. 2. the US gallon indeed is 3.785411784 liters according to several sources that say "One US gallon is 231 cubic inches which equals exactly to 3.785411784 liters.", so In row "gal" (Gallon (U.S. customary liquid measure)), append this to the Description:  , 3.785411784 liters.
        Hide
        Patrick Durusau added a comment -
        OpenDocument-v1.2-cd05-part2-editor-revision-04.odt
        Show
        Patrick Durusau added a comment - OpenDocument-v1.2-cd05-part2-editor-revision-04.odt

          People

          • Assignee:
            David Wheeler
            Reporter:
            Eric Patterson
          • Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: