Description:
After attempting to set a cell's data validation to allow a specified cell range, some parts of Calc seem to malfunction or freeze.  E.g. cannot create a new sheet, cannot close application without using Task Manager -> End Task.  CAN save file, but the Windows file lock doesn't automatically disappear after closing Calc (with Task Manager).


Safe mode didn't resolve, restarting computer didn't resolve.  I ended up reverting to previous stable version of Calc (25.2.6.2) but now I'm running into this bug: https://bugs.documentfoundation.org/show_bug.cgi?id=160096.  I didn't have this bug before, I could use a date list as a "suggested dates" dropdown list, but I was able to also manually input other dates (e.g. a future date to plan for future expenses in a budget spreadsheet), but now I am unable to do so.

Steps to Reproduce:
1.In any cell, Right Click -> Data Validation.
2.In Data Validation, set Allow Cell Range.
3.Attempt to select any range.
4.Calc is now in error state.

Actual Results:
Error state.  Can't even select a range for validation.

Expected Results:
Standard data validation using a named range... preferably with the option to use unlisted values (e.g. a date outside of a "helper list" range) without an error warning.  See https://bugs.documentfoundation.org/show_bug.cgi?id=160096


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 25.8.1.1 (X86_64)
Build ID: 54047653041915e595ad4e45cccea684809c77b5
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-GB
Calc: CL threaded