https://bugs.documentfoundation.org/show_bug.cgi?id=169099
Bug ID: 169099
Summary: Calc freezes after invalid data entry in Data
Validation cell
Product: LibreOffice
Version: 25.8.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.