Getting Error after invoking Calculate method on workbook

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

  • 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:?]

  • Replied 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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels