asked on April 3, 2017
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
⋅ 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.
⋅ April 3, 2017
Thanks Dmytro !
⋅ 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
⋅ November 15, 2018
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)
⋅ November 15, 2018
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 ?
⋅ November 16, 2018
Hi Anchal!
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?
Thanks,
Tanya
⋅ November 16, 2018
Thank you Tanya. My issue got resolved with this. 🙂
