We have a cell with validation (it is a dropdown type validation).
When the users copy the value from another cell to this cell, I used the clipboard.paste.prototype method to override the default behaivour and retain the pasteRef cells formatting (background, font colour, validation values etc), but after the paste, the cell may (or may not) be invalid.
Is there a way to then manually check the validation and if it fails, fire the validation fail event (which shows a popup)?
Thanks!
1 Answer, 1 is accepted
0
Hello Marc,
I am afraid, the the validation of a Spreadsheet cell could not be triggered programmatically. Validation will only be triggered upon a user interaction.
That is why, I would suggest you to share your use case in the following GitHub issue, so we will be able to take it into account when considering the paste only values implementation.
Regards,
Veselin Tsvetanov
Progress Telerik
I am afraid, the the validation of a Spreadsheet cell could not be triggered programmatically. Validation will only be triggered upon a user interaction.
That is why, I would suggest you to share your use case in the following GitHub issue, so we will be able to take it into account when considering the paste only values implementation.
Regards,
Veselin Tsvetanov
Progress Telerik
Try our brand new, jQuery-free Angular components built from ground-up which
deliver the business app essential building blocks - a grid component,
data visualization (charts) and form elements.