we just recently upgraded to V7R3 and the HSSFFormulaEvaluator is not working. getting
Message . . . . : Java exception received when calling Java method.
Cause . . . . . : RPG procedure RATSUPXLS2 in program JAMAICA/RATSUPXLS2
received Java exception "java.lang.ArrayIndexOutOfBoundsException: Array
index out of range: -3" when calling method "evaluateAllFormulaCells" with
signature "(Lorg.apache.poi.hssf.usermodel.HSSFWorkbookV" in class
"org.apache.poi.hssf.usermodel.HSSFFormulaEvaluato r".
I'm opening up a .xls spreadsheet that has existing formulas in it. creating / updating other cells in the spreadsheet.
this did work using jdk60, now we have to use jdk70 or jdk80. I tried both and getting the same error message
We contacted the POI community and they suggested using the 'evaluateFormulaCell' method but I'm getting
Message . . . . : Java exception received when calling Java method.
Cause . . . . . : RPG procedure RATSUPXLS2 in program JAMAICA/RATSUPXLS2
received Java exception "java.lang.NoSuchMethodError:
org/apache/poi/hssf/usermodel/HSSFFormulaEvaluator.evaluateFormulaCell("
when calling method "evaluateFormulaCell" with signature
"(Lorg.apache.poi.hssf.usermodel.HSSFCellV" in class
"org.apache.poi.hssf.usermodel.HSSFFormulaEvaluato r".
this is my code to call this
D HSSFFormulaEvaluator_cell...
D PR ExtProc( *Java
D : 'org.apache.poi.hssf-
D .usermodel.HSSFFormulaEvaluator'
D : 'evaluateFormulaCell')
D static
D cellx like(HSSFCell)
any ideas on how this can be fixed ??
Message . . . . : Java exception received when calling Java method.
Cause . . . . . : RPG procedure RATSUPXLS2 in program JAMAICA/RATSUPXLS2
received Java exception "java.lang.ArrayIndexOutOfBoundsException: Array
index out of range: -3" when calling method "evaluateAllFormulaCells" with
signature "(Lorg.apache.poi.hssf.usermodel.HSSFWorkbookV" in class
"org.apache.poi.hssf.usermodel.HSSFFormulaEvaluato r".
I'm opening up a .xls spreadsheet that has existing formulas in it. creating / updating other cells in the spreadsheet.
this did work using jdk60, now we have to use jdk70 or jdk80. I tried both and getting the same error message
We contacted the POI community and they suggested using the 'evaluateFormulaCell' method but I'm getting
Message . . . . : Java exception received when calling Java method.
Cause . . . . . : RPG procedure RATSUPXLS2 in program JAMAICA/RATSUPXLS2
received Java exception "java.lang.NoSuchMethodError:
org/apache/poi/hssf/usermodel/HSSFFormulaEvaluator.evaluateFormulaCell("
when calling method "evaluateFormulaCell" with signature
"(Lorg.apache.poi.hssf.usermodel.HSSFCellV" in class
"org.apache.poi.hssf.usermodel.HSSFFormulaEvaluato r".
this is my code to call this
D HSSFFormulaEvaluator_cell...
D PR ExtProc( *Java
D : 'org.apache.poi.hssf-
D .usermodel.HSSFFormulaEvaluator'
D : 'evaluateFormulaCell')
D static
D cellx like(HSSFCell)
any ideas on how this can be fixed ??
Comment