CEIL in Calligra Sheets: Round Toward Positive Infinity

• Introduced: original introduction is not established.
• Source availability checked: Calligra 25.04.2 and 26.08.2 both register CEIL separately from CEILING. The inspected mathematics and calculation-engine files are byte-identical between these tags.
• Checked October 18, 2026: the KDE handbook and version-pinned implementation.
• Native execution: Calligra Sheets 25.04.2, Linux, October 18, 2026. The native table below records literal formulas recalculated in the application and saved as ODS. The step-by-step cell-reference layouts are explanatory examples, not separately executed layouts. No native 26.08.2 run is claimed.

Sources: 25.04.2 registration and 26.08.2 implementation.

=CEIL(x)

For example, =CEIL(B2/C2) is one argument: the calculated ratio B2/C2. It is not a two-argument call. The generic function class defaults to exactly one argument, and CEIL does not override that count. The function calls the engine’s upward-rounding operation at zero decimal places. Registration and implementation · default argument count.

The handbook describes an integer greater than the input, but that wording should not be read as strictly greater: the implementation uses the mathematical ceiling, so exact integers remain unchanged. The negative examples also establish that “up” does not mean away from zero.

Suppose an order needs 17 items and each sealed package contains 6 items. Packages cannot be split, so the answer must be a whole package count.

1. Enter Items needed in A1, Items per package in B1, Packages in C1 and Items supplied in D1.
2. Enter 17 in A2 and 6 in B2. Keep the unit labels out of these numeric cells.
3. In C2, enter =CEIL(A2/B2). The independently expected result is 3 packages.
4. In D2, enter =C2*B2. The independently expected result is 18 items.
5. In E1 enter Spare items, then in E2 enter =D2-A2. The expected spare count is 1 item.

The ratio 17 items ÷ 6 items/package is about 2.833333 packages. Rounding toward positive infinity produces 3 complete packages. CEIL does not produce 18 directly because its input is a package count, not an item count.

Add these rows and fill C2:E2 down to row 5:

Row 3 checks the exact-multiple boundary: a full three packages does not become four. Row 4 checks the first item above that boundary. Row 5 is meaningful only if zero demand really should produce zero packages under your ordering policy.

Assume a room can be reserved in whole 60-minute blocks, and preparation plus the event requires 125 minutes. This is a stated planning rule, not an inference about a booking provider.

1. In B8 enter 125 and label it Required minutes.
2. In B9 enter 60 and label it Minutes per block.
3. In B10 enter =CEIL(B8/B9). Expected result: 3 blocks.
4. In B11 enter =B10*B9. Expected result: 180 reserved minutes.
5. In B12 enter =B11-B8. Expected result: 55 spare minutes.

A compact equivalent for reserved minutes is =CEIL(B8/B9)*B9. If the input is a spreadsheet time value stored as a fraction of a day rather than a number of minutes, convert it to the intended numeric unit before using this pattern. Mixing 125 minutes with a fraction-of-day block size would give a meaningless count.

Use only a strictly positive block size and a nonnegative duration for this planning example. Negative durations require correcting the source data or an explicitly different policy; CEIL does not validate that model for you.

The first two are also examples in the KDE handbook. All other rows follow independently from the implemented mathematical ceiling. Display formatting can show an integer with decimal zeros; that does not change its numeric value.

• CEIL takes one number and rounds toward positive infinity to an integer.
• CEILING is separately registered and can round to a significance with a negative-value mode. For example, =CEILING(17;6) gives an expected 18 items directly. See the existing Calligra CEILING guide.
• ROUND rounds to a selected number of decimal places; =ROUND(17/6;0) is not a guarantee of sufficient capacity for every demand. See ROUND.
• INT is useful for downward integer rounding, which matters particularly for negatives. Compare its documented semantics rather than assuming every integer function behaves like CEIL. See KDE INT.

CEIL is not an alias of CEILING. A one-argument CEILING call may produce the same value in these ordinary examples, but the two functions have different registered signatures. A CEIL formula with a second argument is not the supported way to round to a multiple. Distinct registrations.

Source evidence: argument-count execution check and roundUp implementation. Blank, Boolean and text coercion, localized syntax and other application error cases remain outside the completed tests; the two-argument arity case above was verified in the native-saved workbook.

Do not assume every spreadsheet supports CEIL under this exact name. When sharing a workbook, check the destination application’s function list and test a positive fraction, a negative fraction and an exact integer after reopening. Matching one result does not establish identical signatures or file-format compatibility.

Reviewed October 18, 2026: KDE CEIL handbook, Calligra 26.08.2 mathematics source, Calligra 25.04.2 mathematics source and the calculation engine linked above. Arithmetic expectations remain distinct from the native observations below. The captured run covers Calligra Sheets 25.04.2 and the listed formulas only.

On October 18, 2026, the formulas below were loaded into the actual Linux application, recalculated, and saved to an ODS workbook. Results were read from that native-saved workbook, including error display text. The screenshot shows the real application; it was not synthesized. The independent mathematical values earlier in this guide remain reference values, and the native CEIL results below agree with the stated arithmetic expectations.

The display uses scientific notation: E-03 means multiply by 10⁻³.