Spreadsheet Validation

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

    Posted 13 Mar 2017 Link to this post

    I have validation list on some of my cells as demonstrated here:

    http://dojo.telerik.com/@marclazell/UcAVu

    Is there a way to stop the users removing the value completely? They can delete it manually and no warning message appears.

    Thanks!

  2. Nencho
    Admin
    Nencho avatar
    1871 posts

    Posted 15 Mar 2017 Link to this post

    Hello Marc,

    I am afraid that I was unable to remove the "4" value, using the provided dojo example (tested with Del and Backspace buttons). Could you please provide us with exact steps so we could locally reproduce this issue.

    I am looking forward to your reply.

    Regards,
    Nencho
    Telerik by Progress
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  3. Marc
    Marc avatar
    171 posts
    Member since:
    Sep 2016

    Posted 15 Mar 2017 in reply to Nencho Link to this post

    Hi Nencho,

    I just pressed the delete button. Attached are two screenshots before and after.

    I am using Google Chrome.

  4. Marc
    Marc avatar
    171 posts
    Member since:
    Sep 2016

    Posted 17 Mar 2017 in reply to Nencho Link to this post

    Hi Nencho,

    This is a more accurate representation of my problem.

    http://dojo.telerik.com/@marclazell/UcAVu

    I can easily delete items by clicking on the cell and pressing the delete button. My list is comprised of numbers & strings. Not sure if that is a problem. 

    Thanks

    Marc

  5. Nencho
    Admin
    Nencho avatar
    1871 posts

    Posted 17 Mar 2017 Link to this post

    Hello Marc,

    Thank you for the modified dojo. Indeed this deletion is possible because there are cases, where we cannot block the modification of the cell and this is one of them. However, the cell is still marked as invalid with the red mark. You can verify this behavior with the Microsoft Excel as well. Another example of such inability to block the attempt of modification of the cell value is if you drag some other cell value, over the one with validation (and the value is not valid). You can replicate the same behavior with the Microsoft Excel as well.

    Regards,
    Nencho
    Telerik by Progress
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  6. Marc
    Marc avatar
    171 posts
    Member since:
    Sep 2016

    Posted 17 Mar 2017 in reply to Nencho Link to this post

    Hi,

    Can you please explain the cases "where we cannot block the modification of the cell"? Is it because my list is made of mixed data types? If this is the case please provide me the class name for the spreadsheet cell, and I will bind a keydown method using jquery and block the delete key here.

    Thanks,

    Marc

  7. Nencho
    Admin
    Nencho avatar
    1871 posts

    Posted 21 Mar 2017 Link to this post

    Hello Marc,

    I am afraid that this is not directly related with your list validation type. As for the cases - as I had previously described another one is if you drag some other cell value, over the one with validation (and the value is not valid) ; http://dojo.telerik.com/OLoPE/3
     
    Such cases are identical with the behavior of the Microsoft Excel, which we aim to support a parity with. Please see the video below:

    https://www.screencast.com/t/rmehi17J


    Regards,
    Nencho
    Telerik by Progress
    Try our brand new, jQuery-free Angular 2 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