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

Bug: Custom validation AND ordering

1 Answer 13 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Jeffrey
Top achievements
Rank 1
Jeffrey asked on 19 Oct 2016, 01:04 AM

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

1 Answer, 1 is accepted

Sort by
0
Stefan
Telerik team
answered on 20 Oct 2016, 01:44 PM
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.
 
Tags
Spreadsheet
Asked by
Jeffrey
Top achievements
Rank 1
Answers by
Stefan
Telerik team
Share this question
or