This is a migrated thread and some comments may be shown as answers.
Using IF and empty quotes to check for blank value
3 Answers 7 Views
This is a migrated thread and some comments may be shown as answers.
Steven
Top achievements
Rank 1
Steven asked on 30 Jan 2020, 04:24 PM
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?

3 Answers, 1 is accepted

Sort by
0
Nencho
Telerik team
answered on 03 Feb 2020, 12:55 PM

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.
0
Nencho
Telerik team
answered on 11 Feb 2020, 11:05 AM

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.
0
Steven
Top achievements
Rank 1
answered on 11 Feb 2020, 08:22 PM
That is great news, thank you!
Asked by
Steven
Top achievements
Rank 1
Answers by
Nencho
Telerik team
Steven
Top achievements
Rank 1
Share this question
or