Problem with complex formulas

Issue #11 resolved
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(
        at java.util.ArrayList.get(
        at org.jxls.common.RowData.getCellData(
        at org.jxls.transform.AbstractTransformer.getCellData(
        at org.jxls.transform.AbstractTransformer.getTargetCellRef(
        at org.jxls.area.XlsArea.processFormulas(
        at controllers.PivotTable.exportExcel(
        at play.mvc.ActionInvoker.invokeWithContinuation(
        at play.mvc.ActionInvoker.invoke(
        at play.mvc.ActionInvoker.invokeControllerMethod(
        at play.mvc.ActionInvoker.invokeControllerMethod(
        at play.mvc.ActionInvoker.invoke(
        ... 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 .

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