CEILING in Calligra Sheets: Round Up to a Multiple
Round quantities up to a multiple in Calligra Sheets, understand negative values and mode, and distinguish source-backed outcomes from native testing.
Verification status: Consult the documentation, examples and any stated test scope below. How formula examples are checked
Quick answer: CEILING returns a number adjusted upward to a specified multiple. For a positive quantity, =CEILING(17;6) is expected to return 18: 18 is the smallest multiple of 6 that is at least 17. For negative numbers, its third mode argument affects which direction is meant by “up.” For example, KDE explicitly gives CEILING(-6.43;-4;0) → -4, but CEILING(-6.43;-4;1) → -8. These are KDE documentation examples and independently checked source-code expectations, not observations from a running Calligra installation. KDE CEILING reference · 26.08.2 implementation.
Use CEILING when you need to reserve enough full units, packages, production runs, or measurement increments without rounding down a positive requirement. If fractions of a unit are acceptable, rounding to a multiple may be inappropriate.
Availability and version history
- Introduced: Documented by 26.08.2; original introduction not established.
- Availability: Supported in Calligra Sheets 26.08.2, based on the function-specific registration.
- Scope: The official application listing provides Linux installation; other packaged builds are unverified here.
- Checked: October 14, 2026. Documentation/source check; no new native test in Calligra Sheets 26.08.2.
Syntax, arguments and defaults
=CEILING(number; [significance]; [mode])
Brackets here mean optional arguments; do not type the brackets. KDE’s handbook prints the shortened syntax CEILING(x) despite describing optional Significance and Mode parameters. In the pinned Calligra 26.08.2 code, the function is separately registered with one to three arguments, which confirms these supported positions at the registration level. This guide uses the fuller explanatory signature rather than repeating the handbook’s incomplete display. Official help · registration at math.cpp lines 120–122 · XML description.
| Position | Argument | Requirement and type | 26.08.2 source-backed default or meaning |
|---|---|---|---|
| 1 | number (x in the handbook) |
Required numeric value, expression or cell reference | The value to round. No default. |
| 2 | significance |
Optional numeric multiple; normally match its sign to number when both are nonzero |
1 for nonnegative numbers; -1 for negative numbers when omitted. |
| 3 | mode |
Optional numeric value interpreted as zero or nonzero | Omitted or 0: default positive-infinity direction for negative values; nonzero: away from zero for negative values. For positive numbers these directions coincide. |
Why the negative-number wording matters: The handbook initially describes CEILING as rounding “up (away from zero),” but its documented examples make a distinction between Mode = 0 and Mode = 1. The pinned implementation calculates a positive ratio for matching negative inputs, then either leaves its integer part or increases it according to mode. Thus, default =CEILING(-6.43;-4;0) returns an expected -4 (toward positive infinity), while nonzero mode returns -8 (away from zero). Do not apply the usual positive-number intuition to a negative quantity. KDE worked examples · source branch.
Use a semicolon between arguments as printed in the English KDE examples. Your installed locale may use another argument separator or decimal mark; none of those alternatives has been tested in this research. In a running application, use Insert → Function to confirm the local form rather than pasting syntax from Excel uncritically. KDE formula editor instructions · KDE examples.
Reproduce a worksheet: quantities and rounding modes
Create a new sheet. Type the column labels in A1:E1 as shown and enter the following numeric values in columns B, C and D. Keep the minus signs on both the negative input and the negative significance. This avoids unverified text-to-number coercion.
| Row | A: Scenario | B: Number | C: Significance | D: Mode | E: Independently expected result |
|---|---|---|---|---|---|
| 2 | Positive requirement | 6.43 | 4 | 0 | 8 |
| 3 | Whole-number increment | 12.5 | 1 | 0 | 13 |
| 4 | Negative, default direction | -6.43 | -4 | 0 | -4 |
| 5 | Negative, away from zero | -6.43 | -4 | 1 | -8 |
| 6 | Items per package | 17 | 6 | 0 | 18 |
| 7 | Already a multiple | 8 | 4 | 0 | 8 |
- Put
=CEILING(B2;C2;D2)in E2. Its expected value is 8 because the next multiple of 4 at or above 6.43 is 8. - Copy or fill the formula down to E7; relative references should update to B3/C3/D3 and so on. Compare against the E column above.
- In a different cell, enter
=CEILING(12.5)with Significance and Mode omitted. KDE’s documented expected result is 13. - Compare E4 and E5. The input and multiple stay fixed; only the mode changes, giving expected -4 versus -8.
- Check E7: a value already at its requested multiple remains unchanged.
These six worksheet results were independently calculated using the branch logic in the pinned KDE C++ source. Native Calligra behavior, cell formatting, translated function separators and application-visible errors have not been tested. Implementation · KDE documentation.
More reproducible formula checks
| Enter as a formula | Expected numeric value | Reason / evidence |
|---|---|---|
=CEILING(6.43;4) |
8 | Explicit KDE example. |
=CEILING(12.5) |
13 | Explicit KDE example. |
=CEILING(-12.5) |
-12 | Default significance is -1 and default negative direction approaches positive infinity. |
=CEILING(-6.43;-4;0) |
-4 | Explicit KDE example: default negative mode. |
=CEILING(-6.43;-4;1) |
-8 | Explicit KDE example: nonzero mode. |
=CEILING(9.2;0.5) |
9.5 | Smallest half-step at least 9.2. |
=CEILING(6;3) |
6 | Input already a multiple. |
=CEILING(0;0) |
0 | Source checks zero number before zero significance; runtime untested. |
The first, second, fourth and fifth answers appear in KDE’s handbook; the others are independent arithmetic/source expectations. Decimal exactness and formatting may vary. KDE example list · pinned source zero check.
Advanced use: convert an order requirement into full packages
Suppose B10 = 17 items required and C10 = 6 items per sealed package. To calculate the minimum full number of items to order under this simplified rule, enter in D10:
=CEILING(B10;C10)
Expected D10 = 18 items. To calculate the number of packages, enter in E10:
=D10/C10
Expected E10 = 3 packages. These are independent arithmetic expectations: 17 items require three packages of 6, and 3 × 6 = 18 items. Only apply the pattern when both the requirement and package size are positive numeric values and packages cannot be split. For prices or inventory quantities, define the business rounding policy first; CEILING is not a substitute for it. CEILING semantics · formula-cell arithmetic.
Choosing CEILING, FLOOR or ordinary ROUND
With a positive value of 17 and increment 6, CEILING has the expected result 18, while FLOOR would produce 12. ROUND operates on decimal places rather than an arbitrary increment; ROUND(17;0) remains 17. The comparisons are mathematics/source checks, not cross-product testing. KDE registers CEILING and CEIL as distinct functions, not alternate names; CEIL rounds to an integer and does not accept a significance in the checked registration. CEIL · FLOOR · ROUND · distinct KDE registrations.
For a separate guide on decimal-place rounding rather than multiples, see the ROUND guide, for decimal-place rounding.
Errors, limits and troubleshooting
| Situation | What the checked 26.08.2 source establishes | Recommended action |
|---|---|---|
Nonzero number and significance = 0, e.g. CEILING(6;0) |
The implementation constructs an internal division-by-zero error. Displayed UI string unverified. | Use a positive nonzero increment for a positive quantity. |
| Number = 0 and significance = 0 | Returns numeric 0 before the zero-significance error branch. Not native-tested. | Do not assume the same shortcut for a nonzero input. |
Opposite-sign number and significance, e.g. CEILING(6;-2) |
Negative ratio triggers an internal numeric error. Displayed UI string unverified. | Match signs for nonzero inputs. |
| Negative number yields an unexpected direction | Mode absent/0 versus nonzero changes the path. | Explicitly state and test mode for negative values. |
| A few floating-point last-digit differences | The arithmetic engine has finite numerical precision; the handbook does not promise exact arbitrary-precision decimal results. | Format for display, or use exact multiples that suit your reporting rule. |
| Text pasted into a numeric argument | The handbook types the inputs as floating-point. Text coercion is not established by this review. | Convert or validate source cells, then test natively. |
| Formula shows a parse error | The English handbook’s semicolon syntax may differ from your local settings. | Open Insert → Function, confirm names and separators, and avoid adding literal square brackets. |
Source evidence for internal errors and default sign handling: KDE func_ceiling, 26.08.2. General troubleshooting and formula syntax: KDE Sheets basics. A catalogue entry is not a native runtime test.
Version, platform and compatibility boundaries
Checked October 13, 2026. KDE lists Calligra 26.08.2, released October 8, 2026, and the version-pinned source registers CEILING as a separate primary math function. The English stable-KF6 handbook supplies examples, but its historical editorial wording is not proof of every current code path. KDE offers Linux package and Flatpak options and says Windows support is in progress. Availability depends on the user’s installed build; no executable was run for this guide. Official release · KDE apps release listing · Calligra downloads · pinned source.
Excel, LibreOffice and Google Sheets also contain rounding functions, but their behavior is not evidence for Calligra, especially for negative significance, optional mode, and error handling. This guide makes no claim that pasting a formula unchanged between those applications will preserve the result. Official semicolon examples should be the starting point for Calligra-specific testing.
Verification notes and official references
Evidence types: KDE handbook and release documentation checked; specific C++ registrations and branches inspected at immutable commit 72123cc643f6625351139e7df294544255a1056f; expected arithmetic independently calculated; native Calligra tests = 0; screenshots = 0. Sources checked 2026-10-13.
- KDE CEILING function handbook — syntax and worked positive/negative cases.
- Pinned Calligra math.cpp registration, lines 118–123 and implementation, lines 406–439 — argument count, defaults, zero cases and errors.
- Pinned Calligra math.xml definition, lines 848–873 — documentation wording and related functions.
- KDE Gear 26.08.2 announcement and Calligra download page — version/date/platform information.
- KDE Sheets simple formulas — entering formulas, cell references, function dialog.
Testing limitation: Documentation and pinned source reviewed; ordinary examples independently calculated. Native Calligra, locale, coercion, boundary precision and error display remain untested.