Spreadsheet with Remote Datasource, Apply Validation/Formulas to Entire Column Except First Row

[Nish]

I'm trying to add validation/formulas to an entire column except the first row. I found this thread to select an entire column:

https://www.telerik.com/forums/column-validation-20a85bc435da

 

The problem with the above method is that my spreadsheet is bound to a remote data source, so the first row is column headers. Is there a way to apply formulas and validation to all of the other rows except the first? Defining these cell-by-cell causes a big delay when the data is loaded.

[Neli]

Hello Nish,

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.

new Vue({
  el: "#vueapp",
  mounted() {
    var spreadsheet = this.$refs.spreadsheet.kendoWidget();
    var sheet = spreadsheet.activeSheet();    
    sheet.range("C2:D20").validation({      
      to: "10",
      from: "5",
      allowNulls: false,
      comparerType: "between",
      dataType: "number",
      type: "reject",
      messageTemplate: "Number should match the validation"
    })
  },

A similar example for setting validation rules to column ranges is linked below:

- https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/how-to/validation-to-column

I hope you will find the provided information helpful. In case you have follow up questions please let me know.

Regards,
Neli
Progress Telerik