=ROUND(value;[digits])

The square brackets around [digits] indicate that the argument is optional; do not type the brackets in the formula.

These semantics and the syntax are directly specified by the official KDE ROUND entry. The release-specific Calligra 26.08.2 function registry also registers ROUND in math.cpp; registry presence is not proof that all arithmetic cases were tested in an installed build (pinned registration).

Use a semicolon between the two arguments in the English KDE examples. Decimal notation may depend on locale; use the function editor to confirm your local argument separator. Excel’s English examples generally use a comma and treat its num_digits argument as required, whereas KDE documents digits as optional. Do not automatically paste Excel syntax into Calligra without checking. KDE · Microsoft’s rounding documentation.

Create a sheet with label Raw measurement in B1 and the following inputs in B2:B6. The values must be numbers rather than quoted strings.

In C1 enter Rounded to one decimal. Enter this in C2 and fill through C6:

=ROUND(B2;1)

Expected C2:C6: 1.2, 1.2, 1.2, -12.3, 18.8. These are independently calculated expected values, not Calligra execution observations; local numeric display and floating-point behaviour still require native validation. For a directly supported reference check with a less ambiguous fraction, enter:

=ROUND(B6;2)

Expected: 18.76 (18.762 rounded to two places). Try these two standalone reference examples as well:

=ROUND(1.258;2)
=ROUND(-12.25;-1)

Expected: 1.26 and -10, exactly as reported in the KDE ROUND examples. The second one rounds to tens, not to a decimal place.

With the same B2:B4 measurements, compare the two approaches:

=SUM(ROUND(B2;1);ROUND(B3;1);ROUND(B4;1))
=ROUND(SUM(B2:B4);1)

Expected results: 3.6 for the first formula because 1.2 + 1.2 + 1.2 = 3.6; 3.7 for the second because 1.24 + 1.24 + 1.24 = 3.72, rounded once to one decimal place. This illustrates a real reporting decision: rounding each row changes the result relative to adding full-precision inputs first. SUM’s semicolon-separated form and range form are documented in its official entry. Decide which policy applies to your reporting and state it explicitly.

For a whole-number result without a second argument:

=ROUND(B6)

Expected: 19, using the handbook’s documented digits default of zero.

• Not the expected number of digits: Ensure digits is a whole number and that it is positive for decimals, zero or omitted for a whole number, and negative for tens/hundreds. ROUND(123.4;-1) is expected to be 120, not 123.4.
• Rounding a total gives another answer: Compare SUM(ROUND(...)) to ROUND(SUM(...)) as above. This difference can be legitimate; do not silently change either method.
• Cell still displays too many or too few decimals: The cell’s display format is separate from a value returned by ROUND. Inspect the actual formula result and numeric formatting before treating a display issue as a calculation failure.
• Unexpected error: Inspect missing parentheses, extra arguments, separator punctuation and values imported as text. KDE documents the first argument as numeric and the second as a whole number; the handbook does not guarantee a particular error code for every invalid input.
• Exact half-way values: Decimal values and floating-point representations can have edge cases. this guide does not claim to establish Calligra’s complete tie-breaking behaviour. If your accounting rules depend on an exact tie or statutory rounding standard, run native version-matched tests before approval.
• Results do not update: Verify that recalculation is enabled. The KDE Simple Sums guide explains recalculation and formula troubleshooting; menu names may differ by release.

Excel, LibreOffice Calc, and Calligra Sheets provide ROUND-style operations, but argument separators depend on application/locale. A material documentation difference is that Calligra’s official syntax explicitly makes digits optional (ROUND(value;[digits])), while Microsoft’s English Excel guidance describes a two-argument ROUND(number, num_digits) function. Do not infer that workbook imports always recalculate identically, especially on half-way decimal cases. No cross-application import test was carried out. Calligra ROUND · Microsoft Excel rounding.

• Calligra Sheets function index — navigation pending manual live check.
• IF function in Calligra Sheets
• KDE ROUND function section — exact syntax, default and worked examples.
• KDE SUM function section — advanced aggregation example.
• KDE Gear 26.08.2 announcement — release announcement on October 8, 2026.

• Calligra Sheets — function documentation
• pinned registration
• official entry
• KDE Simple Sums guide
• KDE Gear 26.08.2 announcement

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Calligra Sheets.

• No genuine Calligra Sheets screenshots are included; this guide does not use mock application images.