Description: Description: When using Data → Validity → List (Data Validation) in LibreOffice Calc, entering a value that is not part of the list causes Calc to freeze in certain cases. This issue occurs only in recent versions (tested with LibreOffice 25.8.2.2), while version 24.x works correctly. Steps to Reproduce: 1. Open a new Calc spreadsheet. 2. Select a cell (e.g., A1). 3. Go to Data → Validity (Data Validation). 4. Choose Allow: List and enter something like Apple;Banana;Orange. 5. (Optional) Leave Show error message checked (default “Stop” behavior). 6. Click OK. 7. Now, type a word not in the list (for example, “Pear”) directly into the cell or the formula bar. 8. Press Enter. Actual Results: Result: The value is not accepted, but Calc becomes unresponsive: The text remains stuck in the formula bar. You cannot edit any other cell. The UI doesn’t recover until restarting Calc. However, if you paste “Pear” directly into the cell (Ctrl + V) instead of typing it, Calc behaves normally and does not freeze. Expected Results: Calc should reject invalid input and show the error alert (or ignore the input), but should not freeze the UI or stay stuck in edit mode. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 25.8.2.2 (X86_64) Build ID: d401f2107ccab8f924a8e2df40f573aab7605b6f CPU threads: 8; OS: Windows 11 X86_64 (build 26200); UI render: default; VCL: win Locale: fr-FR (fr_FR); UI: fr-FR Calc: CL threaded
No reproducible with Version: 25.8.3.1 (X86_64) Build ID: 52ad9dd1c984050a9fb6932dbfb16e86a49e9758 CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: threaded Some issues with Data Validity were resolved lately, please try updating.
Not reproduced. Version: 25.8.3.1 (X86_64) Build ID: 52ad9dd1c984050a9fb6932dbfb16e86a49e9758 CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL threaded Jumbo Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 620(Build:0) CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL threaded Jumbo However, if the error message is turned off in Step 5 of the Steps to Reproduce, similar bugs (Bug 167126 and Bug 168261) occur. It's not clear whether they're related, but I thought it might be worth mentioning.
No repro with Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 2595f031fa93c1eb89fb4dce6f337de9be813e15 CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded
Could not reproduce with the reported version. Version: 25.8.2.2 (X86_64) Build ID: d401f2107ccab8f924a8e2df40f573aab7605b6f CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL threaded Jumbo
I could not reproduce in these versions: Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 620(Build:0) CPU threads: 32; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded Version: 25.8.2.2 (X86_64) Build ID: d401f2107ccab8f924a8e2df40f573aab7605b6f CPU threads: 32; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded
Hello Anna, Thank you for reporting the bug. I can confirm that the bug is present in Version: 25.8.2.2 (AARCH64) Build ID: d401f2107ccab8f924a8e2df40f573aab7605b6f CPU threads: 11; OS: macOS 15.6.1; UI render: Skia/Metal; VCL: osx Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
*** This bug has been marked as a duplicate of bug 166527 ***