https://bugs.documentfoundation.org/show_bug.cgi?id=172505
Bug ID: 172505
Summary: [26.8] ISODD() Function always returns TRUE
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The ISODD function requires one or two recalculations to produce correct
results when the number is not odd.
Steps to Reproduce:
1. Open new Calc.
2. Insert formula "=isodd(2)" into Cell [ A1 ].
Actual Results:
3. The result is "TRUE".
4. press (Ctrl + Shift + F9) two times.
5. Cell [ A1 ] changes to "FALSE".
6. Insert "1" into Cell [ A2 ].
7. press (Ctrl + Shift + F9).
8. Cell [ A1 ] changes to "TRUE".
9. press (Ctrl + Shift + F9).
10. Cell [ A1 ] changes to "FALSE".
Expected Results:
3. The result is "FALSE".
Reproducible: Always
User Profile Reset: No
Additional Info:
One or two recalculations are necessary to obtain correct results when it's not
an odd number.
When creating a new "=isodd(2)" expression from the Function Wizard, the result
will be "FALSE".
After reopening the Function Wizard and clicking OK without making any changes,
the result will automatically change to "TRUE".
This bug appears to occur on Linux-OS.
It seems to function correctly on Windows-OS.
This also affects the use of the ISODD function in Cell Validation or
Conditional formatting.
---
Reproducible in
[2026-06-12]
Version: 26.8.0.0.alpha1+ (X86_64)
Build ID: 19e55198a54365ae1348a602a7470df002774fb6
CPU threads: 2; OS: Linux 6.12; UI render: default; VCL: kf5 (cairo+xcb)
Locale: ja-JP (ja_JP.UTF-8); UI: en-US
Calc: threaded
Reproducible in
[2026-06-12]
Version: 26.8.0.0.alpha1+ (X86_64)
Build ID: 19e55198a54365ae1348a602a7470df002774fb6
CPU threads: 2; OS: Linux 6.12; UI render: default; VCL: x11
Locale: ja-JP (ja_JP.UTF-8); UI: en-US
Calc: threaded
Reproducible in
[2026-06-12]
Version: 26.8.0.0.alpha1+ (X86_64)
Build ID: 19e55198a54365ae1348a602a7470df002774fb6
CPU threads: 2; OS: Linux 6.12; UI render: default; VCL: gtk4
Locale: ja-JP (ja_JP.UTF-8); UI: en-US
Calc: threaded
Reproducible in
[2026-06-12]
Version: 26.8.0.0.alpha1+ (X86_64)
Build ID: 19e55198a54365ae1348a602a7470df002774fb6
CPU threads: 2; OS: Linux 6.12; UI render: default; VCL: qt5 (cairo+xcb)
Locale: ja-JP (ja_JP.UTF-8); UI: en-US
Calc: threaded
Reproducible in
[2026-04-30]
Version: 26.8.0.0.alpha0+ (X86_64)
Build ID: b1e601a83dc811319353499f023a11ecb710f8e5
CPU threads: 2; OS: Linux 6.12; UI render: default; VCL: kf5 (cairo+xcb)
Locale: ja-JP (ja_JP.UTF-8); UI: en-US
Calc: threaded
---
Not reproducible in
[2026-04-20]
Version: 26.8.0.0.alpha0+ (X86_64)
Build ID: 05f7513a5fec87296cfac298f5fd3bfd0e0fc4bb
CPU threads: 2; OS: Linux 6.12; UI render: default; VCL: kf5 (cairo+xcb)
Locale: ja-JP (ja_JP.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
