Manually Fire Validation Fail Event

2 posts, 0 answers
  1. Marc
    Marc avatar
    171 posts
    Member since:
    Sep 2016

    Posted 07 Mar 2018 Link to this post

    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!

  2. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    1201 posts

    Posted 09 Mar 2018 Link to this post

    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
    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.
Back to Top