ISNONTEXT in Calligra Sheets: Find values that are not text

ISNONTEXT answers a type question, not a formatting or quality question. Use it when an imported product-code column contains a mix of text identifiers (such as "00104") and numeric values (104). Those values can look similar after formatting but are not necessarily the same data type. A TRUE result means the evaluated input is not a string. A FALSE result means the value is text; it does not mean the text is valid, nonempty or unique.

KDE registers both ISNONTEXT and ISNOTTEXT in the information module, and both call the same func_isnottext implementation. The published handbook also calls them identical. This is two accepted names for the same function, not two distinct features. ISTEXT is the complementary positive text test.

=ISNONTEXT(x)
=ISNOTTEXT(x)   ← synonymous spelling, same implementation

Return: Boolean TRUE for a value that is not text, FALSE when the input is text. There is no second parameter and no documented optional argument. The handbook section for ISNONTEXT gives the spelling, meaning and sample values; the source callback at lines 297–300 checks args[0].isString() and reverses the answer.

Enter these formulas in distinct cells; this removes ambiguity about how a typed cell imports a numeric-looking identifier:

Readback procedure: In an empty worksheet enter exactly one test formula in each indicated cell. Compare its Boolean output with the expectation. A text identifier with leading zeros should be imported or formatted as text before you use an identification test; do not assume "00104" can be reconstructed after an import stripped its zeros. The quoted examples are reproducible expression literals, not claims that importing a CSV will infer the same types.

A diagnostic that handles an imported column

Place A2 = 104 as a numeric cell, A3 = SKU-104 as text. Enter in B2 and copy down:

=IF(ISNONTEXT(A2);"Review numeric/non-text";"Text identifier")

The independently reasoned expected outputs are Review numeric/non-text for A2 and Text identifier for A3, assuming A2 is truly numeric, A3 truly text, and standard IF operation. This is a triage label, not validation of whether the product code exists. For a more reliable ingestion process, retain the original raw import alongside any transformed column.

Advanced case: why an empty cell deserves a separate test

Source code evaluates whether an argument is a string, not whether the underlying cell is occupied. A genuinely empty value normally is not text, so ISNONTEXT(A4) with empty A4 is a source-inferred candidate TRUE, but the exact handling of empty references, empty-string formula results and error propagation still requires native testing. If distinguishing empty cells matters, add a prior ISBLANK check rather than calling all non-text cells invalid:

=IF(ISBLANK(A4);"Missing";IF(ISNONTEXT(A4);"Not text";"Text"))

This combined expression is a reasoned recipe, not a natively executed Calligra output. It separates missing data from numeric/Boolean entries and text labels without assuming every non-text value is a number.

• Numeric-looking strings: "104" is still a string in the source-level test. Do not use ISNONTEXT to determine whether text could be converted to a number; that is a different question.
• Imported IDs lose zeros: cell formatting cannot restore information discarded by a prior conversion. Reimport from raw data using text preservation.
• Unexpected TRUE for a blank: check with ISBLANK and distinguish a blank cell from a formula returning ""; their evaluation paths are not proven identical here.
• Errors or referenced ranges: the source-level callback checks a value’s string type, but formula-engine error propagation and array/range behavior were not natively evaluated. Don’t promise a particular error token or array result.
• Language settings: TRUE/FALSE may be localized; expected values in this guide refer to Boolean meaning, not a guaranteed screen string.

Microsoft’s official Excel IS-functions list documents ISNONTEXT(value) with comparable high-level meaning and notes that blank cells are not text. Excel’s published list does not document ISNOTTEXT as a standard synonym. For an Excel-bound workbook, prefer ISNONTEXT, not ISNOTTEXT; this says nothing about add-ins or version-specific aliases. In other spreadsheet software, test how blank results, errors and imported numeric-looking text are evaluated. The Calligra source inspection does not validate behavior in LibreOffice, Apple Numbers or Gnumeric.

The KDE ISTEXT definition, KDE ISBLANK definition, KDE ISNOTTEXT synonym and KDE’s corresponding source registration distinguish a positive text test, a blank test and the two synonymous spellings. These links point to official vendor material checked on 2026-10-12.