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?