https://bugs.documentfoundation.org/show_bug.cgi?id=170494
Bug ID: 170494
Summary: CELL("contents") does not work correctly with cell
validity
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
CELL("contents") does not work correctly with cell validity.
Steps to Reproduce:
1. Open new Calc.
2. Insert Cell Validity into Cell [A1]
Criteria tab :
Allow : Custom
Formula : ISODD(CELL("contents"))
Close the dialog without making any other settings.
By default, it should look like this:
Error Alert tab :
Checkbox : ☑
Action : Stop
This setting, similar to "ISODD(A1)", allows odd numbers but displays a stop
dialog when an even number is entered, with the value being rejected.
3. First, insert "1" in cell [A1].
You can enter it exactly as specified.
4. Next, insert "2" in cell [A1].
Actual Results:
5. You can also insert "2". The stop dialog will not appear.
Other even numbers or strings can also be inserted.
Expected Results:
5. Since "2" is not an odd number, the stop dialog will appear and the input
will be rejected.
Reproducible: Always
User Profile Reset: No
Additional Info:
Conversely, if you first insert "2" in step [3.], all subsequent inputs will be
rejected.
It appears that the initial value entered after creating the input rules locks
the result.
When saved and reopened, the state is reset, but it again locks the result
based on the first input upon opening.
It worked correctly until early December's master version (26.8.0.0.alpha0+).
Reproducible
[2025-12-16]
Version: 26.8.0.0.alpha0+ (X86_64)
Build ID: 680(Build:0)
CPU threads: 4; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster;
VCL: win
Locale: en-US (ja_JP); UI: en-US
Calc: CL threaded
Reproducible
[2026-01-26]
Version: 26.8.0.0.alpha0+ (X86_64)
Build ID: 680(Build:0)
CPU threads: 4; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster;
VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL threaded
Reproducible
[2026-01-14]
Version: 26.8.0.0.alpha0+ (X86_64)
Build ID: fe4cb5de3fa77562a1a4decc67836e8f79000400
CPU threads: 2; OS: Linux 6.14; UI render: default; VCL: kf5 (cairo+xcb)
Locale: ja-JP (ja_JP.UTF-8); UI: en-US
Calc: threaded
---
Not Reproducible
Version: 26.2.0.2 (X86_64)
Build ID: 620(Build:2)
CPU threads: 4; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster;
VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL threaded
Not Reproducible
[2025-12-07]
Version: 26.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 680(Build:0)
CPU threads: 4; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan;
VCL: win
Locale: en-US (ja_JP); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
