Combobox CellType AutoSearch

Posted by: silkkeng-fp on 8 September 2017, 2:22 pm EST

  • Posted 8 September 2017, 2:22 pm EST

    Hi,

    Please see attached project.

    We are using AutoSearch.MultipleCharacters.

    Please try steps below:

    1. Type "SU" on the combobox cell type, it return "SUZAKU"
    2. Note, you are still in Edit mode for that cell, wait for 3 seconds and type "SE" again on the combobox cell type without leaving the cell, it still returns "SUZAKU" instead of "SEIRYU"
        I assume this is due to AutoSearch cannot find "SUSE". Is this a correct?

    3. Then, you have to exit the Edit Mode and come back redo "SE" again to search for "SEIRYU". If you accidentally press on wrong key, you need to leave the cell and come back redo the same steps again to get it right.

     

    Is there a way to reset the search keyword after a result was found in the drop down list?

    1. Type "SU" and it return "SUZAKU"
    2. Type "SE" and it return "SEIRYU"
    3. Type "SU" again, it should return "SUZAKU"

     

    Kind Regards,
    David


    2010/06/SpreadTestCombobox.rar
  • Replied 8 September 2017, 2:22 pm EST

    Hello David,


    You can use SingleCharacter enum as of now for the AutoSearch property and i have also added your request to be added in future release and the feature request id for the same is
    #99916761.


    Thanks.

  • Replied 8 September 2017, 2:22 pm EST

    Hello,


     I have an editable Combobox CellType with the following properties set:


    - AutoSearch = True


    - AutoCompleteMode = SuggestAppend


    - AutoCompleteSource = ListItems


    How can I configure the Combobox such that the user can only type characters or words that are in the list items?


    Thanks,

  • Replied 8 September 2017, 2:22 pm EST

    Hello David,


    You are correct that once we will type "SU" and then on typing "SE" it will take the word as "SUSE" and therefore its returning "SUZAKU" only as there is no word matching starting with "SUSE". This is the expected behavior that when in edit mode you get to see words matching with SU appended with SE rather than starting with SE, it will find the word with SUSE. And unfortunately, i didn't any way to reset the search keyword afterwards except than leaving the edit mode.


    Thanks.

  • Replied 8 September 2017, 2:22 pm EST

    Hi Reeva,

    Thank you for explanation.

    There is another option called 'SingleCharacter' that we can used for now. Would it be possible to have an enhancement in the future that accept maximum 2 characters?

     

    Kind Regards,

    David

     

  • Replied 8 September 2017, 2:22 pm EST

    Hello,

    I don't find a direct way to do this, you need to capture spread's  KeyPress event the and compare the First letter in the Drop down list with the key pressed.

     

    Thanks,

     

  • Replied 8 September 2017, 2:22 pm EST

    Hi Deepak,

    We are revisit the option in ticket #99916761.

    Is this available in Spread. 5.2008.2008 or latest version?

    If it is not, can you please advise if there is a way to achieve this?

    Given that a drop down list has more than 1000 items with similar name, it is ideal to have this option so user don't have to scroll thru to find out the exact items.

    Thank you.

    Kind Regards,
    David

     

  • Replied 8 September 2017, 2:22 pm EST

    David,

    Our developers are actively working on resolving the above mentioned bug.  However, I didn't find any work around for the same. Will update you once it will be fixed.

    Thanks.

Need extra support?

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

Learn More

Forum Channels