Progress® Kendo UI® for jQuery Feedback Portal
Back to Feed
Request a Feature Report a Bug
Unplanned
Last Updated: 05 Apr 2019 13:48 by ADMIN
Naveen
Created on: 04 Apr 2019 10:17
Category: Spreadsheet
Type: Feature Request
7
Excel TEXT function blank value issue

Dear Concerned,

1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index

2. Upload the attached sample.xlsx file.

3. Cell B1 getting value from cell A1 using formula "=TEXT(A1, "$#,###")"

4. Delete(Blank) the value of cell A1, see error #VALUE! in cell B1.

5. The same is working fine in Excel.

6. Please suggest any workaround or quick fix.

 

 

Check attached Sample.xlsx file in Sample.zip folder

Attached Files:
1 comment
ADMIN
Petar
Posted on: 05 Apr 2019 13:48
Hello Naveen,

This is an expected behavior. The implementation of TEXT formula returns a #VALUE error if the referenced cell doesn't have content in it.  

If you want to have the same behavior as the one in Excel, you can use this formula:

=IF(ISBLANK(A1), "$", TEXT(A1, "$#,###"))

Here is an example with your formula on row 1 and the above formula on row 2. 

I've converted your ticket to a feature request in our Feedback portal. You can vote for it on this link: https://feedback.telerik.com/kendo-jquery-ui/1403673 and if there is a community interest on changing TEXT function's behavior we may change its implementation in future releases.  


Regards,
Petar
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.
Create an account Log In
View
Type
Status
Category