GCD in Collabora Office: Find a Common Unit and Simplify Ratios

• Introduced: documented by Collabora Office 26.04; the original introduction release is not established.
• Availability: GCD is documented in the official 26.04 Calc Help.
• Scope: desktop Calc documentation; separately deployed Online and mobile versions have not been verified.
• Checked: October 13, 2026, against the official GCD reference. Documentation check; not a native application test. Expected examples are independently calculated.

=GCD(integer1; [integer2]; ...)

Collabora documents up to 255 argument positions, including integers, cell references and ranges. A range occupies one argument position even when it contains several cells. The reference says text and empty cells inside a data range are ignored.

This guide uses positive integers so that the grouping questions have an unambiguous interpretation. It does not infer how every fractional, negative or directly supplied text argument is converted. Validate imported counts before applying the formula.

Put 18 in B2 and 30 in C2, then enter:

=GCD(B2;C2)

Expected result: 6. The positive divisors of 18 are 1, 2, 3, 6, 9 and 18. Those of 30 are 1, 2, 3, 5, 6, 10, 15 and 30. Their shared divisors are 1, 2, 3 and 6; GCD chooses the largest.

This is different from the smallest nonzero divisor, which would always be one for positive integers. It is also different from a shared multiple: 90 is divisible by both inputs, but does not divide either one.

Suppose you have 24 red pieces and 36 blue pieces. Every kit must have the same composition, and all pieces must be used.

=GCD(24;36)

Expected result: 12 kits. Each kit then contains 24/12 = 2 red pieces and 36/12 = 3 blue pieces. Twelve is the maximum number of identical complete kits under these assumptions.

GCD returns the number of kits in this model, not the number of pieces in each kit. If the question instead asks for the largest equal-sized groups within separate single-color inventories, the same divisor has a different operational interpretation. State what the result counts.

Enter numerator 42 in E2 and denominator 56 in F2. In G2 enter:

=GCD(E2;F2)

Expected result: 14. The reduced numerator =E2/G2 is 3, and the reduced denominator =F2/G2 is 4. The fraction 42/56 is therefore 3/4.

Keep the two reduced integers in separate cells if later calculations need them. Joining them with a slash creates display text; it is not a substitute for retaining numeric numerator and denominator values.

Enter 30, 45 and 75 in J2:J4:

=GCD(J2:J4)
=GCD(J2:J4;20)

Expected results: 15 and 5. Fifteen divides the original three values. Adding 20 reduces the greatest shared divisor to five.

A new constraint can reduce the common divisor or leave it unchanged; it cannot increase it beyond the divisor of the original set. This is a useful diagnostic when extending a model to include another product, unit or count.

For a controlled range test, put 18 in L2, the text Pending in L3, leave L4 genuinely blank and put 30 in L5. =GCD(L2:L5) is expected to return 6 under the documented range rule. The ignored cells are not additional integer constraints.

Do not conclude that ignored text is harmless: a number imported as text may disappear from the intended constraint set. Inspect the stored types, especially if the answer seems unexpectedly large.

=GCD(8;15) is expected to return 1. That means the inputs share no positive divisor larger than one; it does not mean the calculation failed.

Use exact integer counts and consistent units. Converting a measurement to a whole number changes the problem, so do not silently round measurements solely to make a GCD example fit. Very large counts also need independent precision checks.

For a native acceptance test, record the Collabora build and compare 6, 12, 14, 15, 5 and 1 in the examples above. These are independently calculated expectations. No target application was executed.

• Collabora Office 26.04: GCD, checked October 13, 2026.
• Editorial standards.