Contact
12 programs
Explore the site

EUROCONVERT Function in OpenOffice Calc

Financial Intermediate OpenOffice Calc OpenOffice.org 3.1

Convert historical euro currencies in OpenOffice Calc with EUROCONVERT. Worked rounding and triangulation examples, supported codes and version history.

Verification status: Official release source and independently calculated examples for EUROCONVERT were reviewed. No new Apache OpenOffice Calc application execution is claimed for this guide; the stated version and example limits still apply. How formula examples are checked

EUROCONVERT converts between the euro and supported former European national currencies using fixed historical conversion factors. For example, =EUROCONVERT(125;"EUR";"DEM") returns 244.48 German marks after the destination rounding rule is applied. It does not download current exchange rates.

Availability and version history

  • First introduced: OpenOffice.org 3.1, as documented in the official 3.1.0 release notes.
  • Current status: supported in Apache OpenOffice 4.1.16 desktop Calc; the enabled function registry and implementation are present in the AOO4116-GA release tag.
  • Last supported version: no final supported version or retirement date established. The currencies are historical; the function remains supported in the checked release.
  • Scope: built-in desktop Calc conversion using a finite fixed-rate currency table. It is not a general live foreign-exchange service.
  • Test status: not executed in Apache OpenOffice. Worked numeric results were calculated independently and the principal examples were cross-checked in LibreOfficeDev 26.8.0.0.alpha0 (build 2c87e51eeaa2b413ff4ae097b2705eea1995d8e5). This is supplementary evidence, not an OpenOffice native test.
  • Evidence checked: 2026-10-14.

Sources: OpenOffice.org 3.1.0 release notes, EUROCONVERT Help source, Apache OpenOffice 4.1.16 implementation.

Syntax and arguments

EUROCONVERT(Value; From_currency; To_currency; [Full_precision]; [Triangulation_precision])
Argument Required? Meaning
Value Required Amount to convert.
From_currency Required Quoted supported source code, such as "DEM".
To_currency Required Quoted supported destination code, such as "EUR".
Full_precision Optional FALSE or omitted applies destination rounding. TRUE keeps the calculated result without that final rounding.
Triangulation_precision Optional Decimal places for the intermediate euro amount. If supplied, the value must be at least 3 after flooring. Omission leaves that intermediate unrounded.

Use semicolons between arguments. The final two arguments are different controls: one determines final rounding, and the other can round the intermediate euro value when converting from a non-euro currency.

Worked example: reproduce a historical euro-to-mark amount

Enter 125 in A2. In B2 enter:

=EUROCONVERT(A2;"EUR";"DEM")

Expected result: 244.48. The fixed factor is 1.95583 DEM per EUR, so 125 × 1.95583 = 244.47875. The default final rounding for DEM uses two decimal places.

In C2 enter:

=EUROCONVERT(A2;"EUR";"DEM";TRUE())

Expected result: 244.47875. Format the cell to display at least five decimal places when comparing it with B2. Changing the display format alone does not undo a function result that was already rounded.

Advanced example: control triangulation explicitly

To convert 100 DEM to FRF while rounding the intermediate euro amount to three decimal places:

=EUROCONVERT(100;"DEM";"FRF";TRUE();3)

Expected result: 335.38425453.

  1. Convert to euros: 100 ÷ 1.95583 ≈ 51.1291881196.
  2. Round that intermediate amount to three decimal places: 51.129.
  3. Convert to francs: 51.129 × 6.55957 = 335.38425453.
  4. TRUE leaves the final value unrounded. Replacing TRUE with FALSE gives 335.38.

If an accounting rule requires a particular rounding sequence, make the optional arguments explicit. Do not assume that setting a number format changes the intermediate calculation.

Supported currency codes in the checked version

Apache OpenOffice 4.1.16’s implementation includes EUR, ATS, BEF, DEM, ESP, FIM, FRF, IEP, ITL, LUF, NLG, PTE, GRD, SIT, MTL, CYP, SKK, EEK, LVL, LTL and HRK. This is a version-scoped table, not a promise that every earlier release contains every code. USD, GBP and other unsupported codes are not added by changing the spreadsheet’s currency format.

The destination’s rounding precision is also part of the fixed table. For example, the implementation rounds BEF, ESP, ITL and LUF to zero decimal places by default; several other supported currencies use two. Consult the versioned conversion table for the actual rules rather than assuming every currency uses two decimals.

Common problems

  • Unsupported code: an unrecognized currency produces an invalid-argument error. Check the three-letter code and the version-specific table.
  • Precision below 3: explicitly supplying a triangulation precision below 3 produces an invalid-argument error. Omitting this argument is different from supplying zero.
  • Unexpected rounding: default Full_precision is FALSE. Compare both the stored result and the cell’s display format.
  • Same source and destination: the checked implementation returns the original value when the currency codes are the same; it does not perform the normal cross-currency rounding branch.
  • Live-rate assumption: this function cannot price a present-day USD/EUR transaction. Use a separately obtained, appropriately dated exchange rate for that task.

Apache’s official CONVERT documentation is a separate legacy conversion facility. Apache’s Help specifically recommends EUROCONVERT for the historical euro-currency conversions discussed here. Do not substitute CONVERT_ADD, which handles measurement units, without first checking the intended operation.