User Story

As an end-user, I want a validation dropdown can show items based on my current input in a cell the validation popup is open while I am editing a cell.

Acceptance Criteria

1. Show All Items on Click:
When opening the dropdown by clicking the dropdown button, it should show all items.
2. Dynamic Filtering on Edit:
When opening the dropdown while editing a cell, the dropdown shows those items filtered by the current cell value.
3. Empty Cell Behavior:
If the cell is empty, the dropdown shows all items.
4. Match Items with Starting String in Case-Insensitivity:
The filtering should be based on matching items that start with the current cell value. For example, if the cell value is "ac", the dropdown should list those items starting with "ac".
6. Live Update:
As the user continues to type in the cell, the dropdown should live update to reflect the currently typed value, continuously narrowing down the list of options.

Details