TRUNC in Collabora Office: Remove Digits by Rounding Toward Zero

• Introduced: original Collabora release and launch date are not established by the sources reviewed.
• Availability: documented in Collabora Office 26.04 help, scoped to the desktop-help release.
• Platform scope: support in every online or mobile deployment is not inferred from desktop documentation.
• Checked: October 14, 2026. Complete function-specific documentation and independent arithmetic controls; no native Collabora test was performed.

=TRUNC(number[;count])

number is the numeric input. Optional count is the number of decimal places to retain; its default is 0. A negative count operates to the left of the decimal separator: -1 retains tens, -2 retains hundreds.

Collabora explicitly documents TRUNC as equivalent to ROUNDDOWN. The direction is toward zero for either sign. It is not the same as always moving to the smaller number on a number line.

Examples use English names and semicolon separators. Precision controls are integers; fractional precision and type coercion are outside the verified examples.

=TRUNC(21.89)
=TRUNC(-21.89)
=TRUNC(0.664;2)
=TRUNC(-0.664;2)

Expected results are 21, -21, 0.66 and -0.66. Positive values decrease toward zero; negative values increase toward zero. In each case the magnitude does not increase.

The omitted second argument in the first two formulas is the documented zero-place default, not a special shortcut limited to positive numbers.

Enter 214.2, -214.2, 987.6 and -987.6 in A2:A5. Fill these formulas down beside them:

=TRUNC(A2;-1)
=TRUNC(A2;-2)

The tens-place column is 210, -210, 980, -980. The hundreds-place column is 200, -200, 900, -900.

A negative precision does not make the result negative. It selects a place value. The input’s sign and the place being retained are separate pieces of information.

With -8.75 in D2:

=TRUNC(D2)
=D2-TRUNC(D2)

Expected results are -8 and -0.75. Adding the two parts reconstructs -8.75.

Compare the floor-style split using INT: =INT(D2) gives -9, and =D2-INT(D2) gives 0.25. Both pairs reconstruct the original value, but their definitions differ. Choose the split that matches the meaning of the remainder.

For nonnegative whole-item quantities 17, 23 and 25, with six items per container, enter the quantities in F2:F4:

=TRUNC(F2/6)
=F2-6*TRUNC(F2/6)

Expected complete-container counts are 2, 3 and 4; leftover items are 5, 5 and 1. This model assumes positive capacity and nonnegative whole-item quantities. TRUNC does not validate those business conditions by itself.

The formula counts complete containers. It does not calculate how many containers are required to hold every item when a partially filled container is permitted.

=TRUNC(1.9)+TRUNC(1.9)
=TRUNC(1.9+1.9)

Expected results are 2 and 3. The first discards each fractional part separately; the second combines the quantities first.

Formatting a cell to show fewer decimals leaves its underlying value intact; TRUNC calculates a new value. Keep the original input in a separate column when later calculations may need its discarded digits.

The guide’s decimal controls were checked independently. Exact binary-floating-point boundaries, very large magnitudes, text/Boolean conversion and native error labels were not tested in Collabora.

• Collabora Office 26.04: TRUNC.
• Editorial testing standards.

The complete function section was reviewed. Worked results are independently checked expectations; native execution and unlisted edge cases remain unverified.