Hi,
I seem to have unearthed a bug in the Kendo spreadsheet control. When the spreadsheet has only 1 row and there is column validation somewhere on the sheet, if I then edit a cell (without validation), 8 rows are created.
See the following Dojo
Kendo UI Snippet | Kendo UI Dojo (telerik.com)
Steps to reproduce.
1. Run the Dojo
2. Edit the UnitPrice cell to, say 20
3. Save changes
4. Observe in the browser console (F12) 8 rows created.
Expected results are 0 rows created and 1 updated
Thanks
Ian
Not so recently HTML 5 has added minLength and maxLength attributes (including form based validation) to their spec for input fields of the above mentioned types. Kendo UI Validator does not seem to use them during validation. It is, of course, possible to add a custom validation rule, however, it would be much preferred to use the built-in mechanism in modern browsers to do so.
Standard reference
HTML 5 standard maxLength and minLength
Demonstration code which does not fire a validation error:
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8"/>
<title>Kendo UI Snippet</title>
<link rel="stylesheet" href="https://kendo.cdn.telerik.com/2021.3.914/styles/kendo.default-v2.min.css"/>
<script src="https://code.jquery.com/jquery-1.12.4.min.js"></script>
<script src="https://kendo.cdn.telerik.com/2021.3.914/js/kendo.all.min.js"></script>
</head>
<body>
<form class="myValidator">
<p><input type="text" name="age" minlength="3"></p>
<button id="validate" class="k-button k-primary" type="button">Validate</button>
</form>
<script>
$('#validate').click(function(){
var validator = $(".myValidator").kendoValidator({
messages:{
minlength:"Number must be greater than 3"
}
}).data("kendoValidator");
validator.validate();
})
</script>
</body>
</html>
If we make an input readonly it doesn't get validated and wee need it to be validated on a readonly datepicker.
In kend.all.min.js we have
v=":input:not(:button,[type=submit],[type=reset],[disabled])"
and if i modify it by adding readonly like below
v=":input:not(:button,[type=submit],[type=reset],[disabled],[readonly])"
We need to make that code configurable because the workarounds concerining this problem it's buggy.
Allow customization of the Validation Tooltip position.
For example, positioning the Tooltip based on the cell, on the input.