EUROCONVERT Function (Calligra Sheets)

• Introduced: First release not established; the name is present in Calligra 2.4.0 source.
• Supported in: Calligra Sheets 26.08.2, with the limitations described here; no retirement established.
• Scope: Desktop Sheets with the Financial module. Formulas use English names and semicolon separators.
• Checked: October 14, 2026: selected 25.04.2 engine-library formulas and independent reconstructions; 26.08.2 source only. The test locale was C. No GUI-cell, import or other-locale execution is claimed.

EUROCONVERT converts an amount between codes in Calligra’s fixed euro-factor table. If source and target factors are units per euro, the calculation is amount * target_factor / source_factor. It neither fetches live rates nor accepts arbitrary currency pairs. Official function reference.

=EUROCONVERT(amount;source_currency;target_currency)

Exactly three arguments are required: the amount, source code and target code. Code comparison is case-insensitive but does not trim spaces. There is no fourth FullPrecision argument or fifth triangulation-precision argument in this registered function. Registration and implementation.

Quotation marks identify text results; error tokens without quotes are actual errors. Numeric results are rounded here to twelve decimal places. The reconstruction column applies independent decimal arithmetic or the inspected character/parser rules, rather than claiming another application test.

Enter 100 in A2, DEM in B2 and FRF in C2. The worksheet formula =EUROCONVERT(A2;B2;C2) corresponds to the tested 100 DEM-to-FRF case and returns approximately 335.385488513828. Reversing the currencies changes the conversion: 100 FRF-to-DEM is approximately 29.816436138344. Keep the amount numeric and codes in separate validated columns so that changing a label does not silently change the meaning of an amount.

The DEM-to-FRF computation is 100*6.55957/1.95583; the implementation performs that expression directly in binary64. It does not round an intermediate euro amount or the final result to two decimals. Apply an explicit final presentation or rounding policy only when your application requires one, and retain the unrounded value for reconciliation.

The executed nested conversion below converts 100 DEM to FRF and back to DEM. Its result is 100 for the retained case. This is a useful consistency check for the reciprocal fixed factors, not a guarantee that every floating-point round trip is bit-exact. Negative amounts are accepted and preserve their sign. The LUX spelling is the helper’s historical compatibility alias for LUF, rather than an additional distinct rate.

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

The executed result was 100.

Unsupported source or target codes produce #NUM!: the table does not contain USD, HRK or BGN in the inspected versions. Whitespace is not stripped from codes. Missing arguments or adding a fourth argument produces #VALUE!; do not copy a longer syntax from another spreadsheet product.

The amount-conversion path is permissive. The tested numeric string "100" converts successfully, while "abc" becomes zero and produces a numeric zero conversion. Validate the amount before calling the function; a successful zero result can mask nonnumeric imported data. These fixed-factor calculations do not establish legal rounding requirements for a payment or historical accounting record.

• Function-specific implementation
• Versioned help
• Euro Factors
• Float Conversion
• String Conversion

The financial module is byte-identical in the inspected 25.04.2 and 26.08.2 sources. This comparison does not establish later-version execution or legal monetary-rounding requirements.

ROUND, PRODUCT, SUM.