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

Cell Data validation Rule corrupts itself on failed validation

1 Answer 62 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Alessandro
Top achievements
Rank 1
Alessandro asked on 09 Aug 2016, 09:12 AM

Hello Everyone,
You can use the Spreadsheet Demo on the Telerik Web site.
Select one of the numeric values in the quantity column and choose Data Validation -> List.
Write H1:H3 on the Value for validation and fill the range with values.

Now make sure you enter a number that fails validation. You receive correctly the error dialog.
Close it and Check the Data Validation Rule for that cell.
It has changed to: _matrix(H1:H3)
Now perform more failed validations (closing the dialogs).
Check again Data Validation Rule for that cell.
It has changed to more nested "_matrix" such as "_matrix(_matrix(H1:H3))"

This process of corruption continues with side effects such as: dialog opened as many times as the number of _matrix in the Data Validation Value.
Tested on IE Edge, IE 11 and Firefox 47.0.1 with same results.

Best Regards

1 Answer, 1 is accepted

Sort by
0
Veselin Tsvetanov
Telerik team
answered on 11 Aug 2016, 08:28 AM
Hi Alessandro,

The observed is not the expected behavior of the Spreadsheet and could be considered a bug. I have logged an issue on that in our public repo, so you will be able to track its status.

As a token of gratitude for the reported bug, I have updated your Telerik points.

Regards,
Veselin Tsvetanov
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Spreadsheet
Asked by
Alessandro
Top achievements
Rank 1
Answers by
Veselin Tsvetanov
Telerik team
Share this question
or