Bug: Custom validation AND ordering

2 posts, 0 answers
  1. Jeffrey
    Jeffrey avatar
    6 posts
    Member since:
    Sep 2016

    Posted 18 Oct Link to this post

    Hi Kendo Team,

    While working with the spreadsheet's custom validation feature, my team stumbled on what seems to be a bug with the AND function when checking cell values.  When checking the LEN() of a cell's value before an ISNUMBER() check, the validation will sometimes completely ignore the ISNUMBER.  This bug does not seem to happen in every situation but when it does it can be nearly impossible to pinpoint in one's own code without accidentally fixing it by changing the order of logic.  I've managed to consistently replicate what I'm experiencing in the dojo link below:

         http://dojo.telerik.com/EMAKI

    The dojo link contains your spreadsheet validation demo -- the only thing that has changed from the original demo is the validation in cells D3 and D4.  Both are observing cells F3 and G3, checking that F3 is a number and that G3 is empty.  The only thing different about the validation in cells D3 and D4 is the order in which we check the other two cells within the AND function.  However, you can note inconsistent behavior here the moment you run it.  You will see that while both D3/D4 cells become flagged if G3 is not empty, D3 does not seem to check whether or not F3 is a number.  Putting a non-numeric string into F3 or leaving it empty will cause D4 to display the warning but not D3.

     

    So -- bug or am I overlooking something obviously wrong?

    Thanks,

    Jeff

  2. Stefan
    Admin
    Stefan avatar
    268 posts

    Posted 20 Oct Link to this post

    Hello Jeffrey,

    Thank you for reporting this.

    I can confirm that this is an issue with the current version of Kendo UI Spreadsheet.

    I created an issue in our GitHub repository and forwarded it to our developers for fixing. You can track its progress at:

    https://github.com/telerik/kendo-ui-core/issues/2347

    Additionally, I updated your Telerik points from bringing this to our attention.

    Regards,
    Stefan
    Telerik by Progress
     
    Build rich, delightful, *native* Angular 2 apps with Kendo UI for Angular 2. Try it out today! Kendo UI for Angular 2 (currently in beta) is a jQuery-free toolset, written in TypeScript, designed from the ground up to offer true, native Angular 2 components.
     
  3. Kendo UI is VS 2017 Ready
Back to Top