GAMMALN.PRECISE Function in ONLYOFFICE Spreadsheet Editor: Syntax, Examples and Troubleshooting

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

GAMMALN.PRECISE(x) returns the natural logarithm of the Gamma function for strictly positive numeric x according to ONLYOFFICE’s dedicated documentation. Mathematically, it targets exactly the same quantity as GAMMALN(x): ln(Γ(x)). It is not the regular gamma value, and it is not a probability-distribution function.

Important naming caveat: ONLYOFFICE documents the PRECISE form as a distinct function name but does not provide an algorithm-level precision guarantee or tested head-to-head error bound in this reference. Do not claim that it is always more accurate than GAMMALN; that needs direct testing in stated ONLYOFFICE releases. For ordinary positive inputs, independently calculated reference values for the two forms are therefore identical, even if their future observed display rounding could differ.

This function is particularly appropriate to compare against GAMMALN in spreadsheet compatibility audits, provided the same workbook, inputs and numeric display formatting are used in a named Desktop/web version.

=GAMMALN.PRECISE(x)

There is one positional argument and no documented optional or default parameter. The reference page uses the English function spelling shown above. Enter a number such as 2.5 directly, or reference a numeric input cell such as A2. Cell references are useful because every example can be recalculated by editing the input without rewriting the formula.

The ONLYOFFICE function-entry guide shows formulas starting with = and arguments separated by commas in the English instructions. This single-argument function has no separator ambiguity of its own; regional decimal separators and translated function names may still vary. Do not assert localized equivalents without an actual localized Desktop/web check.

1. Create a new workbook in ONLYOFFICE Spreadsheet Editor and stay on its first worksheet. Set A1 to x (positive numeric input), B1 to GAMMALN.PRECISE formula and C1 to Independently calculated expected result.
2. Type the exact numeric inputs from column A of the table below into A2:A16. Do not type the backticks; they only identify code in this guide. Enter the values as numbers, not strings containing units.
3. Select B2 and enter =GAMMALN.PRECISE(A2). Press Enter. Fill or copy this relative-reference formula down through B16. Every row should then refer to its matching A-row.
4. Paste the expected numbers from column C into C2:C16. Format B and C as Number, showing enough decimal digits (or scientific notation for large values). Visual rounding is not numerical equality.
5. In D1, write Absolute difference, then enter =ABS(B2-C2) in D2 and fill down. Use =IF(D2<1E-9*MAX(1,ABS(C2)),"Within tolerance","Review") in E2 if your build supports the documented IF, MAX and ABS functions, then fill down. This tests the actual workbook only when you run it yourself; it was not executed during manuscript production.
6. If output differs, verify that A is numeric, formulas updated row references, and the result cells are not formatted as dates or fixed-width text. Run the same workbook on the specific Desktop and online builds you use before treating any compatibility claim as confirmed.

How these results were derived: values are high-precision mathematical reference points calculated with mpmath and cross-checked against Python’s independently implemented math.gamma or math.lgamma, with relative numerical tolerance at most 1 × 10⁻¹² (using max(1, |value|) for scale). They are not claimed ONLYOFFICE outputs. Because C values are rounded to 12 significant digits for readability, allow a tolerance rather than testing B2=C2 bit-for-bit.

1. Use a factorial connection. With 6 in G2, =GAMMALN.PRECISE(G2) targets ln(5!) = 4.78749174278. This is different from ln(6!) because Γ(n) = (n−1)! for positive integers.

2. Verify the half-integer benchmark. =GAMMALN.PRECISE(0.5) targets 0.572364942925, mathematically equal to =0.5*LN(PI()). A close match on one benchmark would not prove comparative accuracy over all inputs.

3. Compare names without assuming identical internal algorithms. Put 2.5 in G3; enter =GAMMALN(G3) in H3 and =GAMMALN.PRECISE(G3) in I3. Both have the same mathematical target, approximately 0.284682870473. Record the editor version, display precision and numerical difference =ABS(H3-I3) if you perform this test; this manuscript contains no such native output.

