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
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.
Thanks Dmytro !
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.