Validation is achieved
Kendo Grid validation is achieved like this, similarly how should achieve this in kendo spread sheet
schema: {
model: {
fields: {
ProductName: { type: "string" },
UnitPrice: { type: "number", validation : {
required: true,
unitvalidation: function (input) {
var value = 0;
var value_found = false;
if (typeof input[0] !== 'undefined') {
if (input.val() !== "") {
value_found = true;
value = input.val();
}
if (value_found === true) {
if (value < 0 || value > 3) {
alert('please enter value between 0 and 3');
}
}
}
return true;
}
}
}
}
}
},
Kendo Grid validation is achieved like this, similarly how should achieve this in kendo spread sheet
schema: {
model: {
fields: {
ProductName: { type: "string" },
UnitPrice: { type: "number", validation : {
required: true,
unitvalidation: function (input) {
var value = 0;
var value_found = false;
if (typeof input[0] !== 'undefined') {
if (input.val() !== "") {
value_found = true;
value = input.val();
}
if (value_found === true) {
if (value < 0 || value > 3) {
alert('please enter value between 0 and 3');
}
}
}
return true;
}
}
}
}
}
},
3 Answers, 1 is accepted
0
Accepted
Hello Michael,
To enable validation in the spreadsheet, use the range.validation method, or set the validation via the sheet options, as shown in the validation example.
Regards,Alex Gyoshev
Telerik
Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
0
Michael
Top achievements
Rank 1
Rank 1
answered on 26 Jun 2016, 07:19 AM
How to set comparerType for condition greater than equal to 0 and less than or equal to 1?
0
Hello Michael,
In this case you can use the "between" comparerType. Please refer to the http://dojo.telerik.com/AjoZI example.
Regards,Boyan Dimitrov
Telerik
Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.