Can I Spreadsheet?
← All functions

TYPE

Quirk found

Category: Information · Last tested 2026-08-06

Real, executed compatibility results for the TYPE function across Microsoft Excel, Google Sheets, and LibreOffice Calc — verified by actually running it. Syntax and links to each vendor’s official documentation are below.

Support matrix

EngineDocumentedLive-testedVerdict
Excel Yes Not yet n/a
Google Sheets Yes Not yet n/a
LibreOffice Calc Yes Yes (25.8.7.3, 2026-08-06) Quirk found

LibreOffice version history

We executed the same test cases under each LibreOffice release to show exactly when TYPE’s support changed — not documentation claims, real results.

LibreOffice versionVerdictTested
24.2.0.3 Quirk found 2026-07-19
24.8.7.2 Quirk found 2026-07-19
25.2.0.3 Quirk found 2026-07-24
25.8.7.3 Quirk found 2026-08-06

Why isn't TYPE working in LibreOffice?

TYPE exists in LibreOffice 25.8.7.3, but it is not a drop-in match for Excel — our executed tests found real behavioral differences (detailed in the test results on this page). If a formula that works in Excel or Google Sheets misbehaves in LibreOffice, compare your usage against the failing cases above before assuming your data is wrong.

Discovered quirks

Executed test cases

LibreOffice Calc 25.8.7.3 (tested 2026-08-06)

FormulaDescriptionResultExpectedVerdict
=TYPE(A1) A number -> code 1 1 1 Matched
=TYPE(A1) Text -> code 2 2 2 Matched
=TYPE(TRUE) A logical/boolean value -> code 4 1 4 Mismatch
=TYPE(1/0) An error value -> code 16. TYPE classifies the error's TYPE rather than propagating the error itself, matching ISERROR-style special-casing 16 16
Full 5-code table (1/2/4/16/64) confirmed via https://support.microsoft.com/en-us/office/type-function-45b4e688-4bc3-48b3-a105-ffa892995899		 Matched
=TYPE(A1:A3) A multi-cell array/range reference -> code 64 1 64 Mismatch

Docs & syntax