Cell Data validation Rule corrupts itself on failed validation

2 posts, 0 answers
  1. Alessandro
    Alessandro avatar
    5 posts
    Member since:
    Sep 2014

    Posted 09 Aug 2016 Link to this post

    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

  2. Veselin Tsvetanov
    Veselin Tsvetanov avatar
    593 posts

    Posted 11 Aug 2016 Link to this post

    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.

    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
Back to Top