ISTEXT in Calligra Sheets: Verify Text IDs and Imported Labels

The official handbook reports that =ISTEXT("hello") returns TRUE and =ISTEXT(12) returns FALSE. Calligra 26.08.2 implements this via args[0].isString(). These are documentation/source-supported expectations, not observations from running Calligra. [E1–E3]

Use ISTEXT to check whether customer codes, product IDs and imported labels are genuinely stored as text rather than numbers. A numeric-looking ID can lose significant leading zeros if imported as a number. ISTEXT flags the current type but does not itself reformat or repair it.

=ISTEXT(x)

x is one required argument of any value type, in position 1. The return value is Boolean (TRUE or FALSE). The source XML lists no optional arguments, additional positions or defaults. Its registered 26.08.2 callback uses Value::isString() rather than inspecting displayed text. [E1–E3]

The official current source scope is Calligra Sheets 26.08.2, not a claim that every earlier Calligra edition or every distribution package behaves identically. KDE’s English documentation uses semicolons between multiple arguments and unquoted TRUE/FALSE for logical values; display labels, decimal entry, and separators may vary by spreadsheet locale. This one-argument function itself has no separator. [E1, E2, E6]

Prepare a new worksheet. Type SKU-004 into A2 as text, type the numeric quantity 42 into A3, put the formula ="0042" into A4 to create text digits, enter 0 as a number in A5, enter the text word pending in A6, and leave A7 untouched. In B2 type =ISTEXT(A2) and fill down to B7. [E1–E4]

Expected B2:B7: TRUE, FALSE, TRUE, FALSE, TRUE, FALSE. The A4 evaluator pathway and blank-reference typing are not natively tested. Formula outputs in the table represent documentary/source-backed expectations, not results collected inside Calligra Sheets. [E1–E4]

To label likely textual IDs, enter the following formula into C2 and fill it down:

=IF(ISTEXT(A2);"Text ID";"Not text")

The independently expected C2 is Text ID; C3 is Not text; and C4 is Text ID. This helps identify numeric IDs imported without preserved text type. Note that ISTEXT can only tell you the current type: if an importer already removed leading zeros, the function cannot reconstruct them. [E1–E4]

A useful companion when cleaning labels is:

=IF(ISTEXT(A2);UPPER(A2);"CHECK TYPE")

For A2 containing SKU-004, the independently expected result is SKU-004. With A6=pending, the expected result is PENDING. With numeric A3=42, the expected result is CHECK TYPE. The example composes registered Calligra functions; the results follow basic text logic but have not been reproduced in a native installation. [E1–E4]

Try =ISTEXT("42") and =ISTEXT(42) in separate cells. The first has source-supported expected result TRUE and the second FALSE. Quotation marks intentionally change the value type even when the displayed characters are the same. [E2–E4]

• An ID made only of digits returns FALSE: It may have been imported as a number. ISTEXT only reports the current type; it does not repair leading-zero loss. [E2–E3]
• A formula-created label behaves differently: Calligra’s source checks the evaluated argument type. If an expression or import step coerces a value before the check, results can differ. The example ="0042" is an expected text result, not an observed native test. [E3]
• Empty-looking values: An untouched blank cell is different from a formula yielding a zero-length string. The source predicate is isString(), but exact evaluator classification of zero-length results remains pending native validation. [E3]
• Dates or formatted numbers: Display formatting does not automatically imply a text-typed value. Test actual value types rather than inferring them from how the grid looks. [E3]
• Locale or incorrect syntax: The syntax contains one argument and no separator. In multi-argument IF examples, KDE’s handbook uses a semicolon. Localized input conventions may differ. We did not record exact native error strings for invalid argument counts. [E1–E2]

The official Microsoft Excel IS-function reference also includes ISTEXT(value) and describes it as testing whether its argument is text. Therefore the named predicate is available in Excel, but this is not proof of identical edge cases or identical handling of imported date/number formats. Prefer ISTEXT when migrating type-check formulas; retest text-digit import and empty-string behavior in the destination installation. These compatibility notes are documentation comparisons only, not side-by-side execution. [E5]

Excel’s English Microsoft reference is linked below. Function-name overlap is a documentation-backed compatibility observation, not a blanket guarantee across application versions. For LibreOffice or other spreadsheet software, verify supported names, argument separators, coercion and blank-cell behavior in that program’s own documentation and runtime before production migration. [E5]

Does ISTEXT(42) return TRUE because it displays digits? No: the argument is a number. The official example for a numeric argument returns FALSE. [E1–E3]

Can ISTEXT preserve leading zeros? It identifies text-typed values; it does not set import type or recover already discarded characters. Configure the import as text before data loss. [E3–E4]

How is ISTEXT different from ISNUMBER? ISTEXT checks string type, and ISNUMBER checks numeric type. Neither automatically converts its input in the examined source callbacks. [E3]

The official reference describes the function and the Calligra source tagged to 26.08.2 registers it. Research accessed 2026-10-12 (UTC); the associated pinned source revision is 72123cc643f6625351139e7df294544255a1056f. KDE announced Gear 26.08.2 on 8 October 2026. The source is from the shipped function module, but registration is not evidence of runtime operation on an arbitrary OS/package. [E2, E3, E6]

Validation method: the handbook/XML was read (DOC); the pinned implementation was inspected (SOURCE); simple type truth tables and conditional labels were reasoned independently (CALC/LOGIC). NATIVE Calligra execution: NOT PERFORMED. In the examples, “expected” never means observed. [E4]

• KDE’s official Calligra function chapter: use the browser’s search/find for ISTEXT. This source was opened and the function entry checked on 2026-10-12. [E1]
• Calligra 26.08.2 information module source: exact registered callback used for this function; fetched and read. [E3]
• Microsoft’s official Excel IS-functions reference: documents the Excel counterpart, not Calligra runtime details. [E5]

• [E1 — official DOC] KDE Sheets function handbook, ISTEXT entry (plus ISNUM for numeric synonym); function definition, argument requirements, examples, cross-related function names. Accessed 2026-10-12.
• [E2 — release-pinned XML] KDE 26.08.2 information.xml: exact declared single value parameter and Boolean output, with no optional/default arguments shown. Accessed 2026-10-12.
• [E3 — source implementation] KDE 26.08.2 information.cpp: registration around line 107; callback around line 281. The callback directly tests the evaluated Value type. Accessed 2026-10-12; source observation only.
• [E4 — independent calculation / inference] Reproducible numeric, string and untouched-cell inputs, and expected Boolean/conditional results; checked using explicit type tables, not native execution. Accessed 2026-10-12.
• [E5 — cross-software source] Microsoft Excel IS functions: named Excel counterparts and documented value-type semantics. Accessed 2026-10-12. Not a Calligra test.
• [E6 — official release] KDE Gear 26.08.2 announcement, published 2026-10-08; accessed 2026-10-12.