QUOTIENT in Calligra Sheets: Integer Division and Negative Signs

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.

QUOTIENT returns the whole-number portion of a division. The first argument is the numerator (what you divide), and the second is the denominator (what divides it). For example, =QUOTIENT(21;4) is expected to return 5, rather than the decimal 5.25. The examined 26.08.2 implementation explicitly rounds the division’s result toward zero, using ceil for negatives and floor for nonnegative values [D1, S2].

=QUOTIENT(numerator; denominator)

Both arguments are required numeric values or cell references. The order is important: QUOTIENT(21;4) is not the same as QUOTIENT(4;21). KDE’s handbook labels both parameters as floating-point inputs; the word “denumerator” in its displayed syntax is a documentation typo, and standard mathematical usage is denominator [D1]. There are no optional parameters, no rounding-digit input and no default denominator. Calligra’s 26.08.2 registration associates the compatibility alias COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETQUOTIENT with the same function; it is an alias, not a separate algorithm [S1].

The English handbook uses semicolons between function arguments; use the local equivalent if a non-English locale has different punctuation. Enter decimals using the numeric separator recognized by the installed app. A displayed result of 5 may be a function result or merely a formatted 5.25; inspect the underlying formula to distinguish these cases.

Create the following worksheet. Put the numerators into B2:B7 and denominators into C2:C7, add headers in row 1, then enter =QUOTIENT(B2;C2) into D2 and fill down. The results are expected by source inspection and independent calculation, not native observations.

Each row uses the formula =QUOTIENT(Bn;Cn) with its own row number. Mathematical checks: 21÷4 = 5.25 (whole-number portion 5); -21÷4 = -5.25 (truncate toward zero → -5); 3÷4 = 0.75 (truncate → 0). This is not rounding to the nearest integer.

Suppose a warehouse has B10=53 products and each full carton holds C10=12 products. Enter into D10:

=QUOTIENT(B10;C10)

Expected D10 = 4 full cartons, with 5 units left over. In E10 enter:

=B10-D10*C10

Expected E10 = 5. This two-step approach makes the logic auditable: 4×12 = 48 and 53−48 = 5. It assumes both B10 and C10 are nonnegative whole-number counts and that C10 is greater than zero. It does not handle partial cartons as sellable units or automatically round any quantity up.

For signed values, do not confuse QUOTIENT with INT. If B14=-21 and C14=4, =QUOTIENT(B14;C14) has expected result -5 while =INT(B14/C14) has expected result -6. Both functions return a whole-number value, but they implement different rounding rules for negative fractions [S2]. A negative quantity could be a return or correction; do not use an INT-based carton formula blindly when the business wants truncation toward zero.

The function is not the same as MOD (remainder), division operator /, or ROUND (nearest integer). For nonnegative a and positive b, a - QUOTIENT(a;b)*b provides an independently checkable remainder for integer counts. For negative inputs, remainder sign conventions differ between spreadsheets; check the desired convention and avoid a blanket compatibility claim.

The 26.08.2 source explicitly checks calc->isZero(args[1]) and returns its division-by-zero error (Value::errorDIV0()) when denominator is zero [S2]. The exact visible error string depends on renderer and locale; native testing has not confirmed how that code appears in a cell. If C2=0, change your input to a nonzero denominator before depending on a result. For an instructional guard, use the documented IF function in an example such as:

=IF(C2=0;"Choose nonzero denominator";QUOTIENT(B2;C2))

This is a recommended design pending native execution, not a measured Calligra output. For nonnumeric inputs, the source converts the ratio to floating point; coercion and displayed errors should be tested against the actual version and locale rather than guessed. Very large or tiny floating-point values can introduce rounding/precision questions, so verify high-stakes counts separately.

• Unexpected sign: Check numerator and denominator signs separately; one negative gives a negative quotient and two negatives yield positive.
• Off-by-one with negatives: A negative decimal quotient is truncated toward zero by this implementation; INT instead floors it [S2].
• Fraction missing: This is expected; the result is an integer-style count, not a decimal quotient.
• #DIV/0!-style error: Denominator zero is rejected in code; never depend on how a platform renders the error without testing.
• Unexpected zero: A numerator smaller in magnitude than its nonzero denominator has a fractional ratio whose truncated integer part is zero.
• Text values: Confirm cells are numerical and locale separators imported correctly.
• Parameter order: numerator first and denominator second; reversing changes the meaning entirely.

Microsoft Excel documents QUOTIENT to return the integer portion of division; LibreOffice’s mathematical-functions help also includes it. The basic positive/negative truncation objective can be compared across systems; precise text coercion, divide-by-zero presentation, input bounds and formula separators still require tests in each. Calligra’s compatibility namespace alias is not a separate algorithm [S1].

• KDE: INT — floor, giving a different result for negative fractions.
• KDE: GCD — common divisor rather than division result.
• KDE: LCM — common multiple rather than division result.

• [D1] https://docs.kde.org/stable_kf6/en/calligra/sheets/functions.html#QUOTIENT — handbook QUOTIENT syntax, two float arguments, integer-part example, denominator labeling typo. Accessed 2026-10-12 (UTC); immutable source revision where applicable.
• [S1] https://github.com/KDE/calligra/blob/72123cc643f6625351139e7df294544255a1056f/sheets/functions/math.cpp#L179-L181 — function registration and alternate namespace name. Accessed 2026-10-12 (UTC); immutable source revision where applicable.
• [S2] https://github.com/KDE/calligra/blob/72123cc643f6625351139e7df294544255a1056f/sheets/functions/math.cpp#L667-L680 — division-zero error, negative ceil and nonnegative floor. 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 QUOTIENT official support — comparison reference; checked 2026-10-12 (UTC).
• [X2] LibreOffice Calc mathematical functions official help — cross-platform reference; checked 2026-10-12 (UTC).