Spreadsheet Validation

[Marc]

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!

[Nencho]

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

[Marc]

Hi Nencho,

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

I am using Google Chrome.

[Marc]

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

[Nencho]

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

[Marc]

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

[Nencho]

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