Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
110
Ultraspreadsheet & combobox
posted

Hi,

is there a way to let the user choose a value to input in a spreadsheet cell from a combobox?

Like the combobox cell type in the ultragridc control.

Thanks in advance.

Best,

Raul

Parents
  • 28970
    Offline posted

    Hello Raul,

    In order to have a combobox or dropdown in the UltraSpreadsheet control, you need to define a ListValidationRule for the corresponding Worksheet’s cells in the Workbook that you assign to the spreadsheet and set its ShowDropdown property to true. The ListValidationRule object has a SetValues method that allows you to assign the values that appear in the drop-down, and then you can actually add the rule to the Worksheet by adding it to the DataValidationRules collection.

    I am attaching a sample project that demonstrates the above. I hope this helps you.

    Please let me know if you have any other questions or concerns on this matter.

    SpreadsheetDropDownList.zip

Reply Children