Bug 146887

Summary:	A validity list ignores hyphens in the search
Product:	LibreOffice	Reporter:	mark.n.moore
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	buzea.bogdan, miguelangelrv
Priority:	medium
Version:	7.2.5.2 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108988
Attachments:	An example of a sheet I use.

Description mark.n.moore 2022-01-20 22:10:52 UTC

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.

Comment 1 m_a_riosv 2022-01-21 17:24:57 UTC

Please attach a test sample file.

Comment 2 mark.n.moore 2022-01-21 18:25:56 UTC

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.

Comment 3 m_a_riosv 2022-02-21 19:45:21 UTC

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.