ONLYOFFICE TYPE Function: Identify Number, Text, Boolean, Error and Array Values

=TYPE(A2) returns a number indicating what kind of result A2 contains. The ONLYOFFICE TYPE function reference lists these codes:

These are type codes, not error codes. A return of 16 does not identify which error occurred, and a return of 1 does not mean the number equals 1. For example, the numeric value 827 yields type 1.

=TYPE(value)

The outer TYPE function needs just one argument and no delimiter. Nested functions such as IF use separators shown as commas in ONLYOFFICE’s English help. Localized versions may use different separators or names. The checked vendor page does not state exactly how every array-formula form or modern dynamic data type behaves; do not assume a spreadsheet-app-specific result without testing.

In a blank sheet, prepare the inputs in column A. Format A3 as Text before entering 0084. Enter each =... expression as a formula; do not paste the literal equal sign as plain text. In B2 enter =TYPE(A2) and fill through B9.

The ordinary number, text, logical and error results follow the vendor’s return-code table and independent classification; the empty-string edge case requires native confirmation. Results are expected, not observed in a running ONLYOFFICE application.

A warehouse export may store quantities as numeric-looking text. TYPE can help decide whether the input is actually numeric before arithmetic:

=IF(TYPE(A2)=1,A2*2,"Check data type")

With A2 = 84, expect 168. With A3 = text 0084, copying the formula to row 3 should return Check data type. The goal is not automatically to convert the ID; it is to detect a type mismatch before calculating.

To label errors without flattening other types:

=IF(TYPE(A5)=16,"Source contains error","No error value")

A5 contains =NA() in the worksheet, so the expected label is Source contains error. If this is used on A7, which evaluates to 2, it should return No error value. In this pattern TYPE classifies the evaluated result. To ask whether a cell contains an actual formula, use ISFORMULA(reference) instead.

Why number formatting is not enough

Formatting the display of a numeric cell as currency, a percentage or date does not make its underlying evaluated number into text. Conversely, an identifier like 0084 is still text even though it consists of digit characters. TYPE helps diagnose the storage/evaluation kind; it does not determine whether the input is semantically valid. Never interpret TYPE(A2)=1 alone as permission to sum all values in a data set.

ONLYOFFICE’s reference documents 64 for an array-valued input but does not give an edition-specific matrix describing which array constants, dynamic arrays, range references or imported spill formulas are interpreted as arrays by TYPE. This guide therefore records 64 in the official code table, but does not supply an untested executable array-constant example as proven behaviour. To validate it, create an array output using functions supported by the target edition and check TYPE on the intended expression, recording the build, locale, formula and observed result.

The Microsoft Excel TYPE page includes an additional 128 (compound data) classification. That does not establish a corresponding code in ONLYOFFICE: the checked ONLYOFFICE page lists only 1, 2, 4, 16 and 64. Do not add the Excel-only 128 behaviour to an ONLYOFFICE result table.

The function is listed in the official unversioned English ONLYOFFICE Spreadsheet Editor function index. No release floor, full Docs-web/Desktop Editors compatibility matrix, or mobile-language behaviour was provided by the checked function article. The comparison with Microsoft’s documentation is evidence of related syntax and semantics, not a native import/export conformance test.

The exact function description and syntax are documented in ONLYOFFICE’s TYPE reference; the ONLYOFFICE Insert Function index lists it under the Information category. Both were checked on 2026-10-13 UTC. The index is unversioned online documentation, not an independently confirmed feature matrix for every Docs web, Desktop Editors or mobile version.

Verification limits: All table and advanced examples were independently classified from documented type/error rules and explicit inputs. No native ONLYOFFICE execution, localized formula test or cross-editor import test was performed. Blank, formula-empty and array edge cases remain qualified where noted.