Getting Error after invoking Calculate method on workbook

Getting Error after invoking Calculate method on workbook

Posted by: harshaghanta on 14 May 2020, 5:25 pm EST

• 

  harshaghanta

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 May 2020, 5:25 pm EST

  Please find the below error we are getting after invoking the Calculate method on the workbook. Btw we are calling the below 2 lines to trigger calculation.

  workbook.setEnableCalculation(true);
  
  workbook.calculate();

  Error:

  java.lang.NullPointerException: null
  
  at com.grapecity.documents.excel.g.v.a(Unknown Source) ~[gcexcel-2.2.0.jar:?]
  
  at com.grapecity.documents.excel.k.h.aq.c(Unknown Source) ~[gcexcel-2.2.0.jar:?]
  
  at com.grapecity.documents.excel.j.k.c(Unknown Source) ~[gcexcel-2.2.0.jar:?]
  
  at com.grapecity.documents.excel.j.f.h(Unknown Source) ~[gcexcel-2.2.0.jar:?]
  
  at com.grapecity.documents.excel.j.f.a(Unknown Source) ~[gcexcel-2.2.0.jar:?]
  
  at com.grapecity.documents.excel.j.i.a(Unknown Source) ~[gcexcel-2.2.0.jar:?]
  
  at com.grapecity.documents.excel.j.h.d(Unknown Source) ~[gcexcel-2.2.0.jar:?]
  
  at com.grapecity.documents.excel.y.al.g(Unknown Source) ~[gcexcel-2.2.0.jar:?]
  
  at com.grapecity.documents.excel.Workbook.calculate(Unknown Source) ~[gcexcel-2.2.0.jar:?]

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 17 May 2020, 5:22 pm EST

  Hello,

  Unfortunately, we are unable to replicate the issue at our end with the given information using GcExcel JAVA version 2.2.0

  We created a sample application using your code but we are unable to replicate the issue.

  We request you to send across your sample or modify our attached sample to replicate the issue and send it back so that we can investigate the issue further.

  Please have a look at attached sample for more clarity.

  WorkbookCalculate.zip

  Thanks,
  
  Reeva