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.
Hi Tanya and Dmytro,
Similar issue I am facing when Calculated Result value is infinity and I am using version 2.6.5.
But when Flex is in Flat View format. Only that time I have Failed to Export error. For compact view I don’t have it.
Please find below error message from console:
allappjs.min.js:6298 Export XLS error: TypeError: Cannot read property ‘be’ of undefined
at Function.p55.X4 (flexmonster.js:9)
at Function.p55.f9 (flexmonster.js:9)
at Function.p55.Ed (flexmonster.js:9)
at i74.wg (flexmonster.js:9)
at x01.hda (flexmonster.js:9)
at b12.<anonymous> (flexmonster.js:9)
at b12.V8.dispatch (flexmonster.js:9)
at Function.S35.wg (flexmonster.js:9)
at b12.wg (flexmonster.js:9)
With version 2.6.7 this issue is not there for Export to Excel in Flat View. But value is as “infinity”.
Can we have change for it or can we make it 0 instead of infinity ?
I recommend you to re-define divideByZeroValue or/and infinityValue in formats block. Please see this demo: http://jsfiddle.net/flexmonster/pcvfmtqo/3/
Does it help?
Thank you Tanya. My issue got resolved with this. 🙂