Description: I do volunteer data entry for the BTO. Every species cell in my calc spreadsheets has a validity drop-down list that contains about 4000 entries. Many are hyphenated names. When I am searching for a species in the drop-down by typing in the name it always ignores the hyphen I enter and skips to the species that starts with the next letter entered. Steps to Reproduce: 1. Make a validity list in a cell 2. Populate list with hyphenated and none hyphenated names 3. Call up the list and type a hyphenated name and it will skip the hyphen and find a an entry starting with the next letter entered. Actual Results: It skips to a completely different allowed entry starting with the next letter typed. Expected Results: It should have found the hyphenated entry. Reproducible: Always User Profile Reset: No Additional Info: This has happened on various issues of the software and also on all the spreadsheets I have produced.
Please attach a test sample file.
Created attachment 177691 [details] An example of a sheet I use. Please find attached one of the sheets I use. The validity list should still be attached to every species col cell. I use the list to add species that are not in the prepared file. If I want to replace something in the list or add an extra species I click on the list and start to type. If I want to add say 'Red-Throated Diver' , which is in the list in that form, I start to type R then e then d then when I type - it ignores that and waits for the D at which point it divert to the species starting with D. In all other cases , without a hyphen, it work fine.
Looks like. Version: 7.3.1.1 (x64) / LibreOffice Community Build ID: 349cd3ad57dce98d6b54b76f8e9f456ac7d7edb7 CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL And please avoid private messages.