CoolUtils Logo
Welcome! Log In Create A New Profile

Advanced

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

Thank you in advance.

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
@ 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
Dear Didier Naud,

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

Best regards,

Mary Thorton
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: