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

Spreadsheet Validation

6 Answers 147 Views

Spreadsheet

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

6 Answers, 1 is accepted

answered on 15 Mar 2017, 03:11 PM

1.png

2.png

Hi Nencho,

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

I am using Google Chrome.

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.

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.