NumberFormatException on IF formula

NumberFormatException on IF formula

Posted by: ismael.zamora on 26 October 2020, 2:07 am EST

• 

  ismael.zamora

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 26 October 2020, 2:07 am EST

  Hello,

  I’m using the Document for Excel (Java) to fill a document generated in the client side with SpreadJS.
  
  Basically, the document creates two sheets, one where all the data will be putted, and another where the user can put some formulas to calculate the results based on the data in the first sheet.

  In the second sheet, there are two results, one that calculates a summe (=SUM(Data!B5,Data!B6)), and another that, based on this summe, gives a feedback about this value (=IF(B2<50000000,“good”,“bad”)), where B2 is the result of the first forumla.

  In the process where the Documents for excel put the needed values on the first sheet (“Data” sheet), and tries to save the excel to the Database, it throws a java.lang.NumberFormatException: For input string: “1,2868407174014E7”. This number is the one calculated in the B2 cell, and it raises this exception when trying to compare in the IF.

  the complete stacktrace is:

  For input string: "1,2868407174014E7"
  java.lang.NumberFormatException: For input string: "1,2868407174014E7"
  	at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2043)
  	at sun.misc.FloatingDecimal.parseDouble(FloatingDecimal.java:110)
  	at java.lang.Double.parseDouble(Double.java:538)
  	at java.lang.Double.valueOf(Double.java:502)
  	at com.grapecity.documents.excel.f.aR.b(Unknown Source)
  	at com.grapecity.documents.excel.f.S.a(Unknown Source)
  	at com.grapecity.documents.excel.f.S.a(Unknown Source)
  	at com.grapecity.documents.excel.k.i.n.e(Unknown Source)
  	at com.grapecity.documents.excel.j.k.e(Unknown Source)
  	at com.grapecity.documents.excel.f.a.h(Unknown Source)
  	at com.grapecity.documents.excel.k.f.d.a(Unknown Source)
  	at com.grapecity.documents.excel.j.k.a(Unknown Source)
  	at com.grapecity.documents.excel.j.f.b(Unknown Source)
  	at com.grapecity.documents.excel.j.h.a(Unknown Source)
  	at com.grapecity.documents.excel.g.f.u(Unknown Source)
  	at com.grapecity.documents.excel.B.ao.e(Unknown Source)
  	at com.grapecity.documents.excel.B.ao.b(Unknown Source)
  	at com.grapecity.documents.excel.l.b.P.a(Unknown Source)
  	at com.grapecity.documents.excel.l.b.P.a(Unknown Source)
  	at com.grapecity.documents.excel.l.b.P.a(Unknown Source)
  	at com.grapecity.documents.excel.l.b.O.a(Unknown Source)
  	at com.grapecity.documents.excel.l.b.O.a(Unknown Source)
  	at com.grapecity.documents.excel.Workbook.toJson(Unknown Source)
  

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 27 October 2020, 12:38 am EST

  Hello,

  Can you please share a working application so that we can investigate this issue further. It’s difficult to debug the issue without looking at the code.

  Hence, please provide us with your working sample and also let us know the version of GcExcel JAVA you are using. We will look into this issue thereon.

  Thanks,
  
  Reeva

• 

  ismael.zamora

  • Post Options:
  • Link
    Copy

  Posted 27 October 2020, 8:49 pm EST

  I’m using the 3.2.3 version of the Documents for Excel, Java.

  I attach a test code, with the excel that I create using the SpreadJS framework, and the exception that occurs.

  xchange.zip

  Thank you.

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 29 October 2020, 12:41 am EST

  Hello,

  We used the code from your sample application and we are not getting any exception at our end using GcExcel version 3.2.3 and we are getting this output in console (text file attached).

  Also we didn’t get any excel file that was created using SpreadJS as you said at your end.

  Request you to please let us know what are we missing to replicate the issue at our end and also specify exact steps to follow.

  I am attaching the sample for your reference.

  Thanks,
  
  Reeva
  
  NumberFormaException_Forum.zip
  
  Console-Output.zip

• 

  ismael.zamora

  • Post Options:
  • Link
    Copy

  Posted 29 October 2020, 3:07 am EST

  Hello,

  I just did a quick test, and I found the issue. It happens that if I have setted the Local language to something different of English (Spanish, in my case) the exception occurs. The problem has been solved by adding this line:

  java.util.Locale.setDefault(java.util.Locale.ENGLISH);
  

  in the beginning of the programm.

  Thank you

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 29 October 2020, 7:34 pm EST

  Hello,

  We are glad to know that your issue has been resolved.

  Thanks,
  
  Reeva