GCD in Calligra Sheets: Find the Greatest Common Divisor

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.

GCD returns the greatest common divisor of whole numbers: the largest positive whole number that divides every input exactly. Use it to simplify fractions and ratios, or to choose a maximum common batch size. For example, =GCD(24;36) has an expected result of 12 because 12 divides both 24 and 36. The source’s func_gcd implementation makes numeric input checks and uses the calculation engine’s greatest-common-divisor routine [S1, S3].

=GCD(first_number; [second_number; additional_number; ...])

The first_number and second_number are integer quantities in the handbook. Additional numbers or a numeric cell range can be supplied; the 26.08.2 source registers one or more arguments and accepts arrays (setParamCount(1,-1) and setAcceptArray()), even though the published handbook illustrates two or more [D1, S1]. The inputs are not an ordered numerator/denominator pair: GCD(24;36) and GCD(36;24) are equivalent. There is no optional mode, rounding digit or other default argument. The function returns a whole-number result for the supported integer examples.

Input restrictions in the examined source: a scalar nonnumeric argument or a scalar numeric value whose integer conversion is negative causes an internal numerical error; the implementation applies roundDown to scalar numeric values before the divisor calculation. Arrays take a separate helper path that rounds down their elements [S2, S3]. Use non-negative integers for portable, predictable workbooks; do not extrapolate error handling to every imported text/blank cell without native testing. An alternate compatibility name, COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETGCD, is registered for the same function; it is not a separate function [S1].

Enter the following values in A1:C5. In D2 enter =GCD(B2;C2), then fill downward. The row labels are explanations and are not numeric inputs.

Independent check: 24 and 36 share 1, 2, 3, 4, 6 and 12 as positive divisors, with 12 the largest; Euclid’s algorithm gives gcd(84,126)=42. Zero is an identity for GCD in the examined engine, so a single positive counterpart stays unchanged [S2, S3]. These are not executed spreadsheet results.

Suppose B8 is 84 finished products and C8 is 126 packaging units. Put 84 in B8 and 126 in C8. To display the reduced ratio as text in D8, enter:

=(B8/GCD(B8;C8))&":"&(C8/GCD(B8;C8))

Expected: 2:3. The divisor 42 reduces 84:126 to 2:3. The formula requires a text-concatenation operator as used in spreadsheet expressions; this composed formula has not been executed in Calligra. For the most conservative test, first put =GCD(B8;C8) into D8 (expected 42), then =B8/D8 into E8 (expected 2) and =C8/D8 into F8 (expected 3). This helper-cell method isolates any potential formula-parsing issue.

Put 24, 36 and 60 in B11:B13. Enter =GCD(B11;B12;B13) into C11, or try the source-supported range form =GCD(B11:B13) as a native-validation case. The expected whole-number result is 12. Dividing each stock count by 12 yields 2, 3 and 5 equally sized groups; it does not imply 12 is the fewest packs. Use the numbers only if all items really must be grouped in equal-size integer batches.

• Using GCD to obtain a least common multiple: GCD finds the largest shared divisor; for event alignment or repeating periods, see LCM instead [D1].
• Negative values: The version-pinned scalar-path source returns a numeric-error value when a number’s integer representation is negative. If imports can be negative, check or sanitize them explicitly; do not assume negative inputs are silently converted to absolute values [S2].
• Fractional values: The handbook describes integer inputs, and the source rounds down scalar numerics before calculation. Enter deliberate integers; do not rely on fractions being preserved [D1, S2].
• Ranges vs separate arguments: 26.08.2 registers array support; if range calculations differ from individual arguments, record the exact input cells and package version instead of silently converting a claim about implementation to a native test [S1, S2].
• Incorrect separator or text input: The English examples use semicolons, but another locale may parse them differently. Check cell types before assuming strings will coerce to numbers.
• Very large integers: Spreadsheet numeric precision can limit exact integer arithmetic. Keep examples in a reliably representable range and independently verify high-stakes calculations.

Microsoft Excel also documents GCD and a nonnegative integer-oriented workflow, but its treatment of fractional and negative inputs is not automatically a Calligra guarantee. LibreOffice Calc offers GCD as well (see its official mathematical-functions help). Recheck import behavior for text, floats, array arguments and errors. In Excel English-localized formulas commonly use commas where this KDE handbook uses semicolons.

• KDE: LCM — least common multiple; the complementary integer arithmetic calculation.
• KDE: INT — rounds numeric values down to an integer, but does not calculate a divisor.
• KDE: QUOTIENT — truncates the result of division toward zero in the pinned source.

• [D1] https://docs.kde.org/stable_kf6/en/calligra/sheets/functions.html#GCD — handbook GCD section, syntax and examples; handbook calls the result a denominator but conventional term is divisor. Accessed 2026-10-12 (UTC); immutable source revision where applicable.
• [S1] https://github.com/KDE/calligra/blob/72123cc643f6625351139e7df294544255a1056f/sheets/functions/math.cpp#L259-L263 — 26.08.2 function registration, variadic argument count, arrays and explicit alternate name. Accessed 2026-10-12 (UTC); immutable source revision where applicable.
• [S2] https://github.com/KDE/calligra/blob/72123cc643f6625351139e7df294544255a1056f/sheets/functions/math.cpp#L1079-L1109 — scalar/array validation, roundDown, errors and gcd reduction. Accessed 2026-10-12 (UTC); immutable source revision where applicable.
• [S3] https://github.com/KDE/calligra/blob/72123cc643f6625351139e7df294544255a1056f/sheets/engine/ValueCalc.cpp#L820-L838 — version-pinned Euclidean arithmetic helper. 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 GCD official support — comparison reference; checked 2026-10-12 (UTC).
• [X2] LibreOffice Calc mathematical functions official help — cross-platform reference; checked 2026-10-12 (UTC).