https://bugs.documentfoundation.org/show_bug.cgi?id=151165
Bug ID: 151165
Summary: [EDITING] [DOCUMENTATION] ISODD and ISEVEN behavior
Product: LibreOffice
Version: 7.3.6.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
ISODD is documented in the function wizard as
> Returns TRUE if value is an odd integer
The assumption, based on the text, is that ISODD returns FALSE if the value is
not an odd integer.
There are a few cases that are inconsistent with the body text:
1) `ISODD(7.262)` is TRUE, but `7.262` is not an integer
2) `ISODD("7.262")` is Err: 504
What is the intention of ISODD (and ISEVEN) ? If the behavior is expected, the
documentation should be rewritten.
Steps to Reproduce:
Enter the formula `=ISODD(7.262)` in a cell
Actual Results:
TRUE
Expected Results:
FALSE
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Excel notes the miscellaneous behavior in the docs:
> If number is nonnumeric, ISODD returns the #VALUE! error value.
Curiously, it does not use the word "integer" in the description:
> Returns TRUE if number is odd, or FALSE if number is even.
But it does include an example that makes the definition clear:
> `ISODD(2.5)` "Checks whether 2.5 is odd" FALSE
--
You are receiving this mail because:
You are the assignee for the bug.
