Cell Autocomplete in SpreadJS

Cell Autocomplete in SpreadJS

Posted by: dscottie on 8 September 2017, 9:48 am EST

• 

  dscottie

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 September 2017, 9:48 am EST

  Hi,

  I’m trying to add autocomplete functionality to a column in SpreadJS, such that as the user types into a cell a dropdown list will appear with matching items retrieved from the server. The SpreadJS documentation states:

  SpreadJS supports combo box, check box, button, text, hyperlink, Wijmo edit cell (AutoCompleteTextBox), and custom cell types.

  http://helpcentral.componentone.com/NetHelp/SpreadHClientUG/celltypes.html

  AutoCompleteTextBox sounds promising; however, I couldn’t find any documentation or samples that demonstrate how this can be achieved. I know I could create a custom cell type, but if I can leverage functionality that is already there it would be much better!

  Does anyone know how I can implement this?

  Thanks, Scottie

• 

  manpreetkaur

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 9:48 am EST

  Hello,

  Unfortunately, I could not find any information regarding the implementation of the AutoComplete TextBox mentioned in the documentation. I have escalated the issue to the concerned team for further discussion. I would let you know as soon as I get any information in this regard.

  Currently, you can have the list of valid values present as a dropdown in the cell by using the “createListValidator” method of SpreadJS. You may refer to the following documentation link, which describes the same: http://helpcentral.componentone.com/NetHelp/SpreadHClientUG/webframe.html#Spread~$.wijmo.wijspread.DefaultDataValidator~createListValidator.html. You can check this online sample to check its implementation, at the following link: http://wijmo.com/demo/spreadjs/samples/ExplorerSample/?widget=Validation&sample=Validation.

  Thanks,
  
  Manpreet Kaur

• 

  manpreetkaur

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 9:48 am EST

  Hello,

  As per the development team, SpreadJS does not supports AutoComplete celltype currently. It was a documentation issue, which has been fixed.

  In the meanwhile you can create a custom celltype to achieve the desired feature by using the wijmo combobox widget. Kindly refer to the attached HTML Page which implements the same.

  Hope it helps.

  Thanks,
  
  Manpreet Kaur

• 

  dscottie

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 9:48 am EST

  Thanks for your help Manpreet, this is very useful!

  Scottie

• 

  vincentxu

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 9:48 am EST

  I am also trying to implement this. I do not see a sample attachment. Can I also get it?

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 9:48 am EST

  Hello,

  Here is the attachment from the old post.

  Hope it helps.

  Thanks,
  
  Reeva
  
  2015/08/SpreadJS_AutoCompleteCellType-4.html