Disabled Autocomplete change remote result filtering

Questions
,
1

I’m using an autocompleter cell to enable user to select a value from remote data.

Remote data is a list of Book Titles like

  • Astrophysics: it is great!
  • Astrophysics: it is really complex!
  • Stop studing Astrophysics
  • ….
  • …

The book titles could be hard to remind so a user should search for a set of words he knows in the title (ex. “great astrophysics”)

My API accepts that query and returns the book which contains all words in the title, also if not that order (API service use the string as a set of words [space] separated), but my autocompleter cell doesn’t show the result, cause it doesn’t match the typed string

Is it possible to config my autocompleter to accepts all results from remote API or to use the typed string as a set of [space] separated words (so it can still highlight words)?

Thanks

Diego

2

Hi @salvio

I think that in the case it would be better for you to create a custom cell type. There is no official API to alter the way we highlight the cell. Alternatively, you can use a dropdown (which does not filter the results) to show all titles, no matter what is typed, but that also doesn’t seem to meet the requirements. I believe that you would need to alter this logic handsontable/handsontable/src/editors/autocompleteEditor/autocompleteEditor.js at 85b9898adb72b902465e7671cfbc63654502693e · handsontable/handsontable · GitHub (raw choices array)