Progress® Kendo UI® for jQuery Feedback Portal
Back to Feed
Request a Feature Report a Bug
Unplanned
Last Updated: 14 Feb 2022 07:57 by ADMIN
Aaron
Created on: 07 Feb 2022 20:55
Category: Spreadsheet
Type: Feature Request
1
Support for Regex Validation

Hi there,

I'd love the ability to specify regex validation for the spreadsheet component. I saw a forum post (https://www.telerik.com/forums/spreadsheet-regex-validation) someone else had made relating to this, but couldn't find a feature request made based off of it.

(taken from the post) Ideally it'd look something like this:


var columnSens = spreadsheet.activeSheet().range("A2:A10");

columnSens.validation({
  dataType: "custom",
  from: 'REGEX("^(()|((?=.*[a-z])(?=.*[A-Z])(?=.*\d)(?=.*[^\da-zA-Z]).{8,60}))$")',
  type: "warning",
  allowNulls: true,
  titleTemplate: "Invalid Password",
  messageTemplate: "Passwords must be between 8 - 60 characters long and contain the following: 1 number, 1 uppercase letter, 1 lowercase letter, and 1 special (non letter or number) character."
});

1 comment
ADMIN
Neli
Posted on: 14 Feb 2022 07:57

Hello Aaron,

Thank you for submitting this feature request. We will monitor the community's interest in such a feature and consider it for future implementation.

Until such a feature is implemented the approach suggested in the How-To article linked in the forum thread you have posted can be used. For convenience a link to the article can be found below as well:

- https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/how-to/regexp-validation

Regards,
Neli
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Create an account Log In
View
Type
Status
Category