1. Feedback
  2. Angular
  3. 66887

Welcome to the Angular feedback portal. We’re happy you’re here! If you have feedback on how to improve the Angular, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

1
Vote

Support for Excel-Like Auto Suggestions and Searchable Dropdowns in Spreadsheet

Feature Goal:

Enhance the data entry experience in the Spreadsheet component by introducing:

  • Auto suggestions from existing values within the same column, similar to Microsoft Excel.

  • Searchable dropdowns in list-based data validation cells that dynamically filter as the user types.

These enhancements reduce repetitive typing, minimize manual errors, and improve the user experience — especially when handling large datasets or lengthy value lists.

Scenario 1 – Column-Based Auto Suggestions While Typing

Enable the Spreadsheet component to provide auto-suggestions while typing in a cell, based on previously entered values in the same column similar to Microsoft Excel.

Example: When a user begins typing a value in a cell (e.g., typing "Lux"), the component should suggest "Luxembourg" if that value already exists in another cell in the same column. This improves data entry speed and ensures consistency in repeated entries.


Scenario 2 – Searchable Dropdowns in Data Validation Cells

Enhance the existing list data-validation dropdown functionality in cells to support dynamic search/filtering as the user types. 

Example: In a dropdown list with many items (e.g., 50 countries), typing "G" in the dropdown cell should instantly filter and display matching entries like "Germany", "Greece", etc. This helps users quickly locate and select the desired option without excessive scrolling.

 

Attached the video demonstration for reference for the above scenarios.


EXCEL_jrenYKEX1d.gif