Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-2242

EUROCONVERT: add reference to the European Commission's conversion rates; new rates may appear

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2 Part 2 CD 1
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      Change Summary from
      Converts a number from one to another Euro currency.

      to
      Converts a Number, representing a value in one European currency, to an equivalent value in another European currency, according to the fixed conversion rates defined by the Council of the European Union.

      Change Semantics from
      The function must be able to convert between the Euro ("EUR") and various older European countries. In this case, it must use the rates of exchange as set by the European Commission, as follows:

      to
      The function shall use the rates of exchange as set by the European Commission, as follows:

      Add to Semantics:

      As new member countries adopt the Euro, new conversion rates will become active and implementations may add them using the respective ISO 4217 codes and fixed rates as defined by the European Council, on the basis of a European Commission proposal.

      The European Commission's Euro entry page is http://ec.europa.eu/euro/
      The conversion rates and triangulation rules are available at http://ec.europa.eu/economy_finance/the_euro/joining_euro9405_en.htm with links to the European Council Regulation legal documents at the http://eur-lex.europa.eu/ European Union law database server.

      Show
      Change Summary from Converts a number from one to another Euro currency. to Converts a Number, representing a value in one European currency, to an equivalent value in another European currency, according to the fixed conversion rates defined by the Council of the European Union. Change Semantics from The function must be able to convert between the Euro ("EUR") and various older European countries. In this case, it must use the rates of exchange as set by the European Commission, as follows: to The function shall use the rates of exchange as set by the European Commission, as follows: Add to Semantics: As new member countries adopt the Euro, new conversion rates will become active and implementations may add them using the respective ISO 4217 codes and fixed rates as defined by the European Council, on the basis of a European Commission proposal. The European Commission's Euro entry page is http://ec.europa.eu/euro/ The conversion rates and triangulation rules are available at http://ec.europa.eu/economy_finance/the_euro/joining_euro9405_en.htm with links to the European Council Regulation legal documents at the http://eur-lex.europa.eu/ European Union law database server.
    • Resolution:
      Hide

      Did so. Added the EC's Euro URLs as note.

      Show
      Did so. Added the EC's Euro URLs as note.

      Description

      EUROCONVERT includes a table of the currently active fixed Euro conversion rates. This table may be extended by implementations as new Euro rates will be officially announced. Triangulation rules should be lined out or referenced.
      See also http://www.oasis-open.org/apps/org/workgroup/office-formula/email/archives/200912/msg00003.html and thread.

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              erack Eike Rathke (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: