T Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples

=T(value) checks whether a value is text. If it is text, it returns the same text; if it is not text, ONLYOFFICE describes a blank-looking result. It is not a generic number-to-text converter. For example, =T("Invoice-104") is expected to return Invoice-104, while =T(42) is expected to display blank. See ONLYOFFICE’s T reference. All example results here are expected, not observed by executing ONLYOFFICE.

It is useful when an imported column mixes text labels, identifiers and numerical values, and a downstream presentation column must show text entries only. Use it in a new column; leaving a blank-looking result does not mean the original source record was empty. For a TRUE/FALSE test rather than text extraction, use ISTEXT.

=T(value)

Only one argument is documented. There is no optional argument or documented default. Non-text values result in empty-looking output; the official description is not a promise about every type of formula error or every date serial in every edition. Official T function.

Evidence scope (accessed 2026-10-13): ONLYOFFICE’s current, unversioned English function index and the function reference. The reference confirms the syntax shown above but does not identify the first supporting release. The Docs changelog and Desktop Editors changelog are separate histories; neither was used to infer that every old Desktop version implements this function. Release histories and promotional banners do not establish a tested function-by-version matrix.

• Docs web/server Spreadsheet Editor: described in the official shared Spreadsheet Editor help; no native web/server execution performed for this guide.
• Desktop Editors: same general editor documentation is available, but the exact minimum Desktop version and behaviour in the target installation remain unverified.
• Mobile and integrations: not tested; do not assume parity from the shared function article.
• English formula examples: begin with =, use the English function name and comma-separated arguments. The Insert Function guide documents manual insertion. The Advanced Settings guide says formula language and region are configurable and that currency/decimal/grouping display can vary. Test translated function names, argument separators, region and numeric displays locally rather than assuming semicolons or comma decimals everywhere.

A4 should display 007 as text, and A7 should display the letters TRUE as text, not logical TRUE. You can use =ISTEXT(A4) and =ISTEXT(A7) as a helper check. Use Text formatting before data entry to preserve these literal strings.

1. Open a blank worksheet and enter the input cells exactly as listed; preserve the difference between typed text and numeric or logical values.
2. Enter the examples in free output cells, using a leading =. For formulas with more than one argument, use English comma separators in an English-formula configuration.
3. Compare the resulting values to the expected column. These expectations were checked from the official documentation and/or independent reasoning; none are results observed by running ONLYOFFICE.
4. Log the ONLYOFFICE product, version/build, online versus Desktop edition, operating system, chosen formula language and regional settings alongside any discrepancy.
5. Keep your source column; never overwrite original imported data until results are confirmed on your installation.

A visibly blank cell and a formula that returns empty text are not always equivalent for subsequent functions. Do not infer whether the underlying cell is truly blank from T’s display alone. A precise Excel comparison describes non-text output as "", but the ONLYOFFICE function help uses the less technical phrase blank result; retain this distinction pending native execution. ONLYOFFICE T; Microsoft’s T reference (comparison).

Preserve text-only identifiers before creating a printable list

=IF(ISTEXT(A4),T(A4),"Not text")

Expected: 007, preserving the leading zeros and avoiding a numeric conversion. For a genuine number in A3, =IF(ISTEXT(A3),T(A3),"Not text") is expected to return Not text. The ISTEXT reference defines the TRUE/FALSE test; the T reference defines the return value.

Count characters after excluding non-text cells

=LEN(T(A3))

Expected under an empty-text interpretation: 0. The vendor describes a blank result without specifying its exact internal type. If the empty-looking output later behaves differently from the empty string in a specific build, verify it natively and record the discrepancy before using that behavior in a workflow.

Distinguish text “TRUE” from a logical TRUE

A7 stores text TRUE, while A5 uses logical TRUE. Under the official type rule, =T(A7) is expected to display TRUE and =T(A5) is expected to display empty text. This matters in imports where true/false labels may have been coerced to logical values without the operator noticing.

1. Expecting 42 to become "42": T does not convert numbers to text. Use TEXT with an explicit format if that is your goal.
2. An empty-looking result is mistaken for an empty source cell: T deliberately suppresses non-text display. Inspect the source cell separately.
3. Leading zeros vanish: the import may already have converted 007 into the number 7. T cannot restore information lost before it runs. Import identifiers explicitly as text.
4. TRUE appears on one row but not another: one entry may be text while the other is logical TRUE. Use ISTEXT for verification.
5. Date/time confusion: a date stored as serial data, literal text or a formula may be typed differently. The ONLYOFFICE article’s date/time example does not establish a universal result for all three representations; native verification is required.
6. Errors or nonstandard types: the reference does not give an exhaustive error-type table. Do not claim error suppression, number coercion or array spill behavior from this short help article.
7. Wrong function name or locale: verify the Formula Language setting in Advanced Settings; insert T using the function picker if localized formulas are in use.

Microsoft Excel documents the same T(value) signature and describes the non-text return as empty text. ONLYOFFICE documents text unchanged versus non-text blank-looking output. This is a documentation-level resemblance, not a guarantee that Excel, ONLYOFFICE web and every Desktop release treat formulas returning empty strings, localized dates or errors identically. Excel T; ONLYOFFICE T.

Does T remove spaces? No. Text returned by T is the same text; for explicit whitespace cleanup, use a suitable text-cleaning function after confirming that changing source data is appropriate.

Will T keep number-like text such as 007? Yes under the documented type rule, provided it was stored as text. A real number 7 is non-text and gives a blank-looking result.

Should I use T to detect whether a cell contains text? Use ISTEXT for a TRUE/FALSE answer; T returns the text itself or a blank-looking result.

• ONLYOFFICE: T function; ISTEXT; TEXT; EXACT.
• ONLYOFFICE: Insert functions; Advanced settings.
• Microsoft Excel: T function (comparative behaviour only).

Official syntax and type rules were checked on 2026-10-13. The examples use independent string/type reasoning, with empty-result interpretation explicitly qualified. Native error behavior, regional execution and historical release support remain untested.