We downloaded the latest version of poi-4.0.0 and are running that in conjunction with java 8.0. We previously used the hssfFormulaEvaluator(book); in our program when we were running poi 3.17 with java 5.0 32 bit. Everything worked. When we try to run now this is the only problem we seem to have. It was suggested this could be a bug. thank you. Message . . . . : Java exception received when calling Java method. Cause . . . . . : RPG procedure RATSUPXLS in program JAMAICA/RATSUPXLS received Java exception "java.lang.ArrayIndexOutOfBoundsException: Array index out of range: -2" when calling method "evaluateAllFormulaCells" with signature "(Lorg.apache.poi.hssf.usermodel.HSSFWorkbook;)V" in class "org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator".
If you temporarily switch from doing evaluate all, and instead loop over all the sheets then rows then cells yourself to evaluate each one individually, can you identify what the problematic formula is that triggers the bug? And/or can you upload the excel file you're using to trigger the exception?
no test case provided - reopen if you can provide one