Contact
12 programs
Explore the site

ISNONTEXT Function (OpenOffice Calc)

Information Intermediate OpenOffice Calc

Learn the ISNONTEXT function in Apache OpenOffice Calc: Returns TRUE if the value is not text.

Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in OpenOffice Calc. How formula examples are checked

Quick answer: What does ISNONTEXT do?

ISNONTEXT tells you whether a value is not text. It returns TRUE for a number, a genuinely blank cell, or an error-valued cell and FALSE for a cell containing text. It is the logical opposite of ISTEXT for the same evaluated value. Apache’s function reference documents that exact equivalence. [A1][A2]

=ISNONTEXT(123)

Expected result: TRUE. This literal-number example appears in Apache’s ISNONTEXT documentation. [A1]

=ISNONTEXT("cat")

Expected result: FALSE. A text string is not a non-text value. This is a documentation-based deduction from the function’s defined predicate, not a screenshot from OpenOffice. [A1]

Important: TRUE does not mean that a cell is filled in or that its contents are valid data. A completely empty cell also returns TRUE. If you need to distinguish empty cells from wrong-type entries, test ISBLANK first. [A1][A3]

Exact documented syntax and arguments

=ISNONTEXT(value)
Position Argument Required? Accepted meaning Default
1 value Yes A cell reference or expression/value whose evaluated type should be tested No default documented

Apache documents exactly one positional argument and a logical return value (TRUE or FALSE). There is no separate mode, match criterion, error-handling flag, optional argument, or array-setting parameter in the official ISNONTEXT syntax. Do not add a second argument to customize the test. [A1]

Semantics: [A1][A2]

  • TRUE: evaluated value is not text, including a numeric value, an empty cell, or an error value stored in a referenced cell.
  • FALSE: evaluated value is text. The characters can be digits, an error-looking string, or an empty string returned by a formula; their appearance does not by itself determine the data type.
  • The function checks the value’s type, not whether the characters look useful, whether an error exists, or whether a cell is visually blank.

Separators and locale. ISNONTEXT itself has one argument, so no multi-argument separator occurs in its syntax. Where this tutorial nests IF or other functions, it uses Apache’s documented Calc examples with semicolons (;). A localized installation can show translated function names or use different entry/display conventions; check its Function Wizard, and avoid assuming formulas can be transferred unchanged to Excel or LibreOffice. The examples intentionally use simple ASCII text and integers so decimal-comma parsing and date locale settings are not involved. [A1][A4]

Software/version/platform: The documented function is for Apache OpenOffice Calc. Apache’s official release page on 2026-10-12 listed Apache OpenOffice 4.1.16, released November 10, 2025, for Windows, macOS, and Linux. The dedicated function documentation supports the syntax and the examples below, but does not establish that the examples were executed during this research in OpenOffice 4.1.16 on any operating system. No platform-specific variance is claimed. [A1][A7]

Worked example 1: create a type-testing worksheet

Open a new Calc workbook. On Sheet1, type the column headers Input, Not text?, and Text? in A1, B1, and C1. Enter each input in column A as described; for entries beginning with =, type the formula itself rather than copying a visual result. Leave A4 truly empty: don’t enter a space or the text "" into it. In B2 enter =ISNONTEXT(A2) and fill through B9; in C2 enter =ISTEXT(A2) and fill through C9. [A1][A2]

Row Input to enter in A Expected B ISNONTEXT Expected C ISTEXT Reason
2 123 (number) TRUE FALSE Numeric value, not text.
3 cat (plain text) FALSE TRUE Plain text.
4 (leave A4 empty) TRUE FALSE Empty cell contains no text.
5 =1/0 TRUE FALSE Referenced cell contains an error value, not text.
6 ="" FALSE TRUE Formula returns text of length zero, not a genuinely empty cell.
7 =TRUE() TRUE FALSE Logical value, not text; Calc’s logical representation is distinct from the text characters TRUE.
8 ="123" FALSE TRUE Formula produces text digits, not the numeric value 123.
9 ="#DIV/0!" FALSE TRUE Formula returns an error-looking text string, not an actual error.

Validation: Rows 2–5 correspond directly to Apache’s published ISNONTEXT and ISTEXT definitions/examples, including the =1/0 cell and the genuinely empty cell. Rows 6–9 are documentation-based type deductions, checked against the documented ISTEXT complement and Apache’s discussion of text returned by T(). No row was executed in a native OpenOffice session. Exact displayed error wording/formatting can vary by software locale and display settings. [A1][A2][A5][A6]

For a quick check without data entry, paste this into an empty cell:

=NOT(ISTEXT(123))

Expected: TRUE, which matches =ISNONTEXT(123). Both functions test the same text/non-text distinction in complementary directions. This identity comes from the published ISNONTEXT reference. [A1][A2][A8]

Worked example 2: flag entries that are not text

Imagine a list of customer reference codes: valid code entries must be text so leading zeros are preserved. Place the inputs below in A2:A5, and put the formula in B2, then fill B2 through B5.

=IF(ISNONTEXT(A2);"Check type";"Text ready")
Cell Input in A Expected status in B
A2 A-001 (text) Text ready
A3 2007 (number) Check type
A4 (leave empty) Check type
A5 ="2007" (formula producing text) Text ready

