How can we populate a combobox via ajax?

How can we populate a combobox via ajax?

Posted by: mserban on 28 May 2018, 11:11 pm EST

• 

  mserban

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 May 2018, 11:11 pm EST

  Hi,

  Can you, please, show me an example of how to populate a combobox cell type via an ajax request? I need to populate on demand, when the user clicks on the arrow, using some sort of loading or UI blocking until the response comes back from the server. Response is very much appreciated.

  Thanks,
  
  Mircea

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 31 May 2018, 10:31 pm EST

  Hi Mircea,

  You are right, the dropdown shows as soon as you click the combobox drop down button.
  
  I don’t find a way to cause delay in dropdown for ComboBox celltype in SpreadJS. I will further discuss this issue with the development team and let you know if we find a solution or workaround. The tracking id for this issue is 259061.

  Thanks,
  
  Deepak Sharma

• 

  mserban

  • Post Options:
  • Link
    Copy

  Posted 31 May 2018, 11:21 pm EST

  Hi Deepak,

  Thanks for your answer, we’ll be waiting for some feedback.

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 3 June 2018, 5:22 pm EST

  Hello,

  We will update you as soon as we hear anything from our concerned team.

  Thanks,
  
  Reeva

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 12 June 2018, 5:55 pm EST

  Hello,

  Currently SpreadJS combobox celltype does not support this feature.
  
  You can use any 3rd party combo which supports ajax call fetching data and then use it in a cell with custom cell type.

  To know how to create a custom celltype you can go through the documentation online.
  
  http://help.grapecity.com/spread/SpreadSheets11/webframe.html#SpreadJS~GC.Spread.Sheets.CellTypes.Base~setEditorValue.html

  Thanks,
  
  Deepak Shar,a