Spreadsheet -- Adding Custom Validation to a Range of Cells with JQuery After Initilization

[Daniel]

I have a spreadsheet that gets data loaded from a database. I want to add validation to a range of cells, but I never know how many columns or rows until after the data is loaded. So my question is: How do I do this with jquery? The validation is fairly simple. Each character can be a number or a colon : 

 

Thank you in advance

[Daniel]

I have partially answered my question. I have figured out how to add validation after the spreadsheet is created but I'm not sure how to specify the pattern I want. Basically I want the input to be in a time format HH:MM. I would have thought Kendo would use Regular Expression ) but when I tried that I got a formatting error. Does anyone know how I specify the afore mentioned pattern? By the way, this is the Regular Expression for HH:MM  ^([0-1]?[0-9]|2[0-3]):[0-5][0-9]$

 range.validation({
          dataType: "custom",
          from: "AND(ISNUMBER(D3),LEN(D3)<14)",
          allowNulls: true,
          type: "reject",
          titleTemplate: "Invalid Time Format",
          messageTemplate: "Time should be of HH:MM format."
      });
}

[Martin]

Hello, Daniel,

Here you will find a forum thread that discusses a similar topic, I hope it will be helpful to resolve the problem.

Let me know if you have any questions.

Regards,
Martin
Progress Telerik