PI Function in ONLYOFFICE Spreadsheet Editor: Syntax, Examples and Troubleshooting

Insert the mathematical constant π with no arguments: =PI(). ONLYOFFICE documents its value as 3.14159265358979.

PI supplies an approximation of the mathematical ratio of a circle’s circumference to its diameter. You do not type a numeric constant into every formula; instead, reuse PI() in expressions for circle area πr², circumference 2πr, a sector’s area, and an arc length. The official function description provides the constant directly; the geometry formulas in this tutorial are separately established by mathematics and labeled expected rather than claimed application outputs.

Units matter: a radius measured in centimeters produces a circumference in centimeters and an area in square centimeters. A sector angle in the examples is in degrees, so angle/360 gives its fraction of a full turn. That fraction formula is not the same as using radians: don’t mix the two angle conventions.

=PI()

There are no arguments: the parentheses are empty. Unlike a function with optional arguments, PI has no number1 or other numeric inputs. Put any radius, angle, or multiplier outside the function call. =PI()*A2^2 is an area expression; =PI(A2) is not the documented signature.

ONLYOFFICE explicitly documents π as 3.14159265358979. That is a finite numeric approximation, not a statement of infinite precision. The help page does not promise any particular number-format display, rounding in other spreadsheet engines, or a first-supported Desktop/web version.

Research access date: 2026-10-13. The formula name and signature on this page come from the official, English-language ONLYOFFICE reference. That page does not identify the first product release containing this function and does not provide a Desktop-versus-browser capability matrix. Therefore, the guide describes documented ONLYOFFICE Spreadsheet Editor behavior, not an assertion that every desktop, self-hosted, or cloud edition at every version works identically.

ONLYOFFICE announced Docs 10.0 on October 10, 2026. That release announcement is not evidence that this individual function was introduced in 10.0. Before relying on the formula in production, verify the actual version in use and test the examples in that installation; native spreadsheet execution was not performed.

The examples use English function names, commas between arguments, and a period as the decimal separator. ONLYOFFICE documents a Formula Language setting and Region and decimal/thousands separator options in File → Advanced Settings. Those instructions do not establish one universal formula-argument separator for all locales: if your installation rejects the illustrated punctuation, check its formula input and regional settings rather than blindly copying the text. Keep values such as 1.5 numeric under the selected locale, not imported text.

Validation method: the values called expected below were independently computed with elementary arithmetic (and, where needed, a reference numerical π constant). They were not read from a running ONLYOFFICE Desktop or web instance. No screenshots, imported workbook tests, or installation-specific error messages are claimed.

1. Open a blank sheet in ONLYOFFICE Spreadsheet Editor using a version where the function is available.
2. Leave any previously used ranges clear. Enter the example numbers as numeric values in the precise cells below. If your decimal separator is not a period, adapt the numeric entry to your installed region.
3. In an unused location (for example H2, H3, H4, etc.), enter one formula per cell from the table. Press Enter according to your application’s usual workflow.
4. Compare the result with the expected value, allowing for displayed decimal rounding where the table says “approximately.” The table is an independent mathematical prediction, not the result of a native editor test.
5. If the displayed result differs, first check your numeric inputs, active formula language/region, and the actual Desktop/web version. Record the observed behavior rather than changing documented syntax to fit a different spreadsheet.

Worked formulas with reproducible expected answers

Area versus circumference: know which power belongs where

For radius 3 in A2, =PI()*A2^2 is expected ≈ 28.274333882308 square units, whereas =2*PI()*A2 is expected ≈ 18.849555921539 linear units. An area calculation squares the radius; a circumference calculation does not. Type ^2 after the radius cell reference, not after the whole formula unless you specifically intend to square the entire expression.

A circular sector and its arc

With a radius of 3 in A2 and angle 60 degrees in B2, the sector fraction is 60/360 = 1/6. The arc length is calculated by =2*PI()*A2*(B2/360), expected ≈ 3.14159265359. The corresponding sector area is =PI()*A2^2*(B2/360), expected ≈ 4.712388980385. If you are using radians already, do not divide a radian angle by 360; adjust the formula to its actual unit.

Round the presentation, not the underlying constant

=ROUND(2*PI()*A2,2) has an independently calculated expected result of 18.85. By contrast, simply displaying a cell to two decimals may change only the visual representation, not the stored numerical result. For repeated calculations, avoid replacing π with 3.14 unless the reduced accuracy is an intentional approximation.

Zero and invalid geometric values

When the numeric radius is zero, =PI()*A4^2 is expected 0. A negative radius would still produce a positive squared area algebraically, but negative radius usually indicates an invalid physical input rather than a valid geometry measurement. Validate source data separately; PI does not accept an argument to reject a negative radius.

Error evidence limitation: ONLYOFFICE’s short PI function page does not document a complete error-code table for malformed formulas or every mixed input type. The table distinguishes safe mathematical reasoning from untested application behaviour; it does not invent #VALUE!, #NUM!, or other specific returns for this function. Check native responses before adding an error-output screenshot or support claim.

Does PI need a number argument? No: enter =PI() exactly, with empty parentheses.

Is π stored with infinite precision? No spreadsheet has literal infinite numeric precision; ONLYOFFICE’s page publishes 3.14159265358979 as the constant.

Can I type =PI()*A2^2? Yes: mathematically it calculates a circle’s area if A2 contains its radius.

Is PI() the same in Excel? Microsoft also documents Excel’s PI() with its own numerical precision and release applicability. Equal-looking syntax does not establish identical hidden-precision/display behavior without comparing the implementations.

The function also has a same-name counterpart in widely used spreadsheet software, but matching names are not proof of identical coercion, locale, error, recalculation, or precision behavior. For ONLYOFFICE itself, the syntax and principal purpose are supported by its own function reference. Validate any important shared workbook in the particular version of ONLYOFFICE Desktop or browser editor to which it will be delivered, particularly if it was authored with a non-English formula language or contains blank cells, text or errors.

• Official documented: function purpose, argument order and optionality as shown, and any explicit numeric limit cited above.
• Independently calculated: every numeric example marked expected, using the cell setup in this guide.
• Native execution: not performed in ONLYOFFICE Desktop or web, so exact displayed precision and undocumented boundary/error responses remain unconfirmed.

1. Official ONLYOFFICE PI help — formula syntax and core documented meaning; unversioned function reference.
2. ONLYOFFICE Spreadsheet Editor advanced settings — formula language, region and decimal/thousands separators.
3. ONLYOFFICE Docs 10.0 announcement, dated October 10, 2026 — broad release context only, not the function’s introduction version.
4. Official ONLYOFFICE ROUND help — related documentation checked 2026-10-13.
5. Official ONLYOFFICE POWER help — related documentation checked 2026-10-13.
6. Microsoft Excel PI: separate compatibility reference, not ONLYOFFICE evidence — related documentation checked 2026-10-13.