Base cell type on value selected from MultiOptionCellType

Posted by: ginacresse on 8 September 2017, 3:06 pm EST

  • Posted 8 September 2017, 3:06 pm EST

    I have a spread with column 0 as a MultiOptionCellType with 2 options. If the user selects the first option, then I want column 1 to be a combobox on that row, but if the user selects option 2 then I want a textbox.  I'd like to have the combobox already populated so I can just show it without having to populate it on a row-by-row basis.  Is there a way to do this with Spread?


  • Replied 8 September 2017, 3:06 pm EST


    The EditorValueChanged event is fired as soon as the value is selected in the MultioptionCellType. You can set the celltype to ComboBoxCellType or TextBoxCellType depending on the option selected. Please have a look at the attached sample that fulfills your requirement.

    Hope it helps. Please let me know if I missed something.


    Manpreet Kaur

Need extra support?

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

Learn More

Forum Channels