LCM in Collabora Office: Coordinate Repeating Cycles and Common Batch Sizes

• Introduced: documented by Collabora Office 26.04; the original introduction release is not established.
• Availability: LCM 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 LCM reference. Documentation check; not a native application test. Expected examples are independently calculated.

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

The official reference permits up to 255 argument positions supplied as integers, references or ranges. It states that text and empty cells inside a referenced data range are ignored. The examples use small positive integers; they do not rely on undocumented coercion or exact error-code behavior for invalid counts.

LCM concerns multiples, while GCD concerns divisors. For six and eight, the greatest shared divisor is two, but the least shared multiple is 24. Choosing the wrong operation can produce a plausible small number that answers the opposite question.

Two checks happen every six minutes and every eight minutes. They both happen at time zero. Put 6 in B2 and 8 in C2:

=LCM(B2;C2)

Expected result: 24 minutes. The first check repeats at 6, 12, 18 and 24 minutes; the second at 8, 16 and 24. Their first shared positive repeat is 24.

The shared starting time is essential. If the second check starts three minutes later, LCM alone does not solve the offset-schedule problem. This example describes intervals with a common origin, not arbitrary appointment schedules.

Add a third check that repeats every nine minutes from the same origin:

=LCM(6;8;9)

Expected result: 72. The number 24 no longer works because it is not divisible by nine. Seventy-two is divisible by all three inputs.

You can verify the result with ordinary division: 72/6 is 12, 72/8 is 9 and 72/9 is 8. These checks establish divisibility; the least-value property comes from the common-multiple calculation rather than divisibility alone.

One supplier ships a component in packs of four and another in packs of six. You want the smallest equal positive quantity obtainable from complete packs on each side.

=LCM(4;6)

Expected result: 12 components from each supplier. That is three packs of four and two packs of six. The combined delivery is 24 components, but LCM’s result here is the matching quantity on each side.

Clearly distinguish units from pack counts. If the inventory involves different component types, an equal numerical quantity does not mean that the components are interchangeable.

To add 1/6 and 1/8 using explicit numerator and denominator cells, first calculate:

=LCM(6;8)

The common denominator is 24. The corresponding numerators are 24/6 = 4 and 24/8 = 3, so the sum is 7/24, approximately 0.291667 to six decimal places.

This is an explanatory integer construction. For ordinary numeric addition, =1/6+1/8 is shorter. Keep numerator and denominator separately if the report needs an exact fractional representation rather than a rounded decimal display.

Enter 10, 15 and 25 in E2:E4:

=LCM(E2:E4)

Expected result: 150. For two positive integers only, the identity LCM(a;b)*GCD(a;b)=a*b provides another check. With 6 and 8, 24×2 equals 48, matching 6×8.

Do not extend that exact two-input identity to three inputs by simply multiplying all three numbers. A correct two-number shortcut need not remain correct after adding arguments.

A common multiple may be much larger than any individual input. Growth is particularly noticeable when counts share few factors. If a result becomes impractically large, review whether exact coincidence is truly required by the operational question.

Use a consistent interval unit. Six minutes and eight hours cannot be passed as 6 and 8 without conversion. Check numeric storage before trusting the documented text/blank omission rule; an ignored value can change the repeat condition.

For native verification, record the exact Collabora build and check 24, 72, 12 and 150 from the supplied inputs. The article’s answers are independent arithmetic, not observed application output.

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