ReoGrid Forum

Fast and powerful .NET Spreadsheet Component

You are not logged in.

Announcement

This forum has been archived and no longer accepts new user registrations. Please report your questions, problems, and feedback to the issue page of ReoGrid on GitHub. Thank you for your cooperation.

https://github.com/unvell/ReoGrid/issues

#1 2016-04-17 02:17:32

srinireogrid
Member
Registered: 2016-04-02
Posts: 5

Excel Cell With auto complete feature is there.?

Hi Jing,
          reogrid has dropdowncell using that we can prevent the user to type and make him select an option. How ever in my case user might have 5000 records also.
then it is difficult for them to find the option and select it. Is it possible to have a control like auto complete textbox so that when user types something in the cell itdelf,  it will dynamically filter and reduce the records so that user can easily find his option and select.?

Thanks for your wonderful control Jing.

Offline

#2 2016-04-17 08:23:58

Jingwood
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: Excel Cell With auto complete feature is there.?

Thanks. Hope it helps you. Does the auto-complete text box have drop-down candidates list? Like the Visual Studio intellisense auto-complete?

Maybe you could use CellEditTextChanging event to detect the text during user edit, then set the Worksheet.CellEditText property to replace user's input. Auto-complete text box is a difficult control.

Last edited by Jingwood (2016-04-17 08:34:45)

Offline

#3 2016-04-17 08:32:54

srinireogrid
Member
Registered: 2016-04-02
Posts: 5

Re: Excel Cell With auto complete feature is there.?

Yes jing. According to the entered cell value suggestions should show the filtered data in a grid. I need the drop down list box control. My additional requirement is user should able to type and filter the data and select the option

Offline

#4 2016-04-17 08:37:55

Jingwood
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: Excel Cell With auto complete feature is there.?

On-worksheet auto-complete text box has good user experience, but it is difficult to be implemented. Maybe you could consider to make your own user control and put it into the drop-down panel of drop-down cell.

Offline

#5 2016-04-17 08:39:24

srinireogrid
Member
Registered: 2016-04-02
Posts: 5

Re: Excel Cell With auto complete feature is there.?

OK jing

Offline

Board footer

Powered by FluxBB