AutoComplete within flexsheet

Originally Posted 12 July 2017, 8:36 am EST

  • Originally Posted 12 July 2017, 8:36 am 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
  • Reply

    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
  • Reply

    Hi,
    We are investigating on this.

    Thanks,
    Manish Kumar Gupta
  • Reply

    Hi ,

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

    Thanks,
    Vishnu Priya
  • Reply

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

    Thanks,
    Manish Kumar Gupta
  • Reply

    Hi,

    Is it possible for columns which are dynamically populating.

    Thanks,
    Vishnu Priya
  • Reply

    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
  • Reply

    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
  • Reply

    Hi Manish,

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

    Thanks,
    Sasmita
  • Reply

    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
  • Reply

    Hi Manish,

    Is there any update on this.

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

    Thanks,
    Abhishek
  • Reply

    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
  • Reply

    Dear Manish,

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

    Thanks,
    Abhishek
  • Reply

    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
  • Reply

    Hi Manish,

    I have changed it to AutoComplete. But it's still not working in "itemFormatter" function. Please suggest
    .
    Thanks,
    Abhishek
  • Reply

    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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels