[Solved] Sheet validation, not sure how to set this up properly

[sitefinitysteve]

So I need my spreadsheet to have a header row, and every row below be where the data is entered... so I've got that setup fine I think.

Now I need to define validation rules on ranges, so like K2:K40 can only have 1-5... I was able to do this in the widgetCreated event

sheet.range("K2:K40").validation({
                type: "warning",
                from: "1",
                to: "5",
                allowNulls: true,
                comparerType: "between",
                dataType: "number",
                messageTemplate: "PGYs are 1-5"
            });

 

My current struggle though is being able to find out the total validation errors in the sheet... the code provided here

https://www.telerik.com/forums/retrieve-validation-errors-programatically

and here

https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/how-to/get-flagged-cells

Always fails, the "cell.validation" in range.forEachCell is always undefined... what am I doing wrong here?

 

[sitefinitysteve]

Scratch that, found the problem, this is setup correct, it's just $scope isn't available in the change event...eugh

[Joana]

Hi Steve,

I am glad that you managed to pin down the cause of the issue.

In the change event of the SpreadSheet widget you could take reference of the scope as follows:

change: function (e) {
  console.log(this.$angular_scope);
}

http://dojo.telerik.com/@jivanova/oqaHagAW

Regards,
Joana
Progress Telerik