This is a migrated thread and some comments may be shown as answers.

Can you use AutoComplete in the Spreadsheet

1 Answer 193 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
daryn
Top achievements
Rank 1
daryn asked on 17 Aug 2017, 09:49 AM

Hi,

Does the SpreadSheet support AutoComplete per cell?

This would be hints to the user as they type, which come from a predefined list.

Similar to this: http://demos.telerik.com/kendo-ui/autocomplete/template

 

The field validations are similar, but instead of a dropdown list, I would like the suggestions to show as the user types.

 

Thanks

 

 

 

1 Answer, 1 is accepted

Sort by
0
Dimitar
Telerik team
answered on 18 Aug 2017, 02:33 PM
Hello Daryn,

Integrating the AutoComplete widget in the Spreadsheet cell, that is being edited could not be achieved by configuring the widget. However, you could implement a Custom cell editor for the Spreadsheet, in which you could integrate the AutoComplete.

Here you could find a simple implementation of the above. The AutoComplete custom editor is configured for the B1 cell and it could be opened after selecting the cell and click on the "A" icon. Keep in mind, that you may have to adjust the suggested implementation according to your specific needs.

Regards,
Dimitar
Progress Telerik
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Spreadsheet
Asked by
daryn
Top achievements
Rank 1
Answers by
Dimitar
Telerik team
Share this question
or