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 !