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

Represent a nonnegative decimal whole number using base-16 digits; the optional places argument pads shorter values with leading zeros. The formula is =DEC2HEX(number, [places]) according to the ONLYOFFICE DEC2HEX 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 decimal whole number using base-16 digits; the optional places argument pads shorter values with leading zeros. Each hexadecimal position is worth a power of 16, counted from the right (1, 16, 256, …); letters A through F mean 10 through 15. The official function reference categorizes DEC2HEX 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.

=DEC2HEX(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 DEC2HEX 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 =DEC2HEX(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.

Encode an eight-bit colour channel

If B2 contains numeric 127, then =DEC2HEX(B2,2) independently represents that channel as 7F. Pad to two digits for channels 0–255; this is a numeric conversion, not validation of complete colour notation.

Use four-character diagnostic IDs

=DEC2HEX(42,4) has a mathematical output of 002A; =DEC2HEX(42) has minimal output 2A. The original decimal value is the same. A fixed-width ID may require leading zeros for visual consistency.

Round-trip to the original value

=HEX2DEC(DEC2HEX(255,4)) mathematically returns 255. Signed-number and maximum-width compatibility need separate testing; do not extrapolate from this small positive example.

Alternative BASE conversion

=BASE(255,16,4) mathematically formats the same value as 00FF, but BASE has its own documented range, radix and padding semantics. Its presence does not prove that DEC2HEX supports every BASE input.

Do not infer undocumented limits. The current function page does not establish complete signed-number limits, truncation of fractional inputs, maximum width, case of output letters, or all too-small-places outcomes. Worked calculations use nonnegative integers and conventional uppercase hexadecimal representations; exact runtime rendering remains untested. 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 DEC2HEX. 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 DEC2HEX 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: HEX2DEC, DEC2BIN, 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 DEC2HEX.

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.