Contact

EUROCONVERT Function (LibreOffice Calc)

Math Beginner LibreOffice Calc

Convert fixed euro legacy-currency amounts in LibreOffice Calc and distinguish final rounding from optional euro triangulation precision.

Verification status: Eight ordinary EUROCONVERT formulas were recalculated through XLSX import and separate ODS export in LibreOfficeDev 26.8.0.0.alpha0, build 2c87e51eeaa2b413ff4ae097b2705eea1995d8e5, using a forced-recalculation profile. Saved identities, numeric results and both controls were checked. This is headless development-build evidence; no stable-release, 26.8.1.1 or GUI execution is claimed. How formula examples are checked

Quick answer: =EUROCONVERT(100;"EUR";"DEM") returned 195.58 in the scoped LibreOffice development-build check below.

Availability and version history

  • Introduced: First release not established; present in LibreOffice 26.8 Help; earlier presence was not established here.
  • Supported in: LibreOffice 26.8 Help and 26.8.1.1 source. No retirement is established.
  • Scope: English desktop Calc formulas with semicolon separators; execution below used a development build.
  • Checked: October 14, 2026. Eight ordinary formulas were recalculated headlessly in LibreOfficeDev 26.8.0.0.alpha0, build 2c87e51eeaa2b413ff4ae097b2705eea1995d8e5. No stable-release or GUI execution is claimed.

What EUROCONVERT calculates

EUROCONVERT uses built-in fixed conversion factors between the euro and supported national currencies. It does not retrieve live foreign-exchange prices. Its historical-currency purpose does not mean the function itself is retired: it remains documented and implemented in the inspected LibreOffice versions. Function-specific Help.

Syntax and arguments

EUROCONVERT(Value; "From_currency"; "To_currency" [; Full_precision [; Triangulation_precision]])
  • Value: Numeric amount to convert.
  • From_currency / To_currency: Quoted supported currency codes, such as "DEM" and "EUR". The inspected code compares them without ASCII case sensitivity.
  • Full_precision: Optional boolean, default false. False applies the destination currency’s final rounding; true suppresses that final rounding.
  • Triangulation_precision: Optional decimal places for the intermediate euro amount. Omission leaves that intermediate unrounded. If supplied, the source floors the value and requires at least 3; supply Full_precision before this fifth argument.

Eight reproducible examples

All eight formulas were recalculated in the exact development build above. The independent column uses high-precision arithmetic; the final column is separately rounded from the saved native numeric value. Values are shown to at most twelve decimal places, so a last-place display difference is possible.

Formula Independent reference Saved development-build result
=EUROCONVERT(100;"EUR";"DEM") 195.58 195.58
=EUROCONVERT(100;"DEM";"EUR") 51.13 51.13
=EUROCONVERT(100;"ATS";"EUR") 7.27 7.27
=EUROCONVERT(100;"EUR";"ITL") 193627 193627
=EUROCONVERT(100;"DEM";"EUR";1) 51.129188119622 51.129188119622
=EUROCONVERT(100;"DEM";"FRF";1) 335.385488513828 335.385488513828
=EUROCONVERT(100;"DEM";"FRF";0;3) 335.38 335.38
=EUROCONVERT(100;"DEM";"EUR";1;3) 51.129 51.129

Practical worksheet

Put the old-currency amount 100 in A2, DEM in B2 and EUR in C2. Then =EUROCONVERT(A2;B2;C2) matches the second tested case and returns 51.13. Cell formatting can display €51.13, but formatting itself does not change the currency or perform a conversion.

Keep the original amount and code alongside the converted result. For a total, decide whether your calculation needs the sum of individually rounded converted amounts or a single conversion of the aggregate amount. These need not agree because rounding is nonlinear; document the chosen procedure rather than hiding it in formatting.

Advanced interpretation and checks

The fixed rate for DEM is 1.95583 units per euro. Thus the unrounded conversion of 100 DEM is 100/1.95583, approximately 51.129188119622 EUR. With Full_precision=1, that intermediate value is returned without final two-decimal rounding.

For DEM to FRF, the path divides by 1.95583 and multiplies by 6.55957. Without intermediate rounding and with full precision, the result is approximately 335.385488513828 FRF. Specifying triangulation precision 3 first rounds the euro amount to 51.129; applying the FRF factor and final two-decimal rounding gives 335.38.

Full_precision does not override an explicitly requested triangulation rounding. =EUROCONVERT(100;"DEM";"EUR";1;3) returns 51.129, even though final rounding is disabled. When the source currency is already EUR, the inspected implementation multiplies directly and has no intermediate euro-rounding step. Identical recognized source and destination codes return the original amount unchanged. Inspected implementation.

Boundaries and troubleshooting

The inspected source recognizes EUR, ATS, BEF, DEM, ESP, FIM, FRF, IEP, ITL, LUF, NLG, PTE, GRD, SIT, MTL, CYP, SKK, EEK, LVL, LTL, HRK and BGN. That list is version-scoped implementation evidence, not an adoption-date history or a claim that every listed code was individually executed here.

BEF, ESP, ITL and LUF use zero destination decimal places in the inspected table; the other listed codes use two. This is why 100 EUR becomes 193627 ITL without a decimal fraction. Only the five currencies appearing in the eight examples were exercised. Unsupported codes and invalid precision values were not executed. This fixed-rate function is separate from configured legacy CONVERT_OOO conversions and from unit-conversion functions.

Official evidence and checking scope

The XLSX formulas were recalculated with a forced-recalculation profile and exported to a separate ODS file. The deliberately stale SUM cache changed to 3, and the uncached SUM returned 7. All eight function identities and numeric results were checked against the saved XML and independent calculations. The execution was headless in the exact development build named above; the separately inspected 26.8.1.1 source was not executed. Invalid-domain cases were not tested.