DEC2BIN Function in ONLYOFFICE Spreadsheet Editor: Syntax, Examples and Troubleshooting

• Introduced: The original introduction version and date are not established by the official sources checked.
• Availability: Documented in the current ONLYOFFICE Spreadsheet Editor help; no final working-version endpoint is established.
• Scope: Docs and Desktop Editors release separately. This unversioned help does not establish availability in every older build, mobile client or deployment.
• Checked: October 14, 2026, against the official function reference. Documentation check; not a new native test.

Represent a nonnegative whole-number quantity with binary digits; the optional places argument adds left-hand zeros for fixed-width output. The formula is =DEC2BIN(number, [places]) according to the ONLYOFFICE DEC2BIN help article. All worked outputs below are mathematical expectations obtained independently; none is an observed result from a running copy of ONLYOFFICE.

Represent a nonnegative whole-number quantity with binary digits; the optional places argument adds left-hand zeros for fixed-width output. Each binary position is worth a power of 2, counted from the right (1, 2, 4, 8, 16, …). The official function reference categorizes DEC2BIN as an engineering function.

This is a base conversion, not a change to a worksheet’s number formatting. Keep original values alongside their converted equivalents so readers can audit the conversion. The expected results are text-style base digits, not ordinary decimal numeric values. In the independent comparison, uppercase A–F is conventional for hexadecimal, but vendor output casing has not been natively checked.

=DEC2BIN(number, [places])

The argument order is required number followed by optional places. The brackets around optional parameters in documentation are syntax notation; do not type square brackets into your worksheet. Exact source: ONLYOFFICE DEC2BIN function, checked 2026-10-13.

Use only small, nonnegative whole numbers in these examples; the official page does not establish the full signed input range. Decimal-base integers are not automatically binary or hexadecimal strings just because they contain digit characters. A quoted formula literal such as "1010" prevents loss of leading zeros in the expression; cell data may require Text formatting. Do not assume that text coercion, whitespace, lowercase input, signed encodings, or fractional inputs behave exactly like Excel or another editor.

1. Open a blank spreadsheet in the editor you plan to support and create headers A1 = Use case, B1 = Input, C1 = Formula / result. Treat these columns as a self-contained audit worksheet.
2. Enter B2:B17 as ordinary nonnegative integer values, not as quoted strings. For a fixed-width representation, add a separate width column and use the places argument as shown later.
3. Type the source values in column B exactly as shown. In C2, enter =DEC2BIN(B2), and then fill down through C17. Verify the function name using the editor’s Formula tab, Insert Function dialog or Shift+F3, as described in the official formula-entry guide.
4. Compare displayed values against the independent mathematical expectations below. Record the program edition, version, operating system and formula language if native results differ; this manuscript contains no native execution data.
5. Keep the unconverted column unchanged so that original inputs remain available for comparison.

Ready-to-paste formulas

The following use literal inputs rather than cell references. Quotes mark a base representation as text where applicable; the expected results are calculated independently using powers of the base.

Mathematical verification method: For conversion to decimal, evaluate the position weights in base 2 or 16. For conversion from decimal, repeatedly divide by the target base and read remainders from right to left (or equivalently compute the exact integer base representation). For text width, add leading zeros without changing the magnitude. These are not tests executed by ONLYOFFICE.

The official help describes places as a display width; omitted means the minimum width. These examples use values for which the requested width can contain all digits. The zero padding is on the left, never on the right. The table is an independently calculated expectation, not proof of a particular edition’s padding behaviour.

If the chosen width cannot hold the conversion, do not assume a specific error code unless the version’s official documentation or native test establishes it. The vendor specifically confirms #NUM! for places <= 0; other width limits require testing.

Fixed-width inventory flags

If A2 contains 45, the formula =DEC2BIN(A2,8) independently yields 00101101. Eight characters can be used to show eight positions even though the numeric value requires only six binary digits.

Build a value-by-value conversion column

Keep decimal counts in A2:A17 and use =DEC2BIN(A2) in B2, copying downward. Store labels separately. A number with a binary appearance should not replace your original decimal count; retaining both helps audit conversions.

Round-trip independently

=BIN2DEC(DEC2BIN(45,8)) mathematically returns 45. This uses two official functions, but the nested formula is not an observed ONLYOFFICE test and may expose differences on signed/boundary values.

Alternative with BASE

=BASE(45,2,8) should represent the same positive integer and width mathematically, 00101101. BASE has a separately documented input range and base/radix argument, so do not substitute BASE to assert DEC2BIN handles larger values.

Do not infer undocumented limits. The official help does not supply a full signed-number range, fractional-input policy, or all too-small/too-large places outcomes. Examples deliberately use nonnegative integers at most 255; negative, fractional, and boundary cases require native version-specific verification. If a value is outside the clearly covered range, record it as needs native validation, not as a verified ONLYOFFICE output or an assumed error message. Invalid input can produce different errors depending on the case; this guide only attributes #NUM! to cases that the vendor explicitly documents.

• Current reference scope: The official English, unversioned ONLYOFFICE Spreadsheet Editor catalogue lists DEC2BIN. The Insert Function documentation explains both typing formulas and choosing them from the function wizard. This is documentation confirmation, not a runtime test.
• Web/Docs versions: The ONLYOFFICE Docs changelog lists Docs 10.0.0, released 2026-10-10. This is the release context checked on 2026-10-13; it does not prove DEC2BIN was introduced then, nor establish its first-supported version.
• Desktop versions: The distinct ONLYOFFICE Desktop Editors changelog lists Desktop 9.4.0, released 2026-05-19 at the time of research. Desktop and web deployment version numbers cannot be interchanged. This source does not establish this function’s first Desktop release.
• Historical releases and editions: No full historical execution matrix was available. Do not claim working support in older Docs/Desktop builds or specific editions without a vendor release note or directly recorded native test.
• Locale and syntax: The Advanced Settings instructions say formula language and regional settings are configurable. The function-entry guide uses English names and comma argument separators. Localized function names, decimal separators, accepted text coercions, and display formatting have not been checked in a live editor.
• Excel/Sheets/LibreOffice compatibility: This page makes no execution claim about those products. Their formats, sign rules, size limits and error behaviour cannot substitute for ONLYOFFICE verification.

Related ONLYOFFICE function documentation: BIN2DEC, DEC2HEX, BASE, DECIMAL. These vendor links were individually opened/checked on 2026-10-13.

For a base-independent representation, ONLYOFFICE documents BASE (number, radix, optional minimum length). For reading a text numeral in a specified radix, it documents DECIMAL (text, radix). These are related mathematical tools, not proof that their parameter limits or sign conventions equal those of DEC2BIN.

Verification limitations: Native execution in Desktop or Docs web, localized formula entry, quote/text coercion, signed boundaries and runtime error capture were not performed. Check these cases in the intended version before relying on them.