Calligra Sheets #NAME?: Check an Unknown Function

When a syntactically readable function call names a function Calligra cannot find, changing the numbers will not fix the name. Check the function itself before changing its arguments or hiding the error.

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.

Identify the supported failure

The formula evaluator looks up the requested function in the function repository. If no function is found, it returns the unknown-function error, whose English string is #NAME?. This page covers that path, not every possible problem involving names or references.

Make a reversible spelling test

Use a disposable sheet and the built-in SUM function:

1. Enter 19 in A2 and 23 in A3.
2. Enter =SUMTYPO(A2:A3) in B2. SUMTYPO is an intentionally invented name, assumed not to be installed as an extension. If it reaches function lookup without a matching function, the source-inferred outcome is #NAME?.
3. Correct only the function name: =SUM(A2:A3). The expected result is 42, independently checked as 19 + 23.
4. Change A3 to 24. The expected result is now 43; restore 23 afterward.
5. Restore the misspelling only in the scratch copy to confirm that it, rather than the data, was the trigger.

SUM is registered by the pinned math module. If the first formula instead fails at entry or parsing in your installed build, record that actual outcome rather than relabeling it as a demonstrated NAME error.

Distinguish a typo from unsupported software features

Compare the function name with the SUM reference or the relevant entry in the function directory. A similarly named feature in another spreadsheet does not establish Calligra support. Check the exact function, installed version and required argument form before replacing a name.

If the original formula came from another program, preserve it in a copy before rewriting it. A replacement must express the same calculation, not merely produce a number for one row. Use file-format compatibility checks for the surrounding workbook; successful arithmetic in this small example does not validate the import.

A named cell or area is a separate issue. If the formula contains a label rather than a function call, inspect named cells and areas, and do not apply this invented-function test as a universal explanation.

Confirm a real repair

Retain the formula, test a changed input and restore the intended data. Avoid a bulk workbook-wide replacement until you have checked other occurrences: a text label or unrelated function can share similar letters. Record the old and new formulas and the installed version if the documented function is still not recognized.

Return to the error selector.