DEC2BIN Function (Calligra Sheets)

• Introduced: First release not established; the name is present in Calligra 2.4.0 source.
• Supported in: Calligra Sheets 26.08.2, with no retirement established.
• Scope: Desktop Sheets with the Engineering function module. Examples use English semicolon-separated formulas.
• Checked: October 14, 2026. Formulas were executed through the official 25.04.2 engine library, with source and independent arithmetic checks. This is not GUI-cell or workbook-import evidence; 26.08.2 was source-checked, not executed.

DEC2BIN converts the value of a decimal integer into a base-2 text string. Binary digits count powers of two, so 13 becomes 1101. A width argument can add leading zeroes without changing the encoded integer. Function help.

=DEC2BIN(number[;places])

Number is required; places is an optional minimum output length. Although the short help syntax shows only one argument, the registered function accepts one or two. For reliable conversion use a nonnegative integer and a nonnegative integer width. The wrapper checks that its string representation contains decimal digits only. Brackets mark optional arguments and are not entered in a formula. Registration, implementation and versioned help.

These outputs were obtained through Calligra 25.04.2’s Formula parser and calculation library. The ordinary conversions also match independent positional arithmetic. Backticks preserve literal leading zeroes; they are not part of the entered result.

Put 13 in A2 and 8 in B2. Enter =DEC2BIN(A2;B2) to obtain 00001101. This is useful when displaying an eight-position bit field. In this example the set positions have weights 8, 4 and 1; all other positions are zero. Format or import the resulting field as text when another application needs to retain those leading zeroes.

The recorded check =BIN2DEC(DEC2BIN(13;8)) returns numeric 13. Reversibility checks the value, while the original text retains the width. An eight-digit nonnegative binary field covers 0 through 255. The implementation also returns 1000000000 for 512, so do not infer a signed ten-bit limit from another spreadsheet’s DEC2BIN rules.

If places is shorter than the necessary representation, the output is not truncated: DEC2BIN(16;2) gives 10000. Validate the capacity separately when a hardware or file format imposes a maximum width.

Negative numbers and decimal fractions such as 3.5 failed the wrapper’s digit check and returned #VALUE! in the engine tests. Numeric text “13” was accepted. An optional negative width did not add padding; a fractional width was converted to an integer. Prefer explicit valid integer inputs rather than relying on those coercions.

The following engine results show the specific inputs tested. They do not establish every text-format, locale or import rule.

The shared text-conversion helper narrows the numeric input to a C++ int before formatting it. These small integer examples do not establish safe conversion of arbitrary large identifiers. Validate the intended value and field width before export; do not assume another spreadsheet’s numeric limits or signed convention.

The Engineering module and conversion helper are byte-identical in the inspected 25.04.2 and 26.08.2 source files. That supports the source comparison, but does not turn these engine tests into execution of a newer binary or confirmation of its UI/import behavior.