Hope to increase support for data validity

[netty2019]

Drop-down boxes like this are used a lot. I hope you can increase your support. Thank you very much.

[netty2019]

I can't upload pictures. I can only put this link. https://www.ablebits.com/office-addins-blog/2017/08/16/data-validation-excel/

[jingwood]

It's easy to implement your own validation form using custom drop-down. You can put any standard .NET control inside the drop-down panel. https://reogrid.net/walkthroughs/how-to-create-custom-drop-down-cell/

And you can do customized validation after cell data is changed by using the worksheet.CellDataChanged event.

[netty2019]

Thank you for your answer. I also thought of this method. But sometimes it is to let users make excel templates themselves,no need to write code，so it is best to support the data validity of excel.