# Pb with Excel conversion of calculated (not such) big numbers

Posted by Didier Naud
 Pb with Excel conversion of calculated (not such) big numbers June 24, 2011 02:18AM Registered: 4 years ago Posts: 3
Dear support team,

We made some tests with TotalExcelConverter and TotalExcelConverterX and found this issue. I've browsed the forum without finding anything related to it.
Here it is :
Calculated numbers into Excel cells are not correctly interpreted by the conversion into jpg image. It depends of how high is the result of the calculation. The calculations are really simple.
Examples :
=54210*5 should make 271050, ExcelConverter renders -56630
=40000*5 should make 200000, ExcelConverter renders -127680
=30000*4 should make 120000, ExcelConverter renders correct 120000
=25000*4 should make 100000, ExcelConverter renders correct 100000
If I enter 271050 directly into the cell, it appears correctly on the jpg image.
I didn't test with other output formats.

Hoping there is urgent action you can make...

Regards,

Didier Naud.
 Re: Pb with Excel conversion of calculated (not such) big numbers June 24, 2011 02:38AM Registered: 4 years ago Posts: 3
Let me add some elements of further investigations :

The limit seems to be 2^15 = 32768

If one of the elements of the calculation is superior or equal to this number, the calculation fails :
=32767*2 renders 65534
=32768*2 renders -65536
=32769*2 renders -65534

No doubt there is to do with integer/number format...

Plus : the preview displayed in TotalExcelConverter is correct !

Rgds,

Didier.
 Re: Pb with Excel conversion of calculated (not such) big numbers June 24, 2011 04:40AM Admin Registered: 4 years ago Posts: 386
Dear Didier Naud,

Could you, please, send us your input files which you are trying to convert? Our e-mail is support@coolutils.com. We wil investigate this issue.

Best regards,

Mary Thorton
CoolUtils Support
www.coolutils.com
support@CoolUtils.com
 Re: Pb with Excel conversion of calculated (not such) big numbers June 30, 2011 11:24PM Registered: 4 years ago Posts: 3
@ all who read this topic :

I'd like to say here that this issue has been solved by the support team.

We've been rapidly assisted by a professional and efficient team.

@ support team :

Thanks again for the good work, we now have implemented a powerful tool to our web application.

Best regards,

Didier Naud.
 Re: Pb with Excel conversion of calculated (not such) big numbers July 01, 2011 12:55AM Admin Registered: 4 years ago Posts: 386
Dear Didier Naud,

Thank you for your appreciation. We are always ready to help :-)

Best regards,

Mary Thorton
Author: