ISODD_ADD Function (LibreOffice Calc)

• Introduced: First release not established; documented by LibreOffice 3.3.
• Supported in: Documented in LibreOffice 26.8 Help and registered in 26.8.1.1. No retirement is established.
• Scope: Desktop Calc, English compatibility function name and semicolon-separated formulas. A suffix does not by itself mean deprecated or retired.
• Checked: October 14, 2026. Eight reference calculations and the function-specific documentation were checked. The integer callback was inspected. No native execution is claimed.

ISODD_ADD returns numeric 1 for an odd integer and numeric 0 for an even integer. It belongs to the Analysis add-in and is separately registered from core ISODD. Its implementation tests the least significant bit of a signed integer. Function-specific Help.

LibreOffice’s documentation describes _ADD names as compatibility variants associated with Excel 2003 behavior and recommends the unsuffixed functions for standards-oriented results. Keep the exact original function name when evaluating an imported workbook.

=ISODD_ADD(Number)

• Number: integer whose parity is required.

The add-in declares exactly one signed 32-bit integer input and an integer return. The examples use small exact integers; they do not establish fractional or out-of-range conversion behavior.

These references use integer parity and the inspected integer callback. The results are exact for the small integers shown.

Inputs 1, 7, −1 and −7 return 1 in the independent integer check. Inputs 0, 2, −2 and 100 return 0. An odd negative integer is still odd: −7=2×(−4)+1, so its parity is consistent with the positive case.

The result can act as a numeric indicator in an integer classification worksheet. For example, among the eight inputs listed above there are four odd values, so the independent sum of their indicators is 4. That count assumes these are intentional integer inputs, not unvalidated text identifiers.

The source uses nVal & 1 and chooses integer 1 or 0. For the listed integer set, adding ISODD_ADD and ISEVEN_ADD gives 1 for each value. The eight odd indicators sum to 4, while the eight even indicators also sum to 4.

Keep the declared integer return type and the exact English function name explicit in compatibility work. Core parity functions may have their own argument conversions or logical result formatting. Matching a few ordinary integers does not establish equality across text, blank, error or fractional inputs.

The add-in interface is narrower than an unrestricted mathematical integer domain: it declares a signed 32-bit input. No boundary-size integer, fractional, text, blank or error argument was executed. Validate your intended input before relying on an indicator.

Do not call zero odd because its numeric result is zero; here zero is the false indicator. This function returns 1 when the input is odd. Preserve the _ADD name when documenting an existing formula so a later migration does not silently change which native implementation is being discussed.

ISODD, ISEVEN, MOD.

• Function-specific Help and compatibility note
• Versioned Analysis add-in registration
• Complete integer parity callback

The references establish the documented ordinary model and the source’s signed integer input/return contract. Native execution, exceptional-input behavior and cross-product equivalence remain unverified.