Using IF and empty quotes to check for blank value

4 posts, 0 answers
  1. Steven
    Steven avatar
    5 posts
    Member since:
    Mar 2012

    Posted 30 Jan Link to this post

    One of our clients has spreadsheets using IF(A10="",'N/A', 1) but this does not work it will display the 1 with an empty cell. However if IF(ISBLANK(A10),'N/A',1) is used it works properly. Is there a reason for this behavior or maybe a fix without having to change a ton of formulas across several hundred files?
  2. Nencho
    Admin
    Nencho avatar
    1876 posts

    Posted 03 Feb Link to this post

    Hello, Steven,

    I'm afraid that the described issue is a bug, and you can find it logged in our issue tracking repo below:

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

    I'm afraid that there's no applicable workaround for the time being. Even if there was, it should have been manually applied in the spreadsheet instances, which is duplicating the effort of altering the IF usage with the ISBLANK. 

    Having in mind the heavy data scenario that you have at your end, and the critical severity of this bug at your end, we will try to escalate its priority and evaluate whether we can come up fast with a fix.

    In addition, I have updated your Telerik points for pointing that issue out.

    Please accept our apologies for the inconveniences caused by this bug. 

    Regards,
    Nencho
    Progress Telerik

    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
  3. Nencho
    Admin
    Nencho avatar
    1876 posts

    Posted 11 Feb Link to this post

    Hello, Steven,

    I'm happy to inform you that the bug you reported is now fixed and you can get an advantage of the fix, by downloading the upcoming internal build, where the fix will be present. We release internal builds each Wednesday. 

    Hope this information helps.

    Regards,
    Nencho
    Progress Telerik

    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
  4. Steven
    Steven avatar
    5 posts
    Member since:
    Mar 2012

    Posted 11 Feb Link to this post

    That is great news, thank you!
Back to Top