4. Use the log-domain recurrence. For x = 2.5 in G4, =GAMMALN.PRECISE(G4+1) and =LN(G4)+GAMMALN.PRECISE(G4) both mathematically equal approximately 1.20097360235.

5. Build a combinatorial log expression. Set n = 10 in G5, k = 3 in H5, then enter =GAMMALN.PRECISE(G5+1)-GAMMALN.PRECISE(H5+1)-GAMMALN.PRECISE(G5-H5+1). It targets ln(120) = 4.78749174278. Require integer n≥k≥0 for this factorial/binomial interpretation; the gamma identity has broader mathematical extensions that may not represent a counting problem.

• Domain check: The documented domain is x > 0. The individual official reference does not specify which native spreadsheet error label appears for zero, negative values, text/coercion failures, infinite intermediate results or excessive magnitudes.
• Wrong input type: Enter a true numeric cell, not a string such as "2.5 kg". The source does not promise how arbitrary numeric-looking text is coerced. If using a pasted CSV, select A2 and confirm its underlying type.
• Wrong function family: GAMMALN.PRECISE is not interchangeable with a gamma distribution, a factorial, or a base-10 logarithm. Read the output units/meaning before nesting it in another formula.
• Argument mistakes: This function takes exactly one required argument. Do not add a probability, cumulative flag, scale, or second numeric parameter. The vendor signature lists no default.
• Precision and overflow: Large gamma-related values may approach numeric limits. A log-space formula usually avoids a large intermediate factor but cannot eliminate all floating-point rounding, underflow, or overflow. Native ONLYOFFICE thresholds have not been measured here.
• Locale and editions: English documentation uses this name and a decimal point in its examples. Localized names and separator rules are not asserted. Current unversioned help coverage does not prove which historical Docs or Desktop builds first included the function.
• Scientific notation: A large value displayed as 8.84E+30 is a formatting choice, not a different calculation. Change cell format and retain the underlying numeric precision.
• Audit a surprising result: Reduce the sheet to the table above, compare against a reference value, save editor build information, test with a known constant (x=1 or x=0.5), and report exact steps; do not invent native error messages or screenshots.

Can I copy an Excel or Google Sheets formula verbatim?

Treat portability as unverified until the receiving app and specific version evaluate your saved workbook. ONLYOFFICE’s English function catalogue documents the name and basic operation; compatibility with other implementations’ coercion rules, precision and historical releases has not been established from these sources. In addition, a vendor help page is not direct runtime evidence for either the web or Desktop binary.

Official function-level claim sources (checked 2026-10-13 UTC):

• ONLYOFFICE — GAMMALN.PRECISE reference — English name, purpose, exact argument signature, and any explicitly documented domain restriction or error label.
• ONLYOFFICE Spreadsheet Editor — inserting functions — formula entry, function chooser, autocomplete, general comma-separated syntax and calculation controls; this is a general editor guide, not a historical feature-introduction statement.
• GAMMA — official ONLYOFFICE function reference (a distinct documented function).
• GAMMALN — official ONLYOFFICE function reference (a distinct documented function).

Verification separation: The page, function signature, category, and specified input restrictions are documentation-checked. The numerical values are independently calculated and cross-checked. They have not been executed in ONLYOFFICE Docs web, Desktop Editors, older releases or another spreadsheet UI; error strings outside explicitly documented cases are deliberately not assigned.

Version/edition boundary: The reviewed vendor help page is unversioned as to first supported release. The general editor guide describes spreadsheet formula entry for the product family, but does not supply a reproducible Desktop/web runtime version matrix. A reader using an older version should inspect the Function chooser and test a small numerical example. The examples are reference-based expectations, not native runtime measurements.

Runtime verification: Check critical formulas in the specific Desktop or web build you use, especially localized entry, undocumented input coercion and extreme values.