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: [email protected]
Reporter: [email protected]
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.