LCM Function in ONLYOFFICE Spreadsheet Editor: Repeating Cycles and Examples

• Introduced: The original introduction version and date are not established by the official sources checked.
• Availability: Documented in the current ONLYOFFICE Spreadsheet Editor help; no final working-version endpoint is established.
• Scope: Docs and Desktop Editors release separately. This unversioned help does not establish availability in every older build, mobile client or deployment.
• Checked: October 14, 2026, against the official function reference. Documentation check; not a new native test.

LCM finds the smallest positive whole number that is a multiple of each supplied positive whole number. It is particularly useful for combining recurring schedules, common denominators and aligning repeat cycles.

For positive integer a and b, the LCM is the least positive integer divisible by both. Mathematically, lcm(a,b) = (a×b)/gcd(a,b). For 6 and 8, gcd=2 and (6×8)/2=24. The LCM is a cycle length, not necessarily the first calendar date without a shared starting point.

=LCM(number1, [number2], ...)

No default numeric value for additional arguments is documented. A single number1 satisfies the vendor syntax, but this tutorial uses two or more positive integers to make the common-cycle examples unambiguous. These argument rules are grounded in the ONLYOFFICE LCM function reference (accessed 2026-10-13 UTC). The square brackets in the official signature indicate an optional argument; do not type them as literal characters. For GCD and LCM, the ... notation indicates successive values, not a literal formula token.

1. Open a scratch workbook in ONLYOFFICE Spreadsheet Editor, or create a blank sheet. These are test instructions, not a claim of native editor execution.
2. Select the specified cells and type the values exactly as displayed in the table below. Put the listed formula in the indicated result cell (or type the first formula and use the fill handle to copy it down).
3. In the English interface, type a leading = and use commas to separate arguments. The official Insert Functions guide documents both this entry workflow and comma separation in its English examples.
4. Inspect the result and compare it to the independently calculated expected number. Any different output is evidence to investigate, not proof the documentation is incorrect; check value types and formula-language settings first.
5. Change one input and verify that the result recalculates. The official guide documents automatic workbook recalculation by default and a Formula → Calculation control when needed.

Validation classification: The function signature and documented argument description were checked against the vendor reference. All numbers below were calculated separately using Python’s standard math module, then sanity-checked using mathematical identities. Native execution: not performed; no cell output or exact error code was observed.

These examples use English ONLYOFFICE function names, commas, and a decimal point only where relevant. The Advanced Settings documentation describes independently configurable formula-language and region settings; it does not establish which exact translated names or separators are supported by every installation or version. Do not silently replace commas, assume identical localized names, or interpret a number containing locale separators until testing the target editor. The documented maximum of 255 numeric arguments for GCD/LCM is a function-reference claim, not a native stress-test result.

The official Spreadsheet Editor function catalogue documents the English function names in the current, unversioned ONLYOFFICE Help Center. It is not a release-by-release runtime compatibility table. ONLYOFFICE Desktop Editors and browser-hosted Docs have separate release histories; neither the function page nor the current catalogue identifies the first Desktop, cloud or self-hosted release for this function. The exact tested build matrix remains unverified. In particular, an identically named function in Excel or Google Sheets is not evidence for ONLYOFFICE’s coercion rules, errors, array treatment or display precision. No cross-product formula-execution test was performed.

Type each pair into A2:B13. In C2, enter the displayed formula and fill down through C13. The reference uses one cell per numeric argument, which avoids making undocumented claims about how whole arrays or blank cells are handled.

How results were computed: Python math.lcm using integer inputs, then checked against divisibility / multiplicative or factorial identities. Formulas are intended as reproducible worksheet instructions, not observed workbook outputs. The exact display (e.g., number separators, decimals, scientific notation) can vary by editor and regional settings.

Paste each into a blank scratch cell. Expected numbers are independent mathematical calculations; the exact success/error outcome of the native implementation remains to be tested.

Align two recurring maintenance tasks

If one check happens every 6 days and another every 8 days, and both are performed today, enter 6 and 8 in A2:B2. =LCM(A2,B2) in C2 gives expected 24: they recur together 24 days later, assuming perfectly regular integer-day periods and the same starting event. Actual calendar recurrence may require holiday, weekend, time-zone and start-date logic; LCM alone is not a complete scheduler.

Find a common denominator

To add 1/6 + 1/8 exactly, start with =LCM(6,8), expected 24. Scale the numerators by 24/6=4 and 24/8=3: 4/24 + 3/24 = 7/24. Keep numerator/denominator separate when exact fractional output matters; a formatted spreadsheet decimal can round the result.

Compare LCM to a GCD identity

If A2=12 and B2=18, =LCM(A2,B2) has expected result 36. The formula =(A2*B2)/GCD(A2,B2) has the same expected result 36, since GCD(12,18)=6. For large inputs, multiply-then-divide can risk floating-point loss even when mathematically valid. Do not assert identical internal spreadsheet precision without testing.

More than two recurrence cycles

=LCM(3,4,6) has expected result 12; =LCM(4,6,10) has expected result 60. This relies on the published variadic signature. For a cycle with different starting offsets, a solution requires congruences rather than just the LCM of periods.

Important: The vendor function article does not specify literal error codes for invalid values, decimal truncation, text coercion, mixed arrays or particular calculation overflow behaviour. A different spreadsheet application’s documentation does not establish ONLYOFFICE’s result. Before relying on undocumented behavior, record results natively in representative Desktop and browser versions with each regional setting in scope.

Native input coercion, invalid-input errors, historical release support, localized formula entry and workbook round trips remain untested.