PI in Collabora Office: Use the Circle Constant Without Hard-Coding It

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

=PI()

Keep the parentheses even though no argument is required. The official 26.04 reference displays the value as 3.14159265358979, to 14 decimal places.

PI is preferable to manually typing 3.14 into many formulas. Using the function keeps the intent obvious and avoids inconsistent approximations across a workbook. It does not, however, make measured inputs exact or eliminate floating-point rounding.

Enter a radius of 5 metres in B2. In C2 use:

=2*PI()*B2

Expected result: approximately 31.415927 metres when displayed to six decimals. The calculation is 10 times pi.

If B2 actually contains a diameter, this formula doubles the intended circumference. Label the input explicitly and check whether the formula should be PI()*diameter instead.

Using the same radius:

=PI()*B2^2

Expected result: approximately 78.539816 square metres to six decimals. The radius is squared before multiplication by pi.

The output unit changes from metres to square metres. If the source is in centimetres, the result is square centimetres; changing only the number format or label is not a unit conversion.

Put a radius of 3 centimetres in E2 and height of 10 centimetres in F2.

=PI()*E2^2*F2

Expected result: approximately 282.743339 cubic centimetres to six decimals. The base area is 9×pi, multiplied by height 10.

This models an ideal cylinder using an internal radius if the intended quantity is internal capacity. Material thickness, end shapes and measurement tolerances are separate inputs or assumptions; PI cannot infer them.

For an angle of 60 degrees in H2:

=H2*PI()/180

Expected result: approximately 1.047198 radians to six decimals. A complete turn is 360 degrees or 2*PI() radians; a half turn is 180 degrees or PI() radians.

This conversion is often needed before supplying an angle to trigonometric formulas that use radians. An angle of 60 entered directly is not a substitute for the radian value of a 60-degree angle.

With a radius of 5, compare:

=PI()*5^2
=3.14*5^2

Expected results: approximately 78.539816 and exactly 78.5 in ordinary decimal arithmetic. Their difference is approximately 0.039816 square units.

Rounding the final displayed result is a different operation from replacing pi with 3.14 before calculating. For a longer chain of formulas, retain an appropriate internal precision and choose a final display consistent with the measurement quality.

A negative radius can produce a positive area when squared, which may conceal an invalid physical input. Check that radii and heights are within the intended domain before calculating, rather than relying on a positive result as proof of valid data.

Likewise, a radius measured in metres and a height entered in centimetres do not form a consistent cylinder-volume formula. Convert the inputs first and keep the conversions visible or clearly documented.

• If PI is treated as a name, check the required parentheses.
• If a circle result is off by a factor of two or four, investigate radius versus diameter.
• If a trigonometric result looks wrong, check degrees versus radians.
• If a long decimal differs slightly from another program, compare an appropriate rounded result instead of claiming a different mathematical constant.

A reproducible native check records the Collabora build, cell values, formulas and display precision. Verify the circumference, area, cylinder volume and angle conversion above. These are independently calculated expected values; no Collabora execution was performed.

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