ISTEXT Function in ONLYOFFICE Spreadsheet Editor: Formula & Examples

Use =ISTEXT(value) to test whether a value is text, including text identifiers that contain digits. ISTEXT has one required argument, value, and no documented optional arguments. A TRUE or FALSE result describes the underlying value or reference—not how a formatted cell looks. This guide does not establish native-tested compatibility. See the official ISTEXT function reference.

Returns TRUE for text values and FALSE for nontext values, helping validate IDs, labels and imported type mismatches. The ONLYOFFICE ISTEXT help article describes it as an Information function. Its value argument can be a blank cell, an error, a logical value, text, a number, a cell reference or a name referring to one of those. The vendor says TRUE for text content and FALSE for nontext content; one required argument named value. The article does not provide a separate version history for the function.

=ISTEXT(value)

value is a parameter name, not literal text you should type without a defined name. For example =ISTEXT(A2) tests the value or reference at A2; =ISTEXT("007") tests a text literal. The official help does not document multiple-argument variants or optional default values. For a single cell test, pass one reference, not a large range whose array behaviour has not been verified.

Documentation checked: 2026-10-13 (UTC). The official ONLYOFFICE Spreadsheet Editor function catalogue and the function-specific help article document the current English-language formula, but neither identifies the first build to implement this function. ONLYOFFICE announced Docs 10.0 on October 10, 2026; that release announcement is not native execution evidence and does not establish that every older Docs, Desktop or mobile build behaves identically.

• ONLYOFFICE Docs (web/server): the English documentation includes this function. No installed web/server build was executed for this guide.
• Desktop Editors (Windows, macOS, Linux): Desktop changelog was checked separately. The available documentation does not establish a first-supported version or prove identical results on all desktop editions; test the installed build.
• Other integrations/mobile: not tested and no support matrix inferred.
• Formula language and locale: English examples use =FUNCTION(value) and comma-separated arguments where multiple arguments occur, following function insertion help. Advanced Settings describes regional settings and Formula Language. Names, separators, date parsing, and number parsing may vary with the target editor’s language and locale. This single-argument function has no separator inside its own call; nested IF examples contain commas in English mode. Never assume that a semicolon is universally correct.

Validation label: the examples below show expected results checked against documented type rules and independent reasoning, not observed outputs from an ONLYOFFICE application. Where the official help omits an edge case, it is explicitly marked as requiring native verification.

In a fresh worksheet, set A1 to Source, B1 to ISTEXT result, and C1 to Notes. Populate the listed source cells deliberately; to preserve text that resembles a number, format the cell as Text before entry. A genuinely empty cell must be cleared rather than replaced by a single space or a formula.

In B2, enter =ISTEXT(A2) and copy it down to the last listed row. The expected outcomes are an independently reasoned test oracle using the input type and the vendor’s TRUE/FALSE definitions. They are not screenshots, screenshots OCR, or observed ONLYOFFICE results. In particular, empty-string formulas may vary by engine: confirm these rows on installed Docs and Desktop editors.

Step-by-step verification

1. Create the inputs exactly, including the intentionally blank cell, and record which cells are explicitly formatted as Text.
2. Enter the formula in B2, then fill down. Check that the references advance from A2 to the correct row; do not edit the raw data.
3. Compare actual results from your own installed software with the expected table. Note any difference, including both editor build and formula language.
4. Select any surprising cell and inspect its formula bar; do not infer its storage type from alignment or display alone.
5. Retest with a fresh workbook if CSV import may have retyped values; keep import settings and sample data with your test report.

Enter the test cases in A2:A9. Format A2 as Text before entering 007, otherwise a spreadsheet can convert the value to the number 7 and discard meaningful leading zeroes. To make the distinction visible, compare A2 (text 007) against numeric 7 in A3.

In B2, enter =ISTEXT(A2) and fill down through B9. Expected TRUE for A2, A4 and A8; expected FALSE for numeric A3, logical A7 and truly empty A5. The ="" and =UPPER("ok") cases are formula-produced text expectations and require native testing of the target build.

For a warehouse import, use =IF(ISTEXT(A2),"PRESERVE CODE","CHECK TYPE"). Expected: PRESERVE CODE. Changing the reference to A3 should yield CHECK TYPE. This labels stored data types—it does not by itself prove that the string is a valid stock-keeping unit. Add format-specific business rules separately.

A formula ="" returns an empty string rather than placing nothing in the cell. Under Excel-compatible semantics, =ISTEXT(A6) is expected TRUE because its result is text, while =ISTEXT(A5) for a genuinely empty A5 is expected FALSE. ONLYOFFICE’s short reference does not address this subtle distinction explicitly; verify it on the installed web/Desktop build and keep the result marked provisional until then.

The direct literal =ISTEXT("") should also be tested separately: an explicit empty-text value and an empty cell reference are not the same input scenario.

To label numeric-looking input as text versus numeric, place text 12.50 in A8 and enter =IF(ISTEXT(A8),"TEXT IMPORT","NUMERIC INPUT"). Expected: TEXT IMPORT. If the business process needs arithmetic, ONLYOFFICE’s VALUE(text) is the documented conversion function; e.g. =VALUE("12.50") is expected 12.5 in English decimal convention. Locale interpretation of decimal points must be tested. Preserve raw input rather than overwriting it.

The text formula =UPPER("ok") should return OK according to the UPPER reference. That makes =ISTEXT(A9) a useful candidate to distinguish formula-output type from formula presence, but no installed ONLYOFFICE execution was performed.

• ISTEXT asks whether the tested value is text.
• ISNUMBER asks whether the tested value is numeric.
• ISBLANK asks whether the referenced cell contains no value.

A cell containing one space is text; a genuinely empty cell is not. The textual identifier 007 differs from numeric 7, even when both are part of a code field. Do not assume that a text-looking custom cell format proves a value was stored as text.

1. Labels and IDs: ISTEXT does not check permitted characters, exact length, uniqueness or authenticity.
2. Mixed-value columns: validate type row by row before joins or lookups; imported number/text mismatches can cause false negatives.
3. Formula outputs: use the result for type checking, but verify empty-string and error-value cases in the installed build.
4. Dates: a displayed date may be a numeric serial; ISTEXT is not a reliable date-validity test by itself.
5. Logical values: TRUE/FALSE should not automatically be treated as strings merely because they are visibly spelled out.

Microsoft Excel’s official IS-functions documentation describes the same single-argument family and TRUE/FALSE value tests. That is useful as an Excel comparison, not proof of EXACT ONLYOFFICE equivalence. A simple numeric literal or stored text should be portable, but true blanks versus formula-generated empty strings, date serials, error cases and locale-dependent conversion need local validation. We have not tested LibreOffice Calc, Google Sheets, older ONLYOFFICE Docs versions, current Desktop builds, or mobile editions; no complete equivalence claim is made.

Related function references checked today: IF, VALUE, UPPER. These are external official help pages.

1. Formula shown literally: confirm a leading =, not a leading apostrophe, and inspect whether the destination cell is formatted as Text.
2. Unexpected TRUE/FALSE: inspect source cells in the formula bar. A space, invisible character, stored number, text-formatted number, or formula returning an empty string can change the type test.
3. Unknown function or syntax warning: use Formula → More functions → Information or the function search dialog; compare the installed version with the current vendor syntax and your Formula Language choice.
4. Copied references appear wrong: check the row/column coordinates and avoid moving the reference when a fixed cell was intended.
5. Stale result: the ONLYOFFICE function insertion guide documents calculation/recalculation controls and the Show Formulas feature; confirm that formulas were recalculated.
6. Still inconsistent: record a minimal workbook, raw cell contents, exact formula, screenshot of formula bar, output, editor build, operating system, formula language, region settings and a redacted error description. Escalate for controlled native testing rather than asserting a defect.

• ONLYOFFICE Spreadsheet Editor function catalogue — syntax entry points and insertion method; accessed 2026-10-13.
• ONLYOFFICE Advanced Settings — Formula Language and regional controls; accessed 2026-10-13.
• ONLYOFFICE Docs changelog and Desktop Editors changelog — separate release streams; neither supplies a per-function cross-platform runtime guarantee; accessed 2026-10-13.
• ONLYOFFICE Docs 10.0 release announcement — published 2026-10-10; only edition/release context, not formula test proof.
• Microsoft’s Excel IS-functions reference — cross-application comparison only, not authoritative for ONLYOFFICE behaviour; accessed 2026-10-13.