AutoComplete within flexsheet

AutoComplete within flexsheet

Posted by: vishnupriyamaheendran on 14 September 2017, 12:09 pm EST

• 

  vishnupriyamaheendran

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:09 pm EST

  Hi,

  We have a requirement to show autocomplete within flexsheet. Currently i am using below code to map the response to each cell using Data Map. Is there anyway to make the datamap work like autocomplete.

  column.dataMap = response;

  DataMap is working like dropdown.

  Could some please suggest a solution.

  Thanks,
  
  Vishnu Priya

• 

  manish-gupta1

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:09 pm EST

  Hi,
  
  We are investigating on this.

  Thanks,
  
  Manish Kumar Gupta

• 

  manish-gupta1

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:09 pm EST

  Hi Vishnu,
  
  This is by design. We cannot change the data map behavior. You can use AutoComplete control using itemFormattor. You need to set cell value on value changed.

  Thanks,
  
  Manish Kumar Gupta

• 

  vishnupriyamaheendran

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:09 pm EST

  Hi,

  Is it possible for columns which are dynamically populating.

  Thanks,
  
  Vishnu Priya

• 

  manish-gupta1

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:09 pm EST

  Hi Vishnu,
  
  If you know the column binding or column index, it is possible by using condition in itemFormatter.

  Thanks,
  
  Manish Kumar Gupta

• 

  vishnupriyamaheendran

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:09 pm EST

  Hi ,

  Can you provide some sample code with multiple autocomplete field inside flexsheet using dynamically populated fields.

  Thanks,
  
  Vishnu Priya

• 

  sinoliu

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:09 pm EST

  Hi Manish,

  we are using Flexsheet with Angular 2. We are facing some problem on the above issue.
  
  Instead of datamap, we have used this below code to put autocomplete control to flexsheet cell:
  
  if (panel.cellType ==wjcGrid.CellType.Cell && column.index == c) {
  
  // if(column.index == c && r!=0){

      //         var cmb = new wjinput.AutoComplete(cell, {
      //              itemsSource: response
      //             // selectedItem: panel.grid.getCellData(r, c, false)
      //         });
      //     }
  

  but this is not working. can you provide any demo applying the same?
  
  and also i have another doubt, can’t we use 2 itemformatter for a flexsheet?

  Thanks,
  
  Sasmita

• 

  manish-gupta1

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:09 pm EST

  Hello Vishnu/Sasmita,
  
  Please find the attached sample that depicts how the AutoComplete can be used as dataMap.

  Thanks,
  
  Manish Kumar Gupta
  
  2017/07/FlexSheet_CustomEditor_DataMap.zip

• 

  sinoliu

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:09 pm EST

  Hi Manish,

  This is not working. if possible can you please give a angular 2-flexsheet example.

  Thanks,
  
  Sasmita

• 

  manish-gupta1

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:09 pm EST

  Hello Sasmita,
  
  We are able to replicate the issue with NG2 version sample. It requires further investigation. Hence, this issue has been escalated to the concerned team for further investigation with tracking id 276992.
  
  We will let you know as soon as we get any information on this.

  Thanks,
  
  Manish Kumar Gupta

• 

  ashrivastav1

  • Post Options:
  • Link
    Copy

  Posted 20 September 2017, 2:44 am EST

  Hi Manish,

  Is there any update on this.

  I have same requirement in my Angular 2 + Wijmo 5 project in Flexsheet.

  Thanks,
  
  Abhishek

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 22 September 2017, 9:11 am EST

  Hi All,
  
  Please find the attached sample for the same. And let me know if you have any furhter queries.

  Thanks,
  
  Manish Kumar Gupta

  FlexSheet_AutoComplete_DataMap_Ng2.zip

• 

  ashrivastav1

  • Post Options:
  • Link
    Copy

  Posted 26 September 2017, 8:21 am EST

  Dear Manish,

  It’s still not working. I can see the drop down but autocomplete not working.

  Thanks,
  
  Abhishek

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 27 September 2017, 7:50 am EST

  Hi Abhishek,
  
  The project shared previously is using combobox. you can replace it to AutoComplete from ComboBox in app.component.ts file.

  Thanks
  
  Manish Kumar Gupta

• 

  ashrivastav1

  • Post Options:
  • Link
    Copy

  Posted 4 October 2017, 5:59 am EST

  Hi Manish,

  I have changed it to AutoComplete. But it’s still not working in “itemFormatter” function. Please suggest
  
  .
  
  Thanks,
  
  Abhishek

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 9 October 2017, 1:30 am EST

  Hi Abhishek,
  
  We are sorry for the delayed response.
  
  The AutoComplete works fine at our end with itemFormattor too. Please refer to the attached sample for the same.
  
  In case, it do not work, please try with formatItem.

  ~Manish Kr Gupta

  FlexSheet_DataMap_itemFormatter.zip