Overwriting Data Validation By Copy/Paste

[flipperyfish]

Hi,

I have added data validation using a string array of values, which works fine, however, it is possible copy / paste any value into the cell with the data validation. Is there a way to prevent people from doing this?

Many thanks,

Andy

[Gary.zhang]

Hello,

Thanks for your inquiry.
Sorry that at present there is no any ways to prevent people from doing this in our product.
Sincerely,
Gary
E-iceblue support team