Menu
Download Free Trial

While exporting to excel for calculated columns with a value of infinity

I have added one calculated field, for which lets say value is coming as Infinity (because of divide by zero), but when I export it to Excel, value shown in excel is 0.00112233440055668, I think it should be other than this value. It can show “#DIV/0!” error.
Please refer http://jsfiddle.net/fav2epqj/3/
Note: Export to CSV correctly shows infinity 

3 answers

Public
Dmytro Zvazhii Flexmonster April 3, 2017

Hello Sohan,
Thank you for your question. We have reproduced the issue on our side and will be ready with the fix in the version 2.314 ETA Apr24.
Best regards,
Dmytro.

Public
Sohan April 3, 2017

Thanks Dmytro !

Public
Tanya Gryshko Flexmonster April 26, 2017

Hello Sohan,
I am glad to inform you that the minor release 2.314 is available for download now. The issue with exporting infinity value to Excel was fixed. You are welcome to update the component.
Regards,
Tanya

Please login or Register to Submit Answer