Calligra Sheets #DIV/0!: Find and Repair a Zero Denominator

A zero divisor makes a ratio undefined. Do not turn the result into zero just to remove the error: a zero cost per item is different from a cost that cannot yet be calculated.

Evidence scope: reviewed October 21, 2026 against KDE’s Calligra source at commit 72123cc643f6625351139e7df294544255a1056f. The error outcomes below are source-inferred expectations, not observed application results. No Calligra installation or screenshot was used for this guide. English error strings are shown; localized displays may differ. This does not clear existing import failures or establish behavior in every packaged version.

What the source establishes

Calligra’s division implementation checks the converted divisor and returns its division-by-zero error when it equals zero. The formula evaluator calls that operation for division. The English error definition is #DIV/0!. Existing error inputs are returned before a division is attempted, so inspect upstream errors too.

Reproduce a cost-per-item failure

Use a new scratch sheet, not the only copy of your workbook.

1. Enter 84 in B2 for total cost and 0 in C2 for item count.
2. Enter =B2/C2 in D2. The expected result is #DIV/0!, because the count is zero.
3. Suppose the verified delivery record says seven items. Change C2 to 7, leaving the formula intact. The independently checked expected result is 12.
4. Change C2 to 14; the expected result becomes 6. Restore 7 after this change test.
5. In the scratch copy, restore C2 to 0 to reproduce the original failure. Then restore the real count.

These steps distinguish a working dependency from a result manually overwritten with 12. They do not prove an installed application has run the example.

Repair the cause, not merely the display

Select the failing cell and read the actual formula. If it divides by a calculated subtotal, inspect that subtotal rather than searching only for typed zeroes. If it was copied, check whether the divisor moved to the wrong row or column; use absolute-reference guidance when the intended denominator is fixed.

A genuine zero quantity may mean the ratio is not applicable yet. Keep an explanatory status beside it or decide explicitly how unavailable results should be presented. Do not substitute one as the divisor, silently remove records, or replace all errors with zero. Those actions alter the meaning of the report.

If the input is corrected but the output does not change, use recalculation checks. If a file was imported, verify the denominator and formula in a separately saved copy; this arithmetic example is not a file-format compatibility test.

Verification record

Record the original formula, divisor, verified replacement and expected ratio. Save and reopen your repaired copy, then confirm the formula remains present and the count is still correct. If the minimal numeric example behaves differently, record the installed version, exact input and actual error before reporting a bug.

Return to the error selector or broader troubleshooting reference.