PERMUT Function in ONLYOFFICE Spreadsheet Editor: Ordered Choices Without Repetition

• 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.

A permutation is an ordered selection, meaning selecting A then B and selecting B then A are different outcomes. In the standard no-repetition model for n distinct items and k ordered places, the mathematical count is:

P(n,k) = n! / (n-k)!

For 8 choices and 3 positions, there are 8 × 7 × 6 = 336 expected arrangements. Compare the unordered count COMBIN(8,3) = 56: each 3-element set can be arranged in 3! = 6 ways, so 56 × 6 = 336. This arithmetic is a mathematical derivation, not an observed worksheet evaluation.

The official PERMUT page describes its role as returning a number of permutations but does not provide a full domain/error/rounding table or identify when the function first appeared. Do not import undocumented Excel-specific behavior into ONLYOFFICE advice.

=PERMUT(number, number_chosen)

No argument is optional, and no default value is documented. The name number suggests a numeric count; the short official page does not specify precise integer coercion, acceptance of k=0 or k=n, sign restrictions or error strings. The examples use nonnegative integer counts 0≤k<n because this is the standard combinatorial teaching model; native support for all mathematical boundary cases requires testing. Official function reference checked 2026-10-13 UTC.

1. Create a scratch sheet and enter Available items n in A1, Ordered places k in B1, Formula in C1, and Mathematical expectation in D1.
2. Enter the A and B pairs in rows 2–7, exactly as in the table. Treat them as counts of distinguishable items and non-repeating positions.
3. In C2 enter =PERMUT(A2,B2) and fill through C7. This uses relative references so each formula selects its own row.
4. Compare the editor’s actual C-column outputs, if and when executed, with the D-column independently calculated expectations. Native editor execution was not performed.

Row 2: 5×4=20. Row 3: 8×7×6=336. Row 6: 10×9×8×7=5,040. Row 7: 12×11×10=1,320. The row with k=0 has the mathematical empty-ordering value 1; the documentation does not separately confirm this exact boundary in the editor, so record its native outcome before considering it tested.

Suppose a code consists of four different uppercase English letters and positions matter. The independent mathematical count is:

=PERMUT(26,4)

Expected 358,800 distinct ordered codes (26 × 25 × 24 × 23). When repetition is allowed instead, the different mathematical model has 26^4 = 456,976 codes, represented by =POWER(26,4). Confusing these models causes a 98,176-count difference; spell out whether letters may repeat before choosing a function. The POWER link below confirms the name exists in ONLYOFFICE; these numbers were obtained through Python integer arithmetic.

Imagine three independent, uniformly random picks, each from the same eight labels, with replacement. There are 8^3 = 512 equally likely ordered triples. Exactly 8 × 7 × 6 = 336 have three different labels. The independently computed probability of no repeat is:

=PERMUT(8,3)/POWER(8,3)

Expected 336/512 = 0.65625 = 65.625%. Here the numerator counts sequences with no repeated label, while the denominator allows repetition; using PERMUT for both would incorrectly assume that repeats were impossible under the sampling process. This is a self-contained combinatorial model, not a statistical measurement or a vendor-documented example.

The mathematical identity P(n,k)=C(n,k)×k! gives these independently computed comparisons for n=8, k=3:

Official COMBIN and official FACT are separate documented function pages. PERMUTATIONA appears separately in the ONLYOFFICE function index for permutations with repetition, and should not be treated as a misspelling or alias of PERMUT. The current article is only about PERMUT.

• Selecting vs arranging: choosing three committee members from eight is COMBIN, not PERMUT, unless they have distinct assigned roles.
• Repeats are allowed: PERMUT(26,4) mathematically counts no-repeat codes; use a repetition-aware model for independent 4-character strings.
• k=0 or k=n: the standard mathematical identities say nP0=1 and nPn=n!, but the short ONLYOFFICE article does not document specific boundary handling. The examples use k=0 as an expected mathematical test case—not evidence of a tested editor outcome.
• Negative values, decimals, blanks, strings or too many places: do not claim a specific native error without execution; check for accidental text formatting and omitted arguments before interpreting an error.
• Large counts: no exact numerical precision bound is established by the cited function page. Compare against a separately calculated integer and retain input assumptions if exactness is required.

COMBIN counts unordered choices; FACT gives factorial products; POWER models independent choices with repetition; PERMUTATIONA is the separately named repetition-aware function. Every named related function links to a vendor reference; the linked sources document their individual signatures.

The exact signature, two argument labels and Statistical category are documented in ONLYOFFICE PERMUT checked 2026-10-13 UTC. All numeric examples, arrangements and probability calculations are independent mathematical expectations. Required native QA: PERMUT(5,0), PERMUT(5,5), PERMUT(5,6), fractional input, text input, negative input, runtime precision and support in identified Desktop/web versions. Never assert an error code until the editor actually returns it.

ONLYOFFICE’s official inserting-functions instructions say to select a cell, type =, enter a recognized function and comma-separated arguments in parentheses, then press Enter; alternatively open the Formula tab, choose Function, search for the name, and fill the argument dialog. The formulas above are written with English function names and comma separators following the published help examples. If your workbook uses a different Formula Language, confirm the localized name in the Function dialog rather than manually translating an English name. This manuscript does not claim that any additional separator style was executed.

Regional settings and formula language

The official Advanced Settings page explains File → Advanced Settings → Regional settings. Formula Language determines translated formula and argument labels. Region influences displayed currency, dates, and times. Separate decimal and thousands separators are customizable. These documented settings are not evidence that a given translated function, localized punctuation style, or imported workbook behaves identically in every deployment. All tables here use ordinary integer inputs so decimal-entry ambiguity is avoided; they have not undergone native non-English testing.

Calculation and validation limits

The listed results are independently calculated mathematical expectations, not observed outputs from a running ONLYOFFICE Desktop, Docs/web, or self-hosted editor. We performed the arithmetic using Python’s integer mathematics; the result checks do not establish formula-parser or spreadsheet-engine support. Enter these test cases on a disposable sheet and compare the editor’s displayed result with the expectation. If different, record the precise ONLYOFFICE version, environment (web/Desktop), formula language, cell type, and exact displayed error before drawing a conclusion about compatibility.

Do not infer first-supported release or universal compatibility. The unversioned help function reference lists this function today, but does not identify the first supported Desktop build or prove behaviour across all self-hosted, Docs/web and embedded editions. The Docs changelog lists Docs 10.0.0, 2026-10-10, while the Desktop Editors changelog is maintained separately; the Docs release alone is not a Desktop version guarantee. No platform-specific native tests or compatibility matrix were executed for this page.

1. Formula displayed as text: ensure the cell contains a formula beginning with =, not a quoted string; check the displayed cell format.
2. Unexpected result: verify the order of arguments, positive/nonnegative integer assumption used in the examples, input cells (not headers), and number formatting. Compare with the arithmetic shown rather than a screenshot.
3. Function not recognized: search in the editor’s Insert Function dialog, check Formula Language, and note the exact desktop/web version. Presence in current web documentation does not guarantee the function was present in older releases.
4. Apparent calculation error: check blank cells, stray text, missing commas, copied relative references and whether the input violates the mathematical domain. The help reference does not provide a comprehensive table of exact error strings for this function; no error code or coercion behaviour is asserted here as an observed ONLYOFFICE result.
5. Large numbers: factorial-style counts can exceed the range where a spreadsheet displays or stores every integer exactly. A rounded display or scientific notation is not proof that the full integer was retained; compare against the independently calculated exact integer where precision matters.

• Official function-entry instructions — how to insert and identify the supported function from the editor UI.
• Official regional and formula-language settings — language, region and separator controls; localized formula execution remains untested.
• ONLYOFFICE Docs release notes and Desktop release notes — separate release tracks; these do not establish this function’s introduction version.

Verification limitations: Native web/Desktop calculation, localized parsing, historical compatibility and undocumented error behavior were not tested. The official function index documents current names, not a release-by-release execution guarantee.