INT in Calligra Sheets: Floor Numbers and Handle Negative Values

This guide describes Calligra Sheets 26.08.2, identified by the official KDE Gear release dated October 8, 2026 and checked against its immutable source revision 72123cc643f6625351139e7df294544255a1056f on 2026-10-12 (UTC). KDE’s function handbook is useful for entry syntax and examples, but parts of its wording are older than the release source; discrepancies are flagged below. Source registration establishes what the shipped code provides; it does not establish that any particular Linux distribution, Flatpak installation, or other platform build was run.

Validation label: Documentation check + version-pinned implementation review + independent calculation. Native execution unavailable: all results in the examples are expected values, not observations from a running Calligra Sheets application.

Formula conventions: Start formulas with =. The English KDE handbook separates multiple arguments with semicolons, so the examples use =NAME(A2;B2) when two arguments are needed. Some locale configurations change the displayed decimal separator and formula punctuation; enter the local equivalents when necessary and confirm through the application’s function dialog. Only numeric cells are assumed unless the example explicitly says otherwise. Cell formats may show more or fewer digits than the value stored.

INT returns the greatest whole number that is not larger than the supplied number. It rounds down, which matters for negatives: =INT(12.55) is expected to return 12, while =INT(-2.4) is expected to return −3, not −2. KDE’s handbook documents the integer-part operation [D1]; the 26.08.2 implementation delegates to an integer converter whose numeric-float pathway explicitly uses floor() [S1, S2, S3].

=INT(x)

x (required) is one numeric value, formula, or reference containing a real number. The handbook identifies a floating-point argument and whole-number return type. There is one argument and no optional digits, direction or default parameter [D1, S1]. The release registers INT with no separate documented alias. Formula language is independent from number-display formatting: changing the displayed decimal places is not the same as changing the underlying integer result.

For examples using decimals, enter a point where the locale expects it. In decimal-comma locales the numeric input may need -2,4; no multiargument separator is required for INT itself. In combined formulas such as IF(test;yes;no), the example separator follows the English KDE handbook and may vary with user locale. Do not assume imported text like "12.55" converts identically on every platform [S2].

Enter sample numeric values in A2:A8; in B2 enter =INT(A2) and fill down. The following are independently calculated expectations, not outputs from a native run.

Independent reasoning: floor(-2.4)=-3 and floor(-0.1)=-1; the source’s Value::asInteger() for floating numbers explicitly chooses that mathematical floor [S3]. In the installed app, verify whether any input typed as text rather than numeric triggers a conversion error, particularly across locales.

Suppose B11 is a quantity of 27 units and C11 is a strictly positive pack size of 10. The number of complete packs is:

=INT(B11/C11)

Expected result: 2 complete packs, with 7 leftover units. If you need the leftover units as another column, enter =B11-INT(B11/C11)*C11 into E11; it is expected to yield 7. This formula deliberately assumes both quantities are nonnegative and C11 > 0. For returns, debts, negative balances or a negative pack size, an INT-based group count may not match business requirements.

When A14 is 27.9 units and the allowed measurement increment in B14 is 5, the formula:

=INT(A14/B14)*B14

has an expected result of 25. For a negative A14 of -2 and the same positive step of 5, the expected result is -5, not zero. This matters for financial negatives, temperatures below zero and other signed measurements. When you intend to simply discard a fractional part toward zero, this INT expression is not a general replacement; QUOTIENT on an appropriate division follows truncation toward zero in the examined Calligra source [S4].

For a negative number, the two operations disagree:

Never describe INT as universally removing digits after the decimal point without addressing negative numbers.

• Misreading negatives: Floor moves toward negative infinity, rather than simply dropping decimal digits [S3].
• An empty or invalid numeric cell: The converter has separate branches for empty, text and error values; behavior can depend on parsing and cell typing. Do not invent a universal displayed error code from the handbook [S2].
• Rounding displays instead of values: Showing zero decimal places is a format, while INT changes the result of a calculation. Inspect the formula bar when comparing.
• Expected nearest integer: INT is not ROUND. For negative fractions and positive fractions alike, rounding to the nearest whole number follows different rules.
• Grouping with a zero step: Check C11>0 before dividing; a zero divisor should not be used as a pack size.
• Locale import: Check decimal points/commas and data types for CSV import values; a text numeric string can be interpreted differently from a true numeric cell.
• Large magnitudes: The source’s conversion target is an integer representation; extreme magnitudes may not behave like arbitrary-precision mathematics. Do not rely on it for high-precision financial validation without native tests.

Microsoft’s official INT documentation also rounds down to the nearest integer and explains the negative result. LibreOffice’s mathematical-function help includes INT. Basic mathematical floor behavior is consistent across the three for finite numeric inputs; text coercion, errors, formula separators, numeric precision and locale conventions can still differ. Use native comparison tests before migrating complex workbooks.

• KDE: QUOTIENT — integer portion of a division; negative outputs differ from floor.
• KDE: FLOOR — rounding to a lower multiple with different argument conventions.
• KDE: GCD — common integer divisor, not a rounding function.

• [D1] https://docs.kde.org/stable_kf6/en/calligra/sheets/functions.html#INT — handbook INT signature and positive-number examples. Accessed 2026-10-12 (UTC); immutable source revision where applicable.
• [S1] https://github.com/KDE/calligra/blob/72123cc643f6625351139e7df294544255a1056f/sheets/functions/math.cpp#L661-L665 — call of integer converter within func_int. Accessed 2026-10-12 (UTC); immutable source revision where applicable.
• [S2] https://github.com/KDE/calligra/blob/72123cc643f6625351139e7df294544255a1056f/sheets/engine/ValueConverter.cpp#L71-L115 — conversion by type including text and numeric values. Accessed 2026-10-12 (UTC); immutable source revision where applicable.
• [S3] https://github.com/KDE/calligra/blob/72123cc643f6625351139e7df294544255a1056f/sheets/engine/Value.cpp#L423-L434 — floor applied when converting a numeric floating point Value to integer. Accessed 2026-10-12 (UTC); immutable source revision where applicable.
• [S4] https://github.com/KDE/calligra/blob/72123cc643f6625351139e7df294544255a1056f/sheets/functions/math.cpp#L667-L680 — QUOTIENT implementation showing contrast for negative ratios. Accessed 2026-10-12 (UTC); immutable source revision where applicable.
• [R1] KDE Gear 26.08.2 announcement — release dated 2026-10-08; checked 2026-10-12 (UTC).
• [X1] Microsoft Excel INT official support — comparison reference; checked 2026-10-12 (UTC).
• [X2] LibreOffice Calc mathematical functions official help — cross-platform reference; checked 2026-10-12 (UTC).