With the method described in the thread, the validation will be applied to the specified range. In case you need to set validation to all cells except the first row, using the validation method of the Range object will be the recommended approach. You could set a range that contains all cells except those for the header and configure the needed validation rules. Below is an example in Vue.
var spreadsheet = this.$refs.spreadsheet.kendoWidget();
var sheet = spreadsheet.activeSheet();
messageTemplate: "Number should match the validation"
A similar example for setting validation rules to column ranges is linked below:
I hope you will find the provided information helpful. In case you have follow up questions please let me know.
Progress is here for your business, like always. Read more
about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.