IF(test; value1; value2) returns its first output when the test is true and the second otherwise. Since ISNONTEXT returns true for blank cells too, this version intentionally groups missing and wrong-type values together. This is a type check only: a string such as bad-code would pass even if it violates your expected code pattern. [A1][A4]

Validation: Expected outputs were checked by evaluating the documented Boolean predicate and the documented IF branch rules independently. No native results were observed.

Advanced example 1: distinguish missing from wrong-type data

For a more useful import-quality status, change the formula in B2 to:

=IF(ISBLANK(A2);"Missing";IF(ISNONTEXT(A2);"Wrong type";"Text ready"))

Expected results using the same inputs: A2 A-001 → Text ready; A3 numeric 2007 → Wrong type; A4 empty → Missing; A5 ="2007" → Text ready. The first IF checks for an actually empty cell. If the cell is populated, the second IF tests whether that value is text. Apache documents both ISBLANK and the fact that IF evaluates its selected branch. [A1][A3][A4]

Limit: A cell containing ="" looks blank but is not genuinely empty; ISBLANK returns FALSE for cells containing formulas. Therefore ="" would pass the text-type test. If an empty-string result should count as missing in your workflow, a further length or equality check is required and must be verified in your exact locale/application. Do not confuse ISBLANK with visual emptiness. [A3][A5]

Validation: Documentation checking plus independent evaluation of the nested Boolean conditions; native execution not performed.

Advanced example 2: compare with ISTEXT, ISBLANK and ISERROR

These tests answer different questions, although some outputs overlap:

Test What TRUE means What TRUE does not prove
ISNONTEXT(A2) The evaluated value is not text. It is not necessarily numeric, complete, or error-free.
ISTEXT(A2) The evaluated value is text. The text is not necessarily nonempty or valid.
ISBLANK(A2) The cell really is empty. A formula returning "" is not an empty cell.
ISERROR(A2) The evaluated value is an error. It does not tell you whether the error is #N/A or another kind.

For instance, if A2 contains =1/0, Apache’s ISNONTEXT example says ISNONTEXT(A2) is TRUE, because the cell is error-valued rather than text. It is incorrect to conclude from that TRUE value that A2 is clean data. For error diagnosis, use the distinct ISERROR, ISERR, or ISNA functions as appropriate. [A1][A6]

There is a documented OpenOffice caution: a complex ISERROR(CHOOSE(...)) expression can propagate an error rather than produce a Boolean in certain circumstances. That observation concerns ISERROR and CHOOSE; it is not evidence that every nested ISNONTEXT expression behaves identically. Therefore the examples here test a reference to an error-valued cell rather than promising that every directly nested error-producing expression will yield a Boolean. [A6]

Common errors, limits and troubleshooting

Symptom Likely explanation How to check or fix
A blank cell returns TRUE. A blank cell has no text; this is documented normal behavior. Use ISBLANK first if missingness and wrong type must be separated. [A1][A3]
123 unexpectedly returns FALSE. Your cell may hold the text string "123" rather than the number 123. Inspect the formula bar and entry format; compare ISTEXT(A2) and ISNONTEXT(A2). Do not rely on alignment alone. [A1][A2]
An error-valued cell returns TRUE. The test is about text type, not whether a calculation is valid. Inspect or check the error with ISERROR; don’t treat TRUE as success. [A1][A6]
A visually empty cell returns FALSE. A formula such as ="" may be returning an empty text string. Inspect the formula bar and compare ISBLANK(A2). Treat formula-empty and actually blank as distinct. [A2][A3][A5]
Formula gives a syntax error after pasting. Formula names or separators may not match your localized Calc entry settings. Try the Function Wizard and confirm the one-argument spelling; in nested functions adjust separators as shown by your installation. [A1][A4]
You want to test a whole column in one result. Official syntax only establishes one value argument; implicit array/range behavior is not guaranteed by this research. Fill =ISNONTEXT(A2) down beside your data; do not assume untested array/spill behavior. [A1]
You expect a missing argument or two arguments to have an exact error code. The official reference does not document those error-code details. Correct the formula to =ISNONTEXT(A2) and test malformed calls natively before describing their error codes. [A1]

The function is not a regex validator, number parser, proof of nonblankness, or substitute for investigating spreadsheet errors. It also does not certify that an imported value preserves its original type across other spreadsheet applications. [A1][A2]

Cross-compatibility and edition notes

The syntax and checked worksheet results in this guide are grounded in Apache OpenOffice Calc, not in LibreOffice or Microsoft Excel help pages. We did not execute the formulas in LibreOffice Calc, Excel desktop/online, Google Sheets, or a mobile spreadsheet program; therefore no assertion is made that all products treat an error-valued reference, an empty string, or a localized expression identically. Verify behavior in the target application before migrating a critical workbook. [A1][A2]

No Apache documentation consulted for this guide establishes a separate ISNONTEXT alias or a version-specific replacement function that needs its own URL. Keep the canonical site page at /openoffice/functions/isnontext/. AOO 4.1.16 is the release context verified on the access date; platform-specific native tests remain outstanding. [A1][A7]

Official Apache sources and claim-level verification

All official sources below were consulted 2026-10-12 UTC. Apache’s wiki pages are documentation statements, not native execution logs. Version/platform context comes from the separate official Apache release/download references.

Validation note

The examples show expected results checked against Apache OpenOffice documentation and independent arithmetic, text mapping, or logical reasoning. They were not run in Apache OpenOffice Calc. Platform, locale, import, and unusual error cases are not certified.