This is a migrated thread and some comments may be shown as answers.

Spreadsheet Validation

6 Answers 49 Views
This is a migrated thread and some comments may be shown as answers.
Marc
Top achievements
Rank 1
Marc asked on 13 Mar 2017, 09:44 PM

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!

6 Answers, 1 is accepted

Sort by
0
Nencho
Telerik team
answered on 15 Mar 2017, 02:47 PM
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.
0
Marc
Top achievements
Rank 1
answered on 15 Mar 2017, 03:11 PM

Hi Nencho,

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

I am using Google Chrome.

0
Marc
Top achievements
Rank 1
answered on 17 Mar 2017, 08:12 AM

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

0
Nencho
Telerik team
answered on 17 Mar 2017, 11:44 AM
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.
0
Marc
Top achievements
Rank 1
answered on 17 Mar 2017, 11:50 AM

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

0
Nencho
Telerik team
answered on 21 Mar 2017, 08:48 AM
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.
Asked by
Marc
Top achievements
Rank 1
Answers by
Nencho
Telerik team
Marc
Top achievements
Rank 1
Share this question
or