https://bugs.documentfoundation.org/show_bug.cgi?id=146887
Bug ID: 146887 Summary: In calc when I add a validity list to a cell it ignores hyphens in the search. Product: LibreOffice Version: 7.2.5.2 release Hardware: x86-64 (AMD64) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: mark.n.mo...@sky.com 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. -- You are receiving this mail because: You are the assignee for the bug.