Get Free Trial

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

Sohan 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
Note: Export to CSV correctly shows infinity 

7 answers

Dmytro Zvazhii 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,

Sohan April 3, 2017

Thanks Dmytro !

Tanya Gryshko 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.

Anchal 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)

Anchal 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 ?

Tanya Gryshko Tanya Gryshko Flexmonster November 16, 2018

Hi Anchal!
I recommend you to re-define divideByZeroValue or/and infinityValue in formats block. Please see this demo:
Does it help?

Anchal November 16, 2018

Thank you Tanya. My issue got resolved with this. 🙂

Please login or Register to Submit Answer