ODD in Collabora Office: Round Away from Zero to an Odd Integer

• Introduced: documented by Collabora Office 26.04; the original introduction release is not established.
• Availability: ODD is documented in the official 26.04 Calc Help.
• Scope: desktop Calc documentation; separately deployed Online and mobile versions have not been verified.
• Checked: October 13, 2026, against the official ODD reference. Documentation check; not a native application test. Expected examples are independently calculated.

=ODD(number)

Positive inputs move upward to an odd integer and negative inputs move downward. An input already equal to an odd integer is unchanged. The zero result is not zero because zero is even; the documented convention returns one.

ODD returns a number, not a Boolean parity classification. It does not tell you simply whether the original input is odd. A decimal such as 4.2 can be accepted as a rounding input even though it is not an integer to classify by parity.

Enter these inputs in A2:A8 and fill =ODD(A2) down column B:

The result jumps when the input moves just beyond an odd integer. For example, 1 remains 1, while 1.01 becomes 3. This is intentional odd-integer rounding, not nearest-integer rounding.

For negative inputs, “up” in magnitude means a smaller number on the number line. Describing the rule as away from zero avoids that terminology trap.

A centered display needs one middle position and the same number of positions on each side. If a positive requirement of 8 positions is stored in D2:

=ODD(D2)

Expected result: 9 total positions. The side count is:

=(ODD(D2)-1)/2

Expected result: 4 positions on each side. One central position plus two groups of four makes nine.

This model assumes positive integer requirements. It does not decide whether rounding up is appropriate for the real layout, or whether physical space exists for the extra position.

=ODD(7)
=ODD(8)

Expected results: 7 and 9. An odd input is not moved to the following odd integer; it already meets the requirement. An even positive input needs one additional position.

This is useful when the requirement is “at least this many, and odd.” It is not suitable for “at most this many” without a different explicit rule.

Suppose a numerical method requires a positive odd window length so that one observation sits in the center. A requested length of 10 can be converted with:

=ODD(10)

The expected length is 11, with (11-1)/2 = 5 neighbors on each side. A request of 9 stays 9, giving four neighbors on each side.

This only constructs a candidate window length. It does not prove that a smoothing method is statistically appropriate or that enough neighboring observations exist at the start and end of a dataset. Boundary handling is a separate part of the algorithm.

For input 4.2, ODD gives 5, EVEN gives 6 and nearest-whole-number ROUND gives 4. Each function follows a different constraint. Select the rule from the intended calculation rather than choosing whichever output looks convenient.

At zero, the distinction is especially clear: ODD gives one and EVEN gives zero. Do not assume the two functions are symmetric replacements when zero is possible.

If a value displayed as 7 rounds to 9, inspect the stored value for a small amount above seven. Number formatting can hide that fraction. If the result is negative in a physical group-size calculation, validate the input instead of treating the rounded result as an allowed capacity.

For a native acceptance test, record the Collabora build, reproduce the seven-row table, and verify the centered nine-position and eleven-position examples. The results here follow independent arithmetic and the official documented zero convention; no native application execution is claimed.

• Collabora Office 26.04: ODD, checked October 13, 2026.
• Editorial standards.