1. leonate NA
  2. jxls
  3. Issues


Issue #11 resolved

Problem with complex formulas

Stephane Blondel
created an issue

When I run my export function I got an ArrayIndexOutOfBoundsException due to the formulas in column K and L.

Comments (5)

  1. Stephane Blondel reporter

    It don't change anything, Still have the error. :s

    Caused by: java.lang.ArrayIndexOutOfBoundsException: -1357634646
        at java.util.ArrayList.elementData(ArrayList.java:400)
        at java.util.ArrayList.get(ArrayList.java:413)
        at org.jxls.common.RowData.getCellData(RowData.java:31)
        at org.jxls.transform.AbstractTransformer.getCellData(AbstractTransformer.java:61)
        at org.jxls.transform.AbstractTransformer.getTargetCellRef(AbstractTransformer.java:31)
        at org.jxls.area.XlsArea.processFormulas(XlsArea.java:271)
        at controllers.PivotTable.exportExcel(PivotTable.java:158)
        at play.mvc.ActionInvoker.invokeWithContinuation(ActionInvoker.java:548)
        at play.mvc.ActionInvoker.invoke(ActionInvoker.java:502)
        at play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:478)
        at play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:473)
        at play.mvc.ActionInvoker.invoke(ActionInvoker.java:161)
        ... 1 more
  2. leonate NA repo owner

    Your template works fine for me with the latest Jxls version (it was failing before). I put it as an issue example in jxls-demo project https://bitbucket.org/leonate/jxls-demo/src/63e0eadfbff1c566627dea8a0c118cd587c45da2/src/main/java/org/jxls/issue/jxls11/?at=master .

    But since I do not have the real data you use to fill in the template I removed all the placeholders to be able to process it.

    If you still have an issue it may be related to particular data you use. So please create a working in example where this fails so that I can reproduce it.

    It may be easier for you to use Issue11Demo.java from jxls-demo class (just fork the jxls-demo project and modify Issue11Demo class to demonstrate the issue). Or just create any working example with java code and template which I can run and see the error.

  3. Log in to comment