Sadly, Google neglected to add this functionality. This is a major showstopper on my project. I have users absolutely wrecking my spreadsheet with stray copy and pastes, and I need to be able to restore data validiations programattically on dozens of different spreadsheets that have been rolled out. "Fix it by hand" is a serious loss